Senior Data Warehouse Developer / Data Engineer
Tipo de Contratação Não Informado
Publicada em: 24/08/2026
Candidatar-me agora
The company: We are a global custom software development and IT project staffing organization without geographic restrictions; we operate globally, navigating technology and business challenges with expertise. Our U.S. headquarters are in San Diego, California and we also have strategically located development centers in Brazil, Mexico, Peru, and Uruguay. Our Latin America headquarters are based in Porto Alegre, Brazil, with a branch in São Paulo. For over two decades, we have been globally recognized in the software and innovation market for delivering projects with added value, crafted by agile teams of skilled professionals. Check out our international page at www.ntconsultcorp.com.
Project: We are looking for an experienced Data Warehouse Developer to join a data engineering team supporting a large U.S. financial services organization. The role is focused on designing and developing enterprise data warehouse solutions, with a strong emphasis on dimensional modeling and star schema design.
Resposibilities:
- Design and develop data warehouse solutions using fact tables, dimensions, bridge tables, and star schemas.
- Build and maintain ETL/ELT processes that transform source data into well-structured analytical models.
- Develop database-centric transformation logic, primarily using SQL and stored procedures.
- Support the modernization of existing SSIS-based workloads toward Azure Data Factory and newer data platform patterns.
- Help evolve traditional batch-oriented data processing toward more modern and real-time data flows.
- Build data structures that support downstream Power BI and SQL Server Analysis Services (SSAS) models.
- Collaborate closely with developers and stakeholders during U.S. business hours.
Requirements:
- Strong hands-on experience with data warehousing and dimensional modeling.
- Proven experience designing star schemas, including facts, dimensions, and bridge tables.
- Advanced SQL / SQL Server development skills, including T-SQL and stored procedures.
- Strong ETL/ELT development experience specifically for enterprise data warehouses, not only system integrations or analytics.
- Experience with SSIS and Azure Data Factory for ETL/ELT development and pipeline orchestration.
- Understanding of both traditional batch processing and modern data integration patterns.
- Strong communication and collaboration skills in English.
Nice to Have:
- Experience with Microsoft Fabric or modern Microsoft data platforms.
- Experience supporting Power BI and SSAS.
- Experience with near-real-time or event-driven data processing.
- Financial services experience.
Você está em uma área do site da empresa NTConsult fornecida pela plataforma Compleo.
Ao clicar no botão Candidatar-me agora você CONCORDA com os termos de uso e a política de privacidade do COMPLEO.
Compartilhe:
