Databricks Architect

Inizio Partners Corp; Dublin (OH); Hybrid; USD 90,000 - 130,000; Full time

Job summary

A consultancy firm is seeking an experienced Data Engineer to develop and optimize ETL pipelines using Databricks in a hybrid role based in Dublin, OH. Candidates should have over 8 years of relevant experience, strong programming skills in SQL and Python, and some familiarity with the insurance domain. The position requires excellent communication skills and the ability to lead projects effectively.

Qualifications

• 8+ years' experience in developing ETL pipelines.
• Some experience in the insurance domain is a must.
• Programming Languages: SQL, Python.

Responsibilities

• Develop and optimize ETL pipelines from various data sources.
• Utilize Spark Structured Streaming for real-time data processing.
• Lead Data Engineering Projects.

Skills

ETL pipeline development

Data processing using Databricks

Scrum and Agile methodologies

Strong verbal and written communication

Education

B.S. Degree in a data-centric field

Tools

AWS

Azure

Databricks

Spark

Job description

OUR CLIENT

Our client provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting-edge analytics techniques, and a consultative approach. Leveraging proprietary methodology and best-of-breed technology, our client's analytics team takes an industry-specific approach to transform decision-making and embed analytics more deeply into their business processes. They have a global footprint of 2,000+ data scientists and analysts who assist client organizations with complex risk minimization methods, advanced marketing, pricing and CRM strategies, internal cost analysis, and cost and resource optimization within the organization. They serve the insurance, healthcare, banking, capital markets, utilities, retail and e-commerce, travel, transportation and logistics industries.

Role & Responsibilities Overview:

• Develop and optimize ETL pipelines from various data sources using Databricks on cloud (AWS, Azure, etc.)
• Experienced in implementing standardized pipelines with automated testing, Airflow scheduling, Azure DevOps for CI/CD, Terraform for infrastructure as code, and Splunk for monitoring
• Continuously improve systems through performance enhancements and cost reductions in computing and storage
• Data Processing and API Integration: Utilize Spark Structured Streaming for real-time data processing and integrate data outputs with REST APIs
• Lead Data Engineering Projects to manage and implement data-driven communication systems
• Experienced with Scrum and Agile Methodologies to coordinate global delivery teams, run scrum ceremonies, manage backlog items, and handle escalations
• Integrate data across different systems and platforms
• Strong verbal and written communication skills to manage client discussions

Candidate Profile:

• 8+ years' experience in developing and implementing ETL pipelines from various data sources using Databricks on cloud
• Some experience in the insurance domain/ data is a must
• Programming Languages SQL, Python
• Technologies - IaaS (AWS or Azure or GCP), Databricks platform, Delta Lake storage, Spark (PySpark, Spark SQL).
• Good to have - Airflow, Splunk, Kubernetes, Power BI, Git, Azure DevOps
• B.S. Degree in a data-centric field (Mathematics, Economics, Computer Science, Engineering or other science field), Information Systems, Information Processing or engineering.
• Excellent communication & leadership skills, with the ability to lead and motivate team members
• Ability to work independently with some level of ambiguity and juggle multiple demands

This is a Hybrid role - 2 days per week in Dublin, OH. Client is currently considering candidates who are local to Dublin, OH or those who are open to relocating themselves to the Dublin, OH area.