Data Solutions Engineer - SQL, ETL & BI

Kapsch Trafficcom Transportation SA.; Wien; Vor Ort; MXN 900.000 - 1.300.000; Vollzeit

Benefits dieser Stelle

Kapsch Days

International working environment

Excellent working climate

Zusammenfassung

Kapsch Trafficcom Transportation SA is seeking a Database Engineer to design, implement, and optimize the data layer of our software solutions. You will build robust data services and ensure performance, reliability, and security across critical applications.

The role covers data modeling, ETL pipelines with SSIS, SQL Server objects, and BI reporting with Power BI. You will collaborate with analysts and stakeholders to define KPIs and create scalable data solutions in a global mobility

Qualifikationen

• Bachelor's degree in CS, IS, SE or related field.
• Proven experience designing, developing, and maintaining databases and Data Warehouses.
• Strong SQL development and performance tuning skills.
• Experience with Power BI reporting.
• Experience REST APIs and web services integration.
• Experience using AI-assisted development tools.
• Experience with GitLab and source control.

Aufgaben

• Design and maintain database schemas for transactional systems and Data Warehouses.
• Develop SQL Server objects: tables, views, indexes, procedures, functions, triggers.
• Build data repositories and services using C# and Entity Framework.
• Participate in design reviews, code reviews, and testing.
• Design, develop, and automate ETL with SSIS and other tools.
• Create OLAP/SSAS models.
• Develop reports and dashboards using SSRS and Power BI.
• Optimize T-SQL queries and ETL pipelines for performance.
• Collaborate with analysts to define KPIs and reporting needs.
• Document models, ETL workflows, coding standards, and BI guides.

Kenntnisse

SQL development

Data Warehouses

Power BI

REST APIs

GitLab

C#

Entity Framework

ETL

SSIS

SSAS

SSRS

Query tuning

AI-assisted tools

Data access

Ausbildung

Bachelor's degree in Computer Science/Information Systems/Software Engineering or related field

Tools

SQL Server

SSIS

SSAS

SSRS

Power BI

GitLab

Jobbeschreibung

Kapsch Trafficcom Transportation SA is seeking a Database Engineer to design, implement, and optimize the data layer of our software solutions. You will build robust data services and ensure performance, reliability, and security across critical applications.

The role covers data modeling, ETL pipelines with SSIS, SQL Server objects, and BI reporting with Power BI. You will collaborate with analysts and stakeholders to define KPIs and create scalable data solutions in a global mobility