Clario is seeking a Principal Analytics Engineer (Power BI Development) to design and deliver enterprise-grade analytics that power clinical trial execution, product intelligence, and operational decision-making. This role blends deep technical expertise with strategic problem-solving, serving as a hands-on architect, developer, and advisor to business and technology stakeholders. At Clario, our purpose is to transform lives by unlocking better evidence.
What You'll Do
- Develop and prototype cloud-native analytics solutions using Power BI (Desktop, Service), DAX, Power Query (M), dataflows, deployment pipelines, and Snowflake components.
- 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.
- 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.
- Champion quality, standards, and continuous improvement through architecture/code reviews, operational documentation, and usage/cost awareness.
- Research emerging cloud analytics capabilities and ensure compliance with required training and SOPs.
What We're Looking For
- Bachelor’s degree in Computer Science, Information Technology, or equivalent professional experience.
- 5+ years delivering data warehousing/analytics solutions.
- 3+ years with Power BI and Snowflake in production.
- 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.
- Experience operationalizing cloud BI (scheduling, orchestration, monitoring, alerts, SLA management).
- Understanding of security, data architecture, analytics engineering, and structured SDLC practices.
- Excellent analytical, communication, documentation, and problem-solving abilities.
- Ability to work independently and collaboratively; adaptable, detail-oriented, and committed to high-quality outcomes.
- Based in India and able to work remotely.
Nice to Have
- Experience in healthcare/life sciences data.
- Experience with cloud platforms (Azure/AWS/GCP) and modern lake/lakehouse architectures.
- Exposure to Data Governance, Stewardship, and MDM concepts; Reltio experience is a plus.
- MS SQL Server experience is a plus.
Technical Stack
- Power BI, DAX, Power Query (M), Snowflake, SQL
- Oracle, MS SQL Server
- Azure, AWS, GCP, ServiceNow
Benefits & Compensation
- Competitive pay and incentives
- Provident fund and medical insurance
- Engaging employee programs and local events
Work Mode
This is a remote position open to candidates based in India.
Clario is an equal opportunity employer.
