Senior Data Analyst: ETL, SQL & Power BI

Medix Infusion; Addison (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health and life insurance

401(k) plan

Paid time off

Dental/Vision

Job summary

Medix Infusion is seeking a dedicated Senior Data Analyst to join our team in Addison, TX. The role focuses on delivering data-driven insights, building ETL pipelines, and developing analytical models to support patient-focused healthcare initiatives.

You will leverage SQL, Python, and Power BI to provide actionable insights, collaborate across teams, and present executive-ready analyses, all while handling sensitive PHI within a HIPAA-regulated environment.

Qualifications

• Bachelor's degree in a related field or equivalent practical experience.
• 5+ years of experience as a Data Analyst or related role, including senior or lead-level work.
• Excellent communication and presentation skills; ability to explain complex technical concepts to non-technical stakeholders.
• Strong analytical thinking and problem-solving skills.
• Ability to work independently and manage multiple projects simultaneously.
• Strong SQL coding skills, including complex queries, stored procedures, and performance tuning.
• Proficiency in Python for data analysis, scripting, and automation.
• Experience building ETL/ELT pipelines, including extracting data from REST and BI-platform APIs and loading it into a relational data warehouse.
• Experience designing and scheduling data pipelines in Azure Data Factory or SSIS.
• Experience building automated, spec-compliant outbound data feeds for external partners with secure transfers.
• Knowledge of PHI de-identification and HIPAA security.
• Hands-on Power BI with dashboards and reporting, including DAX.
• Advanced Excel skills including financial modeling and recurring deliverables.
• Experience with cloud-based relational databases and data warehouses; Azure SQL / Synapse preferred; Snowflake/BigQuery/Redshift also considered.
• Solid understanding of data management principles and data quality best practices.

Responsibilities

• Conduct complex data analysis to support business operations and initiatives.
• Develop and maintain SQL queries, stored procedures, and load processes for data extraction, transformation, and analysis.
• Design, build, and maintain ETL/ELT pipelines to integrate source-system and BI-platform data into Azure SQL Server.
• Design and maintain automated processes that generate partner-specified data files and deliver them securely to external SFTP endpoints.
• Use Python for statistical analysis, data manipulation, and automation tasks.
• Create interactive visualizations and reports using Power BI, including proficiency in DAX.
• Build and maintain financial models, recurring workbooks, and executive-facing deliverables in Excel.
• Manage data sources, including extraction, transformation, and loading (ETL) processes.
• Collaborate with cross-functional teams to understand data needs and deliver actionable insights.
• Translate business requirements into technical requirements and data models.

Skills

SQL

Python

Power BI

Excel

ETL pipelines

Data modeling

Data warehousing

Communication

HIPAA knowledge

Education

Bachelor's degree in Computer Science, Data Analytics, Statistics, Mathematics, Economics, or related field

Tools

Azure Data Factory

Looker/LookML

Azure SQL Server

Azure Synapse

Job description

Medix Infusion is seeking a dedicated Senior Data Analyst to join our team in Addison, TX. The role focuses on delivering data-driven insights, building ETL pipelines, and developing analytical models to support patient-focused healthcare initiatives.

You will leverage SQL, Python, and Power BI to provide actionable insights, collaborate across teams, and present executive-ready analyses, all while handling sensitive PHI within a HIPAA-regulated environment.