Principal Analytics Engineer, Power BI Development

Role Overview

• 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.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or equivalent professional experience.
• 5 to 8 years delivering data warehousing/data analytics solutions, including 3 to 4 years with Power BI and Snowflake.
• Proven success designing enterprise dashboards and user‑centric analytic solutions.
• Expertise in Power BI development (DAX, Power Query, semantic modeling, dataflows, RLS/OLS, incremental refresh, deployment pipelines).
• Strong Snowflake capabilities (database/warehouse design, RBAC, warehouse optimization, tasks/streams, resource monitors, cost management).
• Strong SQL and relational modeling skills (Snowflake, Oracle; MS SQL Server a plus).
• Experience operationalizing cloud BI (scheduling, orchestration, monitoring, alerts, SLA management).
• Exposure to Data Governance, Stewardship, and MDM concepts; Reltio experience is a plus.
• Understanding of security, data architecture, analytics engineering, and structured SDLC practices.
• Experience in healthcare/life sciences data is preferred.
• Experience with cloud platforms (Azure/AWS/GCP) and modern lake/lakehouse architectures is a plus.
• Excellent analytical, communication, documentation, and problem‑solving abilities.
• Ability to work independently and collaboratively; adaptable, detail‑oriented, and committed to high‑quality outcomes.
• Strong analytical, organizational, verbal, and business writing skills
• Excellent problem‑solving, debugging, and troubleshooting; flexible and detail‑oriented.
• Strong collaboration skills with developers, product managers, testers, and business stakeholders.
• Familiarity with medical/clinical trial terminology is desirable.

Tech Stack

• AWS
• Azure
• Cloud
• ETL
• Google Cloud Platform
• MS SQL Server
• Oracle
• SDLC
• ServiceNow
• SQL

Benefits

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