Junior Analytics Engineer

Junior Analytics Engineer

Position Overview: We are looking for a Junior Analytics Engineer to join our Sales Operations & Analytics team within Commercial Operations. In this role, you will help build and maintain the data infrastructure that powers business decisions across the organization, from pipeline development and data transformation through semantic modeling and reporting in Power BI. You will work closely with the Manager of Sales Operations & Analytics to transform raw data into reliable, well-documented datasets that support commercial leadership, sales teams, and cross-functional stakeholders. This is a high-growth opportunity for someone early in their data career who wants hands-on experience with modern data engineering practices in a pharmaceutical environment.

What You'll Do:

• 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

What We're Looking For Required:

• 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

Preferred:

• 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)

Physical Requirements:

• Occasional travel required (up to 10%)

General Statement Mayne Pharma is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.