Data Engineer - REMOTE MEXICO

About Scalepex

Scalepex is a nearshore partner that empowers businesses to scale efficiently and effectively through exceptional services. With a strong focus on customer success, innovation, and cultural alignment, we support companies in building high-performing teams across industries.

At Scalepex, we believe in fostering an environment where our people can thrive, grow their careers, and make a real impact.

Job Summary

We are looking for a Data Engineer to join our DataOps team, focused on delivering high-quality data pipelines, transformations, and integrations for healthcare-related data.

This role is highly hands-on with SQL, data processing, and troubleshooting, working closely with internal teams and external partners to ensure data accuracy, scalability, and performance.

Requirements

Key Responsibilities

• Extracting, cleansing, and loading data.
• Building data pipelines using SQL, Kafka, and other technologies.
• Investigate and troubleshoot issues with data and data pipelines.
• Investigation and documentation of new data sets
• Implement new data transformation configurations or ad-hoc reports
• Triage incoming bugs and incidents.
• Participation in sprint refinement, planning, and kick-off to help estimate stories, raise awareness and define additional implementation details.
• Monitor data pipeline execution and performance. Resolve discovered issues collaboratively.
• Perform and implement data quality checks to maintain consistent and accurate data.

Required Qualifications

• Solid grasp of modern relational and non-relational models and differences between them.
• Expert in writing complex SQL, including pivots, window functions, and complex date calculations
• Expert in analyzing and parsing flat file data structures.
• Proficient in EDI X12 formats related to healthcare claims processing
• Proficient in the use of Excel and familiar with analytical tools such as Tableau, MicroStrategy, PowerBI, etc…
• Familiarity with API usage for healthcare data integration including data parsing and conversion.
• Familiarity with EFT file movement principles and tools including encryption.
• Ability to translate data movement and transformation concepts and details from existing to new tech stacks.
• Ability to clearly communicate data-related concepts and details with internal colleagues, and external data partners and vendors.
• Detail-oriented and able to examine data and code for quality and accuracy.
• 5+ years of experience in data engineering

Essential Knowledge

• Strong expertise in Microsoft SQL Server Management Studio
• SSIS package builds through Visual Studio

Preferred Qualifications

• ETL experience preferred
• Git experience preferred
• SW certification or degree in IT or Computer Science related field

Benefits

• Contractor scheme
• 100% Remote