Mayne Pharma

Junior Analytics Engineer

Mayne Pharma  •  United States (Onsite)  •  3 months ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description

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 ForRequired:
  • 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 StatementMayne 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. 
Mayne Pharma

About Mayne Pharma

Mayne Pharma is an ASX-listed specialty pharmaceutical Company (ASX: MYX) focused on commercializing novel and generic pharmaceuticals. We offer patients better, safe and more accessible medicines.

Mayne Pharma has a 40-year track record of innovation and success in developing oral drug delivery systems. These technologies have been successfully commercialized in numerous products that continue to be marketed around the world.

Mayne Pharma also has a full service contract development and manufacturing organizations (CDMO) servicing clients worldwide: Mayne Contract Services is based in Salisbury, SA, Australia

Here are some key facts about our company:

• 400+ staff

• A$500m+ market cap

• A$400m+ in revenue (FY22)

• A product portfolio of 90+ marketed products globally

The Company's corporate values are:

• Empowerment – encouraging everyone to take initiative, enabling growth and achievement.

• Passion – showing pride, enthusiasm and dedication in everything we do.

• Creativity – delivering value and striving to connect new ideas with business realities.

• Agility – operating with timeliness as well as mental, emotional and physical flexibility.

• Integrity – maintaining high ethical standards, demonstrating honesty, and respecting fairness by doing the right thing, even when no one is looking.

• Accountability – accepting our individual and team responsibilities, meeting our commitments, and acknowledging and learning from mistakes.

To learn more, visit us at www.maynepharma.com. Our social media policy: https://bit.ly/3py3L1e

Any communication you receive from Mayne Pharma will never come from a personal email domain or chat service such as "gmail" or "Google Chat". All official communication from Mayne Pharma will be received from our company email domain - @maynepharma.com.

Industry
Chemicals & Materials
Company Size
501-1,000 employees
Headquarters
Salisbury South, AU
Year Founded
Unknown
Website
maynepharma.com
Social Media