Data Engineer - REMOTE MEXICO
At a glance
Mid-level Data Engineering role at Scalepex. Remote, Mexico · contract.
Pay not stated Data Engineer salary
dataroles summary, based on the employer's posting.
What you'll do
- Build SQL and Kafka pipelines that extract, clean, load and transform healthcare-related data
- Inspect incoming datasets, document their structure and configure transformations or create ad hoc reports
- Investigate pipeline failures and data bugs, then work with others to resolve them
- Track pipeline runs and performance, applying checks that keep data accurate
- Join sprint planning and refinement to estimate work and clarify implementation details
What you bring
- At least five years in data engineering
- You write advanced SQL, including window functions, pivots and complex date calculations
- You can parse flat files and work with healthcare claims data in EDI X12 formats
- You have strong Microsoft SQL Server Management Studio skills and can build SSIS packages in Visual Studio
Who this fits
This contractor role suits a hands-on data engineer who works across SQL, data processing and troubleshooting. It is fully remote and based in Mexico.
From the employer
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
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data EngineeringRemote
Find me workBy the team behind dataroles.