Job Description

The Intersect Group is seeking a Database Engineer for our direct healthcare client, where you will focus on loading data from various sources into the Data Lake and/or Data Warehouse as well as building and maintaining data pipelines.

Direct Hire (No C2C or third-party submissions)

Location: For the first month or two the schedule will be hybrid with Monday & Tuesday in-office and remote for the remainder of the week. Eventually it will be 1 day a week on site in Addison (75001)

Schedule: Hybrid unless not located in the DFW area then this person can work fully remote

Interview process: Typically, 2 rounds of virtual interviews

Needs:

• 5+ years working as a data engineer or data analyst
• 5+ years working with SQL Server or other relational databases, building data pipelines using ETL tools like ADF, Airbyte, Informatica, etc.
• 5+ years building objects in a SQL database, including tables, stored procedures, and views
• Expertise in SQL and data analysis
• Experienced building data pipelines using ETL tools like ADF (preference) or DBT (also a plus) and Airflow (will be using both for quite a while until they fully transition to Snowflake)
• Demonstrated ability in meeting deadlines and communicating progress across projects
• Ability to coordinate and collaborate with other team members and business owners
• Excellent communication, organization, and time management skills
• Bachelor’s degree or higher

Preferred:

• Experience working with Azure DevOps
• Experience working with cloud data such as Snowflake, Azure SQL, and Azure Data Factory (ADF) highly desired
• Experience building Power BI dashboards strongly preferred
• Experience working with DBT preferred
• Experience with Healthcare or Financial data preferred

Duties:

• Profile and analyze data from multiple sources and data types
• Build ETL/ELT pipelines to ingest and load data
• Maintain and monitor data pipelines and schedules
• Triage and troubleshoot data quality issues and implement corrective actions
• Build and maintain data transformations
• Build and standardize reporting objects, data, and logic at the database layer
• Follow best practices for development, QA, deployment, source code management
• Ensure proper documentation is maintained, and provide walk-through of definitions and metrics
• Coordinate closely with other developers to streamline processes and optimize
• Gain strong knowledge of underlying data and business rules, and assist other teams
• Adopt agile methodology, and assist in tracking and communicating progress of deliverables
• Identify improvement opportunities (proactive and reactive)
• Build and maintain strong relationships with business and IT users, both onshore and offshore

Job Tags

Similar Jobs