Note: The job is a remote job and is open to candidates in USA. Pyramid Consulting, Inc. is a professional services and management consulting company. The company is seeking a Data Engineer to build and support production data pipelines into Exasol, including high-volume batch, incremental, and change-data pipelines. The role also involves working with SQL Server, healthcare data, data warehousing, ETL/ELT, and production data integrity and performance optimization.
Responsibilities
- Build and support production data pipelines into Exasol
- Build high-volume batch, incremental and change-data pipelines
Skills
- Must have skills: Data Engineer, Exasol, SQL Server, ETL
- Experience :5+ years
- Existing Exasol platform with healthcare data flowing from Epic/Clarity/Caboodle, SQL Server and file-based sources into Exasol, with Tableau as a downstream analytics/visualization layer
- Build and support production data pipelines into Exasol
- Expert-level, set-based SQL including window functions, analytic functions, and MERGE
- Build high-volume batch, incremental and change-data pipelines
- Experience with SQL Server → analytics/data warehouse pipelines
- Strong data warehouse/ETL/ELT experience
- Healthcare claims, eligibility, encounter, or provider data experience
- Experience working with PHI/HIPAA data in production
- Production change management, deployment, rollback/restart and data integrity experience
- Strong performance optimization and troubleshooting skills
- Healthcare strongly preferred
Benefits
- Health insurance (medical, dental, vision)
- 401(k) plan
- Paid sick leave (depending on work location)
- Remote work
Company Overview
Company H1B Sponsorship