Data & BI Engineer - SQL Server, Power BI, ETL

Kapsch Trafficcom Transportation SA.; Wien; Hybrid; MXN 450.000 - 700.000; Vollzeit

Benefits dieser Stelle

Kapsch Days

Zusammenfassung

Kapsch Trafficcom Transportation SA. seeks a Database Engineer to design, implement, and optimize data layers for software solutions in a global mobility context. You will build scalable data services, manage ETL with SSIS, and deliver BI insights via Power BI and SSRS.

Responsibilities include creating robust database schemas, tuning performance, and partnering with analysts to define KPIs. The role emphasizes SQL Server proficiency, C# development, and data warehouse expertise.

Qualifikationen

• Proven experience designing, developing, and maintaining databases and data warehouses.
• Experience building data services and data access layers for performant apps.
• Strong SQL development, query tuning, and ETL workflow design.
• Bachelor’s degree in computer science or related field is required.

Aufgaben

• Design and maintain database schemas for transactional systems and DWs.
• Develop SQL Server objects (tables, views, indexes, procedures, functions, triggers) and ETL with SSIS.
• Build data repositories using C# and Entity Framework; optimize queries and pipelines.
• Collaborate with analysts to define KPIs and publish dashboards via SSRS/Power BI.

Kenntnisse

SQL development

ETL design

Power BI

C#

Entity Framework

REST APIs

Ausbildung

Bachelor's degree in Computer Science or related field

Tools

SSIS

SSAS

SSRS

Power BI

GitLab

Jobbeschreibung

Kapsch Trafficcom Transportation SA. seeks a Database Engineer to design, implement, and optimize data layers for software solutions in a global mobility context. You will build scalable data services, manage ETL with SSIS, and deliver BI insights via Power BI and SSRS.

Responsibilities include creating robust database schemas, tuning performance, and partnering with analysts to define KPIs. The role emphasizes SQL Server proficiency, C# development, and data warehouse expertise.