Application Programming Interface (API), Architectural Analysis, Automation, Business Intelligence, Clinical Medicine, Cross-Functional, Data Collection, Data Management, Database Analysis, Database Architecture, HIPAA (Health Insurance Portability and Accountability Act), Healthcare, Identify Issues, Information/Data Security (InfoSec), Infrastructure as a Service (IaaS), Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Operational Support, Operations Processes, Pharmacy, Power BI, Project Management Software, Query Optimization, REST (Representational State Transfer), Regulatory Compliance, Requirements Management, SQL (Structured Query Language), Secure/SSH File Transfer Protocol (SFTP), Software Administration, Software Development, Stored Procedures, System Integration (SI), Time Management
Data Engineer
JOIN AN OUTSTANDING TEAM!
This is a Portland, OR based position and requires in-office work.
As the Data Engineer, you will play a critical role in expanding, optimizing, and maintaining our data architecture and data pipelines across the enterprise. You'll work across Azure data services, SQL development, and enterprise integrations, contributing not just as an implementer but as a technical decision-maker. This position is responsible for ensuring efficient data flow, collection, organization, and integration from both internal and external sources.
The Data Engineer will support software developers, database architects, analysts, and business teams by providing scalable infrastructure that enables accurate, timely, and accessible data while collaborating with analysts, developers and business stakeholders.
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:
- 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
Marquis Companies has been in business since 1989. By joining Marquis Companies, you are joining a family of services. From Consonus Rehab and Consonus Pharmacy to AgeRight Care at Home, and AgeRight Clinical Services, and AgeRight Care Management Services, we have a variety of services to offer opportunities for development and growth. Our Vital Life Foundation allows us to take resident experiences to the next level while giving back to our staff and community at large.
EEO Statement:
“Be here. Be you.”
For more than 30 years, Marquis Companies and Consonus Healthcare have been serving seniors and welcoming staff of all backgrounds, skills, and perspectives. The Marquis family of companies offer a rich heritage of embracing differences and honoring individuality. We’ve continued to grow in our appreciation of diversity in the workplace. We know it builds strength, drives innovation, and brings valuable new perspectives and energy.
We’re committed to making our workforce an even greater reflection of the people and communities we serve, and we are honored our employees have chosen to work at Marquis and Consonus. Everything we do as a company is driven by our mission to help those we serve, and each other, live the best rest of our lives.
That means you being you – without apology or compromise. We value your every uniqueness and continue to curate, nurture, and sustain an inclusive culture. It’s the foundation of who we are and the evolution of our collective future.