описание
We are looking for a Data Engineer / Data Warehouse Developer to support and enhance our corporate data platform. The successful candidate will be responsible for developing and optimizing data integration and processing solutions, maintaining and enhancing the corporate Data Warehouse (DWH), building analytical models, and ensuring the reliability and availability of data for business intelligence and reporting.
задачи
- Design, develop, implement, and maintain ETL/ELT processes and data pipelines to integrate data from various corporate systems.
- Develop and support data integrations across ERP, SFA, CRM, and other internal and external data sources.
- Develop, maintain, and optimize the corporate Data Warehouse (DWH), including data structures, data models, and analytical data marts.
- Develop and optimize SQL queries, stored procedures, views, functions, and other database objects.
- Develop, maintain, and optimize SQL Server Analysis Services (SSAS) analytical models, primarily Multidimensional Models (OLAP Cubes).
- Implement technical solutions to support new business reporting, KPI, and analytical requirements.
- Implement data quality controls, including data validation, reconciliation, consistency, and completeness checks.
- Monitor and optimize the performance of databases, data pipelines, ETL/ELT processes, and analytical models.
- Troubleshoot data processing and integration issues, perform root cause analysis, and implement preventive solutions.
- Contribute to the development of corporate data architecture and the adoption of new data technologies.
- Develop and maintain technical documentation and collaborate with Data Office, Reporting, and other business and technical teams.
требования
- Bachelor's degree or higher in Information Technology, Computer Science, Applied Mathematics, Engineering, or a related technical field.
- At least 3 years of hands-on experience in Data Engineering, Data Warehouse Development, Business Intelligence Development, or a similar role.
- Strong proficiency in Microsoft SQL Server and T-SQL, including complex SQL development, stored procedures, and query performance optimization.
- Hands-on experience developing and maintaining ETL processes using SQL Server Integration Services (SSIS).
- Experience developing, maintaining, and optimizing SQL Server Analysis Services (SSAS) Multidimensional Models (OLAP Cubes).
- Knowledge of MDX and a solid understanding of multidimensional data modeling principles.
- Good understanding of Data Warehouse design principles, data modeling, and analytical data mart development.
- Solid knowledge of ETL/ELT concepts, data integration, error handling, and data quality management.
- Ability to troubleshoot and optimize SQL Server databases, ETL processes, and analytical models.
- Будет плюсом: Experience with Microsoft Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure SQL is nice to have
условия
- Careers with caring built in - discover our benefits here.