Data Engineer 2 or 3 - Hybrid - Des Moines, IA

JOB SUMMARY

Wellabe is looking for a Data Engineer 2 or 3 to join our team. Responsibilities include analyzing, designing, building, and delivering data solutions for the organization.

Position level will be determined based on skills, knowledge and experience.

Position level will be determined based on skills, knowledge and experience.

 

ESSENTIAL FUNCTIONS
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

• Level 2
  • Work with senior engineers to design and develop data pipelines that extract data from various sources, transform it into the desired format, and load it into the appropriate data storage systems.
  • Support the buildout, migration, and maintenance of Wellabe’s Enterprise Data Lakehouse
  • Assist in administering and optimizing Azure Databricks clusters and ensure efficient data processing.
  • Implement and optimize ELT process to ensure data accuracy, consistency, and scalability.
  • Collaborate with analysts and business units to design and implement efficient data models.
  • Work closely with Information Technology teams to implement continuous integration and deployment (CI/CD) pipelines using Azure DevOps
  • Determine data tracking and storage needs, perform data auditing and validation, perform data mapping, loading and conversion planning, and resolve data issues or discrepancies.
• Level 3
  • Designs and develops data pipelines that extract data from various sources, transform it into the desired format, and load it into the appropriate data storage systems.
  • Train, mentor, support, and develop less experienced Data Engineers by providing advice, coaching, and educational opportunities.
  • Lead the buildout, migration, and maintenance of Wellabe’s Enterprise Data Lakehouse
  • Administer and optimize Azure Databricks clusters and ensure efficient data processing.
  • Implement and optimize ELT process to ensure data accuracy, consistency, and scalability.
  • Collaborate with analysts and business units to design and implement efficient data models.
  • Work closely with Information Technology teams to implement continuous integration and deployment (CI/CD) pipelines using Azure DevOps
  • Determine data tracking and storage needs, perform data auditing and validation, perform data mapping, loading and conversion planning, and resolve data issues or discrepancies.

 

SUCCESS PROFILE
Knowledge, Skills, and Abilities

• Working (Level 2), Advanced (Level 3) knowledge of the principles, processes, and practices related to data engineering and/or data architecture.
• Moderate (Level 2), Advanced (Level 3) SQL skills.
• Moderate (Level 2), Advanced (Level 3) knowledge of Python required.
• Exposure to Azure Data Factory or related tools.
• Exposure to Power BI consumption or related tools.
• Working knowledge of data management and transformation processes.
• Experience in working with Azure Databricks required.
• Familiarity with Azure DevOps for CI/CD.
• Experience with version control (e.g. Git).
• Excellent communication and collaboration skills.
• Demonstrate the Wellabe core competencies of change, communication, customer focus, financial acumen, innovation, teamwork, critical thinking, and decision making. For a full description of each competency, please visit wellabe.com/core-competencies.
• Embrace and foster a diverse and inclusive culture that aligns with our commitment to THRIVE Toolkit: We are building resources for employee reference, including a diversity driven book club, leadership training, and a culture of betterment philosophy. Hear: Every employee has a voice. We listen with attention to gain knowledge and to understand. Respect: We empower people by respecting and appreciating their differences. Inclusion: We support a collaborative workforce that promotes belonging and respect that increases participation and contribution from all employees. Value: All employees are appreciated for their uniqueness. Equity: For all.
• Demonstrate an Agile mindset* of trust, teamwork, and transparency and capability to implement agile tools into daily work, allowing for quick adaption to change. (*An agile mindset is the set of attitudes supporting an agile working environment including trust, teamwork, transparency, respect, improvement, ongoing learning, pride in ownership, focus on delivering value, and the ability to adapt to change.)
• Embrace our culture of betterment, which surrounds the question: Does