Principal Analytics Engineer (Power BI Development)

Clario is accelerating its cloud‑native analytics transformation, and this role sits at the center of that mission. As a Principal Analytics Engineer (Power BI), 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. This role blends deep technical expertise with strategic problem‑solving: you will serve as a hands‑on architect, developer, and advisor to business and technology stakeholders, shaping how Clario uses data to improve efficiency, accelerate evidence generation, and enhance product and service outcomes. Your work will directly contribute to faster, more accurate decisions that impact patients, customers, and internal teams worldwide.

What We Offer

• Competitive pay and incentives

• Provident fund and medical insurance

• Engaging employee programs and local events

• Modern office spaces and remote work flexibility

What You’ll Be Doing

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

What We Look For

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

• Based in India and able to work remotely.

Must-Have

Strong expertise in:

• Power BI Desktop (DAX, data modeling, parameters, row-level security)

• Tableau Desktop and Tableau Server

• Power BI Service (workspace management, gateways, refresh scheduling)

• SQL (complex joins, window functions, aggregations, CTEs)

•  Semantic model best practices (star schema, relationship management, incremental refresh) 

• Familiarity with Power Query (M) for ETL inside Power BI

• Knowledge of GitLab workflows – branching, committing, pushing, merge requests.

• Exposure to Jira in Agile/Scrum environments.

• Excellent communication and analytical skills.

Good-to-Have

• Experience with ETL or data pipelines.

• Familiarity with cloud platforms like Azure or AWS (e.g., Azure SQL, Data Factory).

• Knowledge of CI/CD practices for BI deployments

At Clario, our purpose is to transform lives by unlocking better evidence. It’s a cause that unites and inspires us. It’s why we come to work—and how we empower our people to make a positive impact every day. Whether you're advancing clinical science, building innovative technology, or supporting our global teams, your work helps bring life-changing therapies to patients faster.