Data Engineer (C-565)

We are agents for tech professionals in Costa Rica and Colombia, helping them build careers in the United States. We believe in long-lasting relationships with our talent, investing time to understand their professional goals and find the perfect match. As agents, we pair our talent with US clients based on both technical skills and cultural fit, moving away from traditional contractor or outsourcing relationships.

Benefits

• Wellness Coverage
• Remote Work
• Birthday day off
• Recognition and rewards system
• Referrals Program
• Business skill coaching
• English classes for Smashers and relatives
• Learning opportunities

This position is remote and requires citizenship or a work permit from Costa Rica to apply.

About the Role

You will support the development and enhancement of a robust enterprise reporting ecosystem built on Azure SQL Server and Microsoft Azure services. This role focuses on data warehouse development, ETL integration, and data modeling to deliver reliable, scalable, and high-quality reporting solutions.

Responsibilities

• Design, develop, and maintain data warehouse solutions to support enterprise reporting and analytics.
• Build and optimize ETL/ELT processes using SSIS, Azure Data Factory, and Microsoft Fabric.
• Develop and optimize SQL queries, stored procedures, and data transformation processes.
• Support inbound and outbound data warehouse integrations for business-critical systems.
• Design and implement dimensional data models using Inmon and Kimball methodologies.
• Develop and maintain Azure SQL Server databases supporting reporting and analytics workloads.
• Ensure data quality, consistency, and integrity across reporting environments.
• Collaborate with business and technical stakeholders to understand reporting requirements and deliver scalable solutions.
• Troubleshoot and optimize ETL processes and reporting performance.
• Document data models, ETL workflows, and integration processes following best practices.

Requirements

• Experience designing and supporting enterprise Data Warehouse solutions.
• Intermediate to advanced SQL skills focused on querying, optimization, and data transformation.
• Experience with SQL Server Integration Services (SSIS).
• Hands-on experience with Azure Data Factory (ADF).
• Experience working with Microsoft Fabric.
• Experience developing solutions using Azure SQL Server.
• Solid understanding of dimensional modeling concepts.
• Experience applying the Inmon methodology for enterprise data warehouse and data mart design.
• Experience applying Kimball methodology, including facts, dimensions, and star schema modeling.
• Strong analytical and problem-solving skills.
• Ability to work independently while collaborating with cross-functional teams.

Nice-to-haves

• Experience developing dashboards and reports using Power BI.
• Experience with Qlik.
• Experience with Tableau.
• Experience optimizing enterprise reporting environments.
• Familiarity with Azure-based analytics and reporting architectures.

Languages

• English C1
• Spanish C1