Data Engineer (On-Site, Portland, OR)
Marquis Companies · Portland, OR · 2 wk ago
Information TechnologyFull-time
Job Responsibilities
- Build and maintain data pipelines for movement and transformation across internal and external systems
- Write and optimize T-SQL queries, stored procedures, and views in Azure SQL Servers
- Build REST API and SFTP-based integrations with third-party platforms
- Lead our efforts in monitoring and maintaining Azure cloud infrastructure services and resources
- Develop automation workflows supporting HR and operational data processes
- Document data flows, integration specs, and technical processes
- Triage pipeline failures and data discrepancies using structured troubleshooting
- Collaborate with cross-functional stakeholders to translate requirements into technical solutions
- Build and maintain SQL views and mappings that translate source system data for downstream consumers
- Triage incoming integration requests, gather requirements using project management tools
- Coordinate with external vendors to gather specs and keep integrations moving
Qualifications
- Must be able to reliably commute to Portland, Oregon for daily on-site work
- This is a full-time in-person role
- 3-5 years of experience in a data engineering or systems integration role
- 2+ years experience with Azure data services (Azure SQL, Data Factory, Blob Storage, etc.)
- Demonstrated experience securing sensitive data — PHI, PII, or equivalent — in compliance with regulatory frameworks such as HIPAA
- Proficiency in T-SQL including stored procedures, views, and query optimization
- Experience designing and maintaining REST API or SFTP-based integrations
- Self-directed and adaptable - able to manage competing priorities, pivot when business needs shift, and drive work to completion independently
- Experience in healthcare preferred
- Knowledgeable in Power BI or similar BI reporting tools
- Experience working in a multi-entity or multi-line-of-business data environment preferred