Mayne Pharma is seeking a Junior Analytics Engineer to join their Sales Operations & Analytics team within Commercial Operations. In this role, you will help build and maintain the data infrastructure that supports business decisions across the organization, focusing on transforming raw data into reliable datasets for commercial leadership and sales teams.
Responsibilities:
- 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
Requirements:
- 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)