Junior Analytics Engineer

Description

• Write and maintain SQL views and transformations to move data through our medallion architecture (Bronze → Silver → Gold) within Microsoft Fabric
• Build and maintain Power Query (M) dataflows for ingesting and transforming data from internal and third-party sources
• Support the development of Power BI semantic models, including writing DAX measures for sales performance, territory analytics, and prescriber-level reporting
• Assist with incentive compensation data processing for approximately 150 sales representatives
• Help maintain dimensional models with proper surrogate keys, fact/dimension relationships, and business logic
• Document data models, transformation logic, and business rules to support team knowledge sharing
• Contribute to data quality monitoring, validation, and issue resolution
• Support version-controlled development workflows using Git and PBIP format

• 1–3 years of experience in a data-focused role (analyst, data engineer, BI developer, or similar)
• Strong SQL proficiency — you should be comfortable writing queries, joins, aggregations, and window functions
• Curiosity and willingness to learn new tools and frameworks quickly
• Strong communication skills — ability to work with both technical and non-technical stakeholders
• Attention to detail and a methodical approach to problem-solving

• Experience with Power Query (M) for data transformation
• Familiarity with Power BI and DAX or equivalent BI Tools
• Exposure to dimensional modeling concepts (star schema, fact and dimension tables)
• Experience with Microsoft Fabric or other cloud data platforms
• Familiarity with Git or other version control systems
• Pharmaceutical, life sciences, or healthcare industry experience
• Microsoft certifications such as DP-600 (Fabric Analytics Engineer Associate), PL-300 (Power BI Data Analyst), or DP-900 (Azure Data Fundamentals) 

• Occasional travel required (up to 10%)