Database Engineer - Fully Remote !!

Role: Database Engineer

Location: USA (Remote)

Duration: 3 months (C2H/ full-time Hire)

Job Description:

The ideal candidate will play a critical role in designing, developing, and maintaining our Enterprise Data Warehouse (EDW). The role requires a deep understanding of SQL, data modeling, and optimization to ensure the efficiency, scalability, and reliability of our data infrastructure.

Responsibilities Include:

·          Build, schedule, and monitor ETL/ELT pipelines using Azure Data Factory (ADF) and SQL Server Integration Services (SSIS).

·          Ingest, model, and process healthcare claims data to support reporting and analytics.

·          Develop and optimize data structures, warehouses, and workloads in Snowflake, including loading, transforming, and sharing data.

·          Write efficient SQL queries and scripts to support data extraction, transformation, and loading (ETL) processes.

·          Optimize database performance by analyzing, monitoring, and fine-tuning SQL queries and database structures.

·          Manage database security, backup, and recovery strategies to ensure data integrity and availability.

·          Develop and maintain data pipelines to ensure seamless data flow between various source systems and EDW.

·          Perform regular data quality checks and troubleshooting to ensure the accuracy and consistency of data in the EDW.

·          Monitor and maintain the performance of databases, addressing any issues related to performance, latency, and storage.

·          Work with development teams to integrate databases with applications and ensure seamless interaction between data services and business systems.

·          Keep up to date with emerging trends and best practices in database engineering, data warehousing, and SQL optimization.

Requirements:

·          Bachelor’s degree in computer science, Information Technology, or a related field.

·          Proven experience as a Database Engineer with 10 or more years of experience in a healthcare environment, with a focus on SQL and Enterprise Data Warehousing.

·          Hands-on experience working with healthcare claims data.

·          Hands-on experience with Azure Data Factory (ADF).

·          Hands-on experience with SQL Server Integration Services (SSIS).

·          Hands-on experience with Snowflake (Preferred).

·          Strong knowledge of data modeling and database design principles.

·          Understanding data security, backup, and recovery procedures (i.e. BCDR).

·          Strong problem-solving skills and attention to detail.

·          Knowledge of Agile methodologies and experience working in Agile environments.

·          Strong communication skills working across business functions

·          Manage multiple projects, issues, and deliverables in a fast-paced environment. Able to multi-task and prioritize work to meet deadlines.

·          Excellent listening, critical thinking, written and verbal skills.

·          Works well within a team environment.

·          Experience working in a professional environment with clinical managed care concepts, practices and procedures preferred.