Note: The job is a remote job and is open to candidates in USA. 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 powers business decisions across the organization, focusing on data transformation and reporting in Power BI.
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
Skills
- 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)
Company Overview
Mayne Pharma Group, a specialist pharmaceutical company, optimizes and delivers oral drugs. It was founded in 1845, and is headquartered in Salisbury, New South Wales, AUS, with a workforce of 201-500 employees. Its website is http://www.maynepharma.com.Company H1B Sponsorship
Mayne Pharma has a track record of offering H1B sponsorships, with 3 in 2022, 1 in 2020. Please note that this does not guarantee sponsorship for this specific role.