Sr Analytics Developer

Promega Corporation; Madison (WI); On-site; USD 110,000 - 165,000; Full time

Job summary

Promega Corporation is seeking a Sr AI Analytics Developer to own the design of Power BI reports, data models, and AI-powered conversational analytics. You will drive reporting solutions across business domains, mentor teammates, and help implement emerging AI tools.

You will work with stakeholders to define KPIs, ensure scalable semantic models, and push adoption of AI-enhanced analytics across a global life sciences company.

Qualifications

• Experience delivering production-grade Power BI solutions with complex DAX and semantic modeling.
• Hands-on experience with conversational analytics, natural language querying, or AI interfaces.
• Strong SQL skills and familiarity with cloud data platforms.
• Ability to translate business needs into technical specs and governance.

Responsibilities

• Design and deliver Power BI reports and dashboards across business domains.
• Develop data models using dimensional design principles and ensure accuracy.
• Contribute to AI-powered conversational analytics initiatives.
• Mentor peers and promote team standards for BI and AI work.
• Collaborate with stakeholders to define KPIs and requirements.

Skills

Power BI

DAX

SQL

Azure Databricks

LLM integration

Semantic modeling

Data modeling

Communication

Multitasking

Education

Associate's degree in data-related field

Bachelor's degree in a data-related field

Tools

Claude

Copilot for Power BI

Azure OpenAI

LangChain

Semantic kernel frameworks

Job description

OUR TEAM:

We are a small, mixed-skill team of developers, analysts, and data specialists responsible for Promega's enterprise analytics platform - spanning Power BI reporting, data integration, and a modern cloud-based data platform built on Azure Databricks. We work directly with business stakeholders across the company to turn complex data into decisions, and we are currently expanding into AI-powered conversational analytics. The team operates with a high degree of ownership and autonomy - this is not a place where you wait to be told what to do.

YOUR ROLE:

You will own the design and delivery of Power BI solutions across assigned business domains - working directly with stakeholders to understand their needs, building models that are accurate and scalable, and making sure the people who use your reports actually trust them. At the same time, you will be a key contributor to our Conversational Analytics initiative, helping business users query data in natural language through AI-powered interfaces built on top of our semantic layer. This is not a support role or a report factory - you will have real influence over how analytics gets built and adopted at a global life sciences company, and the work you deliver will be visible at many levels of the organization.

JOB OBJECTIVE:

As a Sr AI Analytics Developer, you will design and deliver data models, Power BI reports, dashboards, and conversational analytics solutions that support Promega's global business requirements. You will independently own the delivery of reporting solutions in your assigned business domains - partnering directly with stakeholders, applying team standards, mentoring less experienced developers, and contributing to the adoption of emerging AI-powered analytics capabilities, including natural language interfaces to business data. This role sits at the intersection of traditional BI development and next-generation conversational analytics.

CORE DUTIES:

1. Power BI & Reporting Development: Design and deliver reports, dashboards, and semantic models in Power BI. Build solutions that span a broad spectrum of user needs - from executive-level summary views to self-service exploration for advanced users. Ensure models are performant, governed, and scalable.
2. Conversational Analytics Development: Design, build, and maintain conversational analytics interfaces that allow business users to query data in natural language. Work with LLM-based tooling (such as Claude) and Power BI semantic layer integrations to deliver AI-powered Q&A experiences. Evaluate and recommend emerging tools in this space.
3. Requirements Definition: Conduct requirements gathering with business stakeholders to define reporting needs, KPIs, and conversational query use cases. Translate ambiguous business problems into clear technical specifications, engaging team leadership when scope spans multiple teams or systems.
4. Data Modeling: Create and maintain underlying data models using Kimball dimensional design principles or equivalent. Understand source system structures (SAP, CRM) well enough to design accurate, trustworthy models.
5. Training & Enablement: Train business users on Power BI and conversational analytics tools. Develop training materials in written and video format. Promote self-sufficiency and drive adoption, particularly among non-technical Finance and Operations users.
6. Mentorship & Standards: Mentor less experienced developers through pairing, code review, and knowledge sharing. Apply and help refine team standards for both traditional BI and AI-augmented analytics development.
7. Decision Support: Use knowledge of the data to support business leaders in making key decisions. Serve as a trusted advisor, not just a report builder.
8. Incident Monitoring: Monitor, communicate, and resolve data and reporting incidents in a timely manner. Own quality across the reports and models you deliver.
9. Process & Tool Improvement: Proactively identify and implement process improvements within your areas of ownership. Evaluate new reporting and analytics tools, including AI-assisted development capabilities, and recommend adoption to the team.
10. Demonstrates inclusion through their own words and actions and is accountable for a safe workspace. Acts with kindness, curiosity, and respect for others.
11. Embraces and incorporates Promega's 6 Emotional & Social Intelligence (ESI) core principles in daily work.
12. Understands and complies with ethical, legal, and regulatory requirements applicable to our business.

KEY QUALIFICATIONS:

1. Associate's degree in a data-related field (Computer Science, Information Systems, Statistics, or equivalent) or proven work experience that ensures you are ready to be successful in this role.
2. 5-7 years of experience in business analytics, BI development, or data engineering.
3. Demonstrated experience delivering production-grade Power BI solutions, including complex DAX, semantic model design, and deployment pipelines.
4. Hands‑on experience with conversational analytics, natural language querying, or LLM‑based data interfaces (e.g., Claude, Copilot for Power BI, Azure OpenAI, Power BI, or similar).
5. Advanced proficiency in Power BI (data modeling, DAX, deployment, workspace management).
   • Strong SQL skills for data querying, transformation, and analysis.
   • Familiarity with lakehouse or cloud data platform patterns (Azure Databricks, Delta Lake, or equivalent).
   • Experience integrating LLM or AI tools into analytics workflows - whether through APIs, connectors, or prompt engineering.
   • Understanding of dimensional modeling (Kimball or equivalent).
6. Excellent interpersonal and communication skills. Ability to translate technical concepts for non-technical audiences and build trust with business stakeholders.
7. Strong analytical thinking. Comfortable working with ambiguous requirements and evolving business needs.
8. Proven ability to manage multiple priorities and coordinate your own delivery work across teams without a dedicated project manager.
9. Demonstrated proficiency in digital tools and technology, including Microsoft applications and mobile platforms, with the ability to adapt and leverage emerging technologies, such as artificial intelligence, to improve efficiency, automation, and collaboration.

PREFERRED QUALIFICATIONS:

1. Bachelor's degree in a data-related field (Computer Science, Information Systems, Statistics, or equivalent).
2. Experience with Azure OpenAI Service, LangChain, or semantic kernel frameworks.
3. Familiarity with S/4HANA or SAP ECC data structures and reporting patterns.
4. Experience with Python for data transformation, API integration, or AI pipeline development.
5. Knowledge of other Power Platform tools (Power Apps, Power Automate).
6. Relevant experience in the Life Sciences industry.

PHYSICAL DEMANDS:

1. Ability to remain stationary at a computer workstation for several hours at a time.
2. Ability to use a computer and standard Microsoft Office applications.
3. Ability to travel as needed.

At Promega, we value diversity and strive to create an inclusive workplace. We are proud to be an Equal Opportunity Employer, making employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability, or any other protected class.