Senior ETL Developer II

Wakely Consulting Group, LLC
Saint Paul, MN, United States
2 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Compensation
$150,000 - $170,000
Working hours
Regular working hours

Tech stack

Adobe InDesign Artificial Intelligence Code Review Databases Data Validation Data Integration Extract Transform Load (ETL) Data Transformation Data Warehousing Database Development Information Sciences Microsoft SQL Server
+7 more
Software Engineering SQL Databases SQL Server Integration Services Software Technical Review Data Processing Information Technology Software Version Control

Job description

The Senior ETL Developer II designs, develops, tests, and supports complex data integration and processing solutions using SQL Server, SSIS, and related technologies. This role translates complex business requirements into scalable, efficient, and maintainable data processing solutions. The Senior ETL Developer II collaborates with stakeholders and technical teams to refine requirements, design solutions and implement data workflows that support healthcare claims, encounter, eligibility, enrollment, and financial data processing. The role troubleshoots data and production issues, contributes to improvements in data quality, automation, performance, and operational efficiency, participates in design and code reviews, mentors other developers, and supports established development standards and project delivery., Work Performed and Job Requirements

  • ETL Development
  • Translates business requirements into technical specifications, data mappings, and processing logic.
  • Designs, develops, tests, and supports complex ETL processes using SQL Server, SSIS, and related technologies.
  • Data Quality and Technical Support
  • Troubleshoots data-processing, integration, and production issues and performs root-cause analysis.
  • Supports data validation, quality assurance, performance improvement, automation, and maintenance of existing solutions.
  • Technical Collaboration
  • Provides technical design guidance, participates in code reviews, and mentors other developers on ETL design, SQL, and healthcare data.
  • Promotes established software development lifecycle, documentation, testing, source-control, and quality-assurance practices.
  • Contributes to improvements in automation, scalability, performance, data quality, and operational efficiency.
  • Project and Stakeholder Support
  • Works with stakeholders, analysts, and operations teams to define requirements, identify solution gaps, and develop effective data-processing solutions.
  • Contributes to technical design reviews, project planning, effort estimates, and implementation activities.
  • Serves as a subject matter resource for data integration, ETL development, and healthcare business rule implementation.
  • All other duties as assigned.

Requirements

Database Extract Transform and Load (ETL), Mentoring, Microsoft SQL Server, Automation, Code Reviews, Data Processing, Database Extract Transform and Load (ETL), SQL Server Integration Services (SSIS), Identify Issues, Healthcare, A bachelor’s degree in computer science, information science, mathematics, or a related field is required.

Experience

Minimum of 8 years of professional experience in ETL, data integration, data warehousing, or data development roles using SQL Server and related technologies is required. Minimum of 3 years of experience in a lead, senior lead, or technical leadership capacity is required, including experience mentoring team members, coordinating technical work, and working with stakeholders to gather requirements. Experience with healthcare claims, encounter, enrollment, eligibility, financial, or regulatory-reporting data is preferred.

Knowledge, Skills and Abilities

  • Advanced hands-on knowledge of SQL Server, SSIS, SQL development, and data transformation.
  • Ability to translate business requirements into technical specifications, data mappings, and ETL solutions.
  • Ability to troubleshoot complex data-processing issues and perform root-cause analysis.
  • Knowledge of data validation, quality assurance, source control, testing, and documentation practices.
  • Ability to provide technical guidance, conduct peer reviews, and mentor other developers.
  • Ability to understand and apply complex healthcare data and business rules.
  • Strong analytical, problem-solving, organizational, and time-management skills.
  • Strong written, verbal, and interpersonal communication skills.
  • Ability to manage multiple projects and priorities concurrently.
  • Self-motivated with a commitment to continuous learning and process improvement.
  • Ability to use technology and AI tools ethically and effectively to improve efficiency, quality, and processes while protecting confidential information and applying sound judgment.

Benefits & conditions

The posted salary range for this role at HMA includes a range of factors that we consider when making compensation decisions. These factors include but are not limited to experience, education, training, skills, licensures, and certifications, along with other business and organizational needs. HMA may adjust the posted salary range estimate for applicable geographic differentials associated with the location where we may fill the position. At HMA, we generally do not hire an individual at or near the top of the range for their role. All compensation decisions are dependent on the variables of each case. A reasonable estimate of the existing salary range for this position is $150,000 to $170,000.

HMA offers a robust benefits package for full-time colleagues. Benefits include health, dental, vision, group life/AD&D, voluntary life/AD&D, short-term disability, long-term disability, paid parental leave, paid time off, paid holidays, 401(k) employer match and safe harbor contribution, and our long-term equity incentive plan.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…