BI Developer

Job Title: BI Developer

POSITION SUMMARY:

The Business Intelligence (BI) Developer is responsible for transforming data into actionable insights that drive business value and support data-driven decision-making across the organization. This role supports the full lifecycle of BI initiatives-from requirements gathering and data analysis to solution design, development, testing, deployment, and user enablement. The BI Developer will build and maintain enterprise-grade Power BI reports and dashboards within an Azure-based data platform.

GENERAL DUTIES AND RESPONSIBILITIES:

• Participate in all phases of BI initiatives, including requirements gathering, design, development, testing, deployment, and ongoing support.
• Extract, transform, and analyze data from multiple sources using SQL and other data query tools.
• Translate business requirements into BI solution designs, including wireframes, mockups, and data models.
• Design, develop, and maintain interactive Power BI reports and dashboards that clearly communicate complex metrics to both technical and non-technical stakeholders.
• Define, track, and analyze key performance indicators (KPIs) and trends to support strategic planning and operational efficiency.
• Perform data validation, reconciliation, and quality assurance testing to ensure accuracy, reliability, and consistency of BI deliverables.
• Support User Acceptance Testing (UAT) and ensure solutions meet business requirements and usability standards.
• Develop and maintain documentation, including data definitions, mappings, transformations, dashboard logic, and user guides.
• Collaborate closely with data engineers and technical teams to ensure data models and pipelines meet reporting and analytics needs.
• Present insights and findings to stakeholders in clear, actionable formats (visual, written, and verbal).
• Respond to ad-hoc reporting and data analysis requests from business users.
• Work independently with minimal supervision while managing assigned tasks and priorities effectively.
• Travel up to 10% domestically, as required.

Skills & QUALIFICATIONS

• Bachelor's degree in business, Information Systems, Computer Science, Data Analytics, or a related field.
• 5+ years of experience as a BI Developer or in a similar analytics role.
• 5+ years of hands-on experience developing solutions using Power BI.
• Strong proficiency in SQL, including the ability to write and optimize complex queries.
• Demonstrated experience with data analysis to identify gaps, issues, and data requirement
• Experience with wireframing solutions, KPI development, and data storytelling techniques.
• Good Understanding data modeling concepts, including dimensional modeling.
• Hands-on experience with data validation, testing, and reconciliation processes.
• Experience with data warehousing and ETL processes, including DAX and Power Query.
• Experience working within Microsoft Azure and related services, including Azure Synapse, Azure Data Factory, and Azure Data Lake, and PySpark (preferred).
• Proven ability to create clear and comprehensive documentation, including business requirements, transformations, test cases, and user guides.
• Strong analytical, problem-solving, and organizational skills.
• Excellent communication skills, with the ability to collaborate across technical and non-technical teams.
• Ability to explain technical concepts to non-technical audiences clearly and effectively.
• High attention to detail and a strong commitment to data accuracy and quality.
• Experience in the pharmaceutical or regulated industry is preferred.