BI Developer

SOFIE•Dulles Town Center, VA

21h

About The Position

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.

Requirements

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.

Nice To Haves

Experience in the pharmaceutical or regulated industry is preferred.

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.