Job Description & Details
The demand for data‑driven decision‑making in healthcare is soaring, making BI roles more critical than ever. As a Senior Power BI/Tableau Developer you’ll shape analytics for a state health platform, directly impacting public health outcomes. This position offers a unique blend of advanced visualization, ETL mastery, and cloud data warehousing—all in a hybrid Austin setting.
Job Summary
We are seeking a seasoned Senior BI Developer/Data Engineer to design, develop, and maintain end‑to‑end data pipelines and interactive dashboards using Informatica (IICS), Power BI or Tableau, and SQL. The role focuses on delivering scalable analytics solutions for a state health platform, leveraging Snowflake for cloud warehousing and ensuring data quality and performance.
Top 3 Critical Skills Table
| Skill | Why it's critical | Mastery Level |
|---|---|---|
| Informatica (ETL/IICS) | Core engine for extracting, transforming, and loading health data across systems | Senior |
| Power BI / Tableau | Primary tools for visualizing insights and enabling self‑service analytics | Senior |
| Snowflake (or SQL & Data Pipelines) | Provides the scalable cloud data warehouse that powers fast query performance | Senior |
Interview Preparation
- Explain how you would design an end‑to‑end ETL workflow in Informatica IICS for ingesting patient encounter data.
What the interviewer is looking for: Understanding of source profiling, mapping design, performance tuning, error handling, and orchestration. - Walk through the steps to optimize a Power BI dashboard that queries a large Snowflake table.
What the interviewer is looking for: Knowledge of query folding, aggregations, incremental refresh, and DAX performance tricks. - Describe a scenario where you had to migrate an on‑premise data warehouse to Snowflake. What challenges did you face and how did you resolve them?
What the interviewer is looking for: Experience with data modeling changes, data loading strategies, security considerations, and cost optimization. - How do you ensure data quality and lineage when building pipelines that combine multiple source systems?
What the interviewer is looking for: Use of data profiling, validation rules, metadata management, and documentation practices. - Compare Tableau vs. Power BI for a large‑scale health analytics project. Which would you choose and why?
What the interviewer is looking for: Ability to evaluate tool strengths, licensing, integration with Snowflake, and end‑user adoption.
Resume Optimization
- Senior BI Developer
- Data Engineer
- Informatica IICS
- Power BI
- Tableau
- SQL
- Snowflake
- Data Pipelines
- ETL Development
- Healthcare Analytics
Application Strategy
When reaching out to the recruiter, send a concise email that opens with a friendly greeting, attaches your updated resume, and clearly maps your experience to the role. Highlight your top skills—such as Informatica, Power BI/Tableau, and Snowflake—and reference specific projects where you built data pipelines or health‑focused dashboards. Make sure to mention your 12+ years of BI experience and your ability to work hybrid in Austin.
Career Roadmap
| Current Role | Typical Experience | Core Focus | Next Position |
|---|---|---|---|
| Senior BI Developer / Data Engineer | 10‑12+ years, strong ETL & visualization expertise | End‑to‑end data pipelines, dashboard strategy, cloud warehousing | Lead BI Architect (15+ years, cross‑team leadership, strategic roadmap) |
| Lead BI Architect | 15‑18 years, enterprise‑scale analytics governance | Architecture, stakeholder alignment, technology selection | Director of Analytics (20+ years, business impact, portfolio management) |
| Director of Analytics | 20+ years, P&L responsibility, innovation leadership | Organizational analytics vision, budget, talent development | VP of Data & Insights (Executive leadership, enterprise transformation) |