Databricks Data Engineer

Inizio Partners Corp; Columbus (OH); Hybrid; USD 135,000 - 165,000; Full time

Job summary

A technology firm in Columbus, OH is seeking a skilled Data Engineer with 7-12 years of experience. The successful candidate will develop and optimize data pipelines, ensuring data accuracy and integrity to support decision-making processes. Strong proficiency in PySpark, Python, and SQL is required, along with experience in data modeling and ETL processes. This role offers a competitive salary and potential for remote work.

Qualifications

• 7-12 years of experience in a Data Engineering role.
• Strong experience in developing scalable data pipelines.
• Hands-on experience with performance tuning of data pipelines.

Responsibilities

• Collaborate with stakeholders to define data models supporting business requirements.
• Develop and maintain efficient data pipelines to ensure seamless data flow.
• Implement robust data checks to ensure data accuracy and integrity.

Skills

PySpark

Python

SQL

Data modeling

ETL/ELT pipeline development

Data warehousing

Agile methodologies

Analytical skills

Problem-solving skills

Education

Bachelor's degree in computer science, Information Technology, or related field

Tools

Databricks

Delta Lake

Job description

Location: Columbus, OH (1st choice), Remote (2nd choice)

Experience Required: 7-12 years

Base Salary: Up to $150k

Job Overview

We are seeking a skilled Data Engineer to join our team. The successful candidate will be responsible for development and optimization of data pipelines, implementing robust data checks, and ensuring the accuracy and integrity of data flows. This role is critical in supporting data-driven decision-making processes, especially in the context of our insurance-focused business operations.

Key Responsibilities

• Collaborate with data analysts, reporting team and business advisors to gather requirements and define data models that effectively support business requirements
• Develop and maintain scalable and efficient data pipelines to ensure seamless data flow across various systems and address any issues or bottlenecks in existing pipelines.
• Implement robust data checks to ensure the accuracy and integrity of data. Summarize and validate large datasets to ensure they meet quality standards.
• Monitor data jobs for successful completion. Troubleshoot and resolve any issues that arise to minimize downtime and ensure continuity of data processes.
• Regularly review and audit data processes and pipelines to ensure compliance with internal standards and regulatory requirements
• Familiar with working on Agile methodologies - scrum, sprint planning, backlog refinement etc.

Candidate Profile

• 7-12 years experience on Data Engineering role working with Databricks & Cloud technologies.
• Bachelors degree in computer science, Information Technology, or related field.
• Strong proficiency in PySpark, Python, SQL.
• Strong experience in data modeling, ETL/ELT pipeline development, and automation
• Hands-on experience with performance tuning of data pipelines and workflows
• Experience with data modeling, ETL processes, Delta Lake and data warehousing.
• Experience on Delta Live Tables, Autoloader & Unity Catalog.
• Preferred - Knowledge of the insurance industry and its data requirements.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent communication and problem-solving skills to work effectively with diverse teams
• Excellent problem-solving skills and ability to work under tight deadlines.