Data Engineer

Melville,NY - USA

Position Requirements

This role is predominantly focused on loading and transforming data in the Microsoft stack – Azure Synapse dedicated pool, SQL Server, Azure SQL DB, Azure Managed SQL Instance, and Cosmos. It also focuses on development work mostly in ADF and Powershell and maintaining and creating ETL/ELT infrastructure along with query tuning and some design work.

PRIMARY RESPONSIBILITIES

• Partner closely with product managers, engineers, and business leaders to Determine data needs and issues and to code for what is needed
• Work with other members of the department to provide new insights into issues and to foster professional growth.
• Debug and optimize SQL.
• Develop scalable data pipelines and deploy machine learning models into production environments.

REQUIRED QUALIFICATIONS

• 1 Year Experience.
• SQL Server and at least 1 additional DBMS.
• Azure Cloud experience/SQL Server on VM/Managed DBs/Azure SQL/ Azure Synapse dedicated Pools.
• Azure Data Factory.
• Ability to write, understand, and optimize SQL.
• Experience with SQL backup and recovery.
• Experience with columnstore indexes.
• Knowledge of data modeling, dimensional modeling, and warehousing concepts.
• Ability to document projects, data transformations and databases.
• Experience with Powershell for pulling or pushing data and automating SQL Server related tasks.
• Exposure to Power BI.
• Experience with Python
• At least 2 of the following:

PySpark

DBT

Data Quality automation

MS Fabric with curated delta/medallion architecture

DESIRED/PREFERRED QUALIFICATIONS

• Experience with Anesthesia billing and claims
• Experience with Finance and Accounting
• Experience with HR/Workday
• Experience with Medical Quality
• Experience with data quality / MIPS

Total Rewards

• Generous benefits package, including:
• Salary: $92,459.75 - $127,132.15
• Paid Time Off
• Health, life, vision, dental, disability, and AD&D insurance
• Flexible Spending Accounts/Health Savings Accounts
• 401(k)
• Leadership and professional development opportunities

EEO Statement

North American Partners in Anesthesia is an equal opportunity employer.