> Markdown version of [/jobs/ext/2976673-sr-analytics-developer](https://www.wearedevelopers.com/jobs/ext/2976673-sr-analytics-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr Analytics Developer - **Company:** Promega Corporation - **Location:** Madison, WI, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Business Analytics Applications, Data Analysis, Microsoft Azure, Business Intelligence Development, Code Review, Information Systems, Information Engineering, Data Structures, Database Queries, Decision Support Systems, Dimensional Modeling, Microsoft Office, Microsoft Software, SAP ERP, Power BI, SAP (Applications), Software Requirements Analysis, Data Server Interface, Cloud Platform System, Microsoft Power Automate, Delivery Pipeline, Large Language Models, Prompt Engineering, Data Lakes, Information Technology, SAP S/4HANA, Tools for Reporting, Data Pipelines, Powerapps, Databricks - **Published:** September 18, 2026 - **Apply:** https://careers.promega.com/jobs/4354?lang=en-us ## About the Role 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. ## Description 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [DB UX Design System – How we’ve open sourced our largest inner source project](https://www.wearedevelopers.com/videos/819-db-ux-design-system-how-we-ve-open-sourced-our-largest-inner-source-project) - [Headless by Design: Building Enterprise Systems That Agents Can Actually Use](https://www.wearedevelopers.com/videos/100092-headless-by-design-building-enterprise-systems-that-agents-can-actually-use) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)