Principal Analytics Engineer (Power BI Development)

As a Principal Analytics Engineer (Power BI Development), you will design and deliver enterprise-grade analytics that power clinical trial execution, product intelligence, and operational decision-making across the organization. You will build integrated visualizations and governed semantic models on Snowflake and complementary cloud platforms—turning complex, disparate data into actionable insights that teams rely on every day.

Requirements

• Develop and prototype cloud-native analytics solutions using Power BI (Desktop, Service), DAX, Power Query (M), dataflows, deployment pipelines, and Snowflake components including schemas, virtual warehouses, roles, tasks/streams, and performance services.
• Lead full-cycle development (SDLC + agile) of secure, scalable, and cost-efficient analytics, including design, build, test, documentation, and support.
• Implement governance controls including row-level and object-level security, data endorsements, versioning, and reliable refresh pipelines.
• Perform source-to-target mapping and design star/snowflake models optimized for analytics and semantic modeling.
• Build semantic layers and governed calculation frameworks (DAX measures, calculation groups).
• Optimize model and query performance using aggregations, incremental refresh, model size tuning, and Snowflake performance strategies (clustering, caching).
• Write medium to complex SQL queries for data validation, quality checks, and in-depth analysis.
• Operationalize production pipelines, schedules, workflows, alerting/monitoring, and SLAs.
• Provide Level 3 support (ServiceNow), including triage, root-cause analysis, and stable release management.
• Partner with business and technical stakeholders to define requirements, lead design workshops, and produce actionable prototypes and wireframes.
• Design high-value dashboards, reports, and analytics that provide product insights and operational decision support.
• Own end-to-end design for visualization, reporting, and dashboard solutions that power product insights and operational decision-making.
• Communicate proactively with teams and stakeholders; escalate risks early to ensure on-time delivery.
• Champion quality, standards, and continuous improvement through architecture/code reviews, operational documentation, and usage/cost awareness across workloads.
• Research emerging cloud analytics capabilities and ensure compliance with required training and SOPs (e.g., GCP, 21 CFR Part 11, CAPA).
• Explore new opportunities to add value through automation, standardization, and measurement.
• Support teammates to achieve shared outcomes; perform other duties as assigned.
• Maintain version-controlled BI assets using GitLab (commit, push, merge requests, resolving conflicts).
• Use Jira for sprint planning, task updates, story tracking, and collaboration within Agile teams.
• Collaborate with data engineering teams to ensure accurate and consistent data flows.
• Support root-cause analysis for data discrepancies reported by business users.
• Participate in patch releases, including validation, deployment coordination, and documentation
• Maintain strong, current knowledge of cloud analytics, Power BI, Snowflake, data engineering patterns (ELT/ETL), data governance, and security.

Benefits

• Competitive pay and incentives
• Provident fund and medical insurance
• Engaging employee programs and local events
• Modern office spaces and remote work flexibility

Tagged as: Power BI