Senior Data Warehouse Developer / Data Engineer

Ntconsult; Porto Alegre; Híbrido; BRL 120 000 - 180 000; Tempo integral

Resumo da oferta

Ntconsult is seeking an experienced Senior Data Warehouse Developer / Data Engineer to join a data engineering team supporting a large U.S. financial services organization. The role emphasizes dimensional modeling, star schemas, and enterprise data warehouse design.

You will design and build ETL/ELT processes, develop SQL-based transformations, and help modernize SSIS workloads toward Azure Data Factory, while coordinating with stakeholders during U.S. business hours.

Qualificações

• Strong hands-on experience with data warehousing and dimensional modeling.
• Proven ability to design star schemas, including facts, dimensions, and bridge tables.
• Advanced SQL / T-SQL development and stored procedures.
• Experience with SSIS and Azure Data Factory for ETL/ELT.
• Excellent communication in English and collaboration with stakeholders.

Responsabilidades

• Design and develop enterprise data warehouse solutions with star schemas.
• Build and maintain ETL/ELT processes transforming source data.
• Develop database-centric transformation logic using SQL and stored procedures.
• Modernize SSIS workloads toward Azure Data Factory and newer patterns.
• Support real-time data flows and Power BI/SSAS data models.
• Collaborate with US team during US business hours.

Conhecimentos

Dimensional modeling

Star schema design

SQL / T-SQL

ETL/ELT development

SSIS

Azure Data Factory

Data warehousing

English communication

Power BI

Ferramentas

SSIS

Azure Data Factory

Power BI

SSAS

SQL Server

Descrição da oferta de emprego

Senior Data Warehouse Developer / Data Engineer

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.