Data Engineer – SQL

MUST BE A RESIDENT OF State of Washington or Oregon

We're hiring for a Data Engineer to develop and optimize complex SQL and T-SQL queries within our Microsoft Fabric environment, supporting data pipelines, reporting, and analytics across Lakehouses, Warehouses, and SQL Server systems. This role emphasizes strong SQL development skills to support data transformation, reporting, and analytics workflows. Will work closely with cross-functional teams to ensure data accuracy, troubleshoot query and data issues, and contribute to scalable and secure data solutions.

Hiring Range: $87,600/yr to $112,000.00/yr

Key Responsibilities:

• Build and debug advanced SQL/T-SQL queries for data transformation and reporting
• Integrate data from third-party systems (e.g., EHRs, ERP systems, Workday, Prophix) into Microsoft Fabric using T-SQL-based dataflows and pipelines.
• Tune performance and troubleshoot query bottlenecks
• Implement security controls aligned with HIPAA compliance
• Collaborate with analysts and BI teams to ensure reliable data access

SKILLS AND ABILITIES:

Required:

• Bachelor's degree in computer science, Information Systems, or a related field, or equivalent combination of education and professional experience.
• 3+ years of experience writing and debugging SQL and T-SQL queries in SQL Server environments.
• 1+ years of hands-on experience working with Microsoft Fabric Lakehouses or Warehouses.
• Strong understanding of relational database design, data modeling, and ETL principles.
• Ability to perform data comparison and reconciliation tasks using T-SQL, including checksum and row-level logic.
• Strong analytical skills with attention to data accuracy, performance, and integrity.

Preferred:

• Experience working with Azure Synapse, Azure Data Factory, or Power BI in conjunction with Fabric.
• Knowledge of healthcare data standards (HL7, FHIR, DICOM) and data security regulations like HIPAA.
• Experience working with data from healthcare, finance, and Workday systems.
• Microsoft certification such as Azure Data Engineer Associate.
• Familiarity with scripting for data workflows (e.g., PowerShell, Python) is a plus.

Pay Range:

The above information is intended to indicate the general nature and level of work required in this position. It is not designed to contain or be interpreted as a comprehensive description of all duties, responsibilities, and qualifications required of those assigned to this job.

We offer a competitive Total Rewards Program. Eligibility for benefits is dependent on factors such as position type and FTE.  Benefit-eligible employees qualify for benefits beginning on the first of the month following one month of employment. Vancouver Clinic offers medical, dental, vision, life insurance, AD&D, long term disability, health savings account, flexible spending account, employee assistance program, and multiple supplemental benefits (voluntary life, critical illness, accident, hospital indemnity, identity theft protection, legal services, etc.). We also offer a 401k retirement plan, with employer contributions after your first year of employment. Benefits-eligible employees accrue PTO and Personal Time based on hours worked and State worked, totaling 120 hours in the first year for full time staff and 200 hours in the first year for full time supervisors and above, increasing in subsequent years. PTO and Personal Time accruals are pro-rated by FTE/hours worked.  Non-benefits eligible employees will accrue Personal Time based on hours worked and State worked. Employees will also enjoy up to six paid holidays per year, depending on schedule. Contact your recruiter for more information.

Vancouver Clinic is proud to be an Equal Opportunity Employer. Vancouver Clinic does not discriminate on the basis of race, color, gender, disability, veteran, military status, religion, age, creed, national origin, gender identity or expression, sexual orientation, marital status, genetic information, or any other basis prohibited by local, state, or federal law.

Vancouver Clinic is an alcohol and drug-free workplace.  Offers are contingent on successful completion of background screen and immunization requirements.