02 oct
|
Electronic Toll Collection (Pty
|
Ciudad de México
02 oct
Electronic Toll Collection (Pty
Ciudad de México
Kapsch is one of Austria's most successful integral technology companies. With its comprehensive ITS (Intelligent Transportation Systems) portfolio, Kapsch is actively addressing the challenges of the present and the future with intelligent mobility solutions in a wide range of application areas. As a family-owned company founded in 1892 and headquartered in Vienna, Kapsch can look back on 130 years of experience with the future. To learn more about our solutions and innovations, visit our website here.
A Database Engineer is responsible for designing, implementing, and optimizing the data layer of software solutions, building robust and scalable data services that ensure performance, reliability, security, and availability across business-critical applications.
How You'll Make An Impact
• Design and maintain logical and physical database schemas for transactional systems and Data Warehouses, including star and snowflake models.
• Develop and implement SQL Server database objects, including tables, views, indexes, stored procedures, functions, and triggers.
• Build and maintain data repositories and services using C# and Entity Framework (Code First and Database First approaches).
• Participate in technical design reviews, code reviews, and integration testing activities to ensure high-quality data solutions.
• Design, develop, and automate ETL processes using SQL Server Integration Services (SSIS) and other data integration tools.
• Create and maintain OLAP and tabular models using SQL Server Analysis Services (SSAS).
• Develop, publish, and enhance reports, dashboards, and analytical solutions using SQL Server Reporting Services (SSRS) and Power BI.
• Optimize T-SQL queries, ETL pipelines, and analytical models to improve performance, scalability, and response times.
• Partner closely with business analysts and stakeholders to define KPIs, metrics, and reporting requirements.
• Document database models, ETL workflows, coding standards, and BI user guides to suppo
📌 Database Engineer (Ciudad de México)
🏢 Electronic Toll Collection (Pty
📍 Ciudad de México