We are looking for a data engineer to own the backend that powers our Tableau and Power BI dashboards. You will work heavily with AdvancedMD via ODBC, write complex SQL, and turn raw data into reliable models that the team can build on.

What you will do

• Set up and maintain ODBC connections to AdvancedMD and other sources
• Design data models, views, and stored procedures for analytics use
• Write complex SQL for joins, window functions, aggregations, and incremental loads
• Build and run ETL or ELT pipelines using Python or SQL based tooling
• Create clean tables for BI with clear definitions and a basic data dictionary for AdvancedMD tables
• Optimize query performance through indexing, partitioning, and query rewrites
• Monitor data quality with checks, alerts, and issue logs
• Work with BI developers to replicate and extend existing dashboards
• Document logic so another engineer or analyst can pick it up fast
• Handle access control and protect PHI with good data hygiene

Must have

• 1-3 years of experience in a simillar role
• Strong SQL skills and comfort with complex scripting
• Experience working with ODBC data sources
• Hands on work with at least one relational database such as SQL Server, PostgreSQL, or MySQL
• Experience building production data pipelines or workflows
• Solid understanding of data modeling concepts for analytics
• Familiarity with Tableau or Power BI data prep and publishing
• Habit of writing clear documentation and version controlling changes

Nice to have

• Experience with AdvancedMD or other healthcare practice management or EHR systems
• Python for ETL, APIs, and automation
• Orchestration tools such as Airflow or Azure Data Factory
• Performance tuning on large tables and slow queries
• Knowledge of HIPAA and handling of PHI