Senior Data Engineer

Department/Section: Data and Analytics Office / Data Engineering

The Senior Data Engineer / SSIS Engineer is responsible for designing, building, and maintaining scalable data pipelines, ETL processes, and data marts that enable reliable analytics and data-driven decision-making. A key focus of this role is the development and maintenance of a robust semantic layer, ensuring structured, consistent, and business-friendly data access across the organization.

The role involves close collaboration with analytics, data science, and business teams to deliver high-quality data models, feature stores, and industrialized data products while upholding best practices in data engineering, data quality, and documentation.

• Design, develop, and maintain robust logical and physical data models that support analytical and reporting requirements.

• Ensure models are scalable, performant, and aligned with business needs.

• Apply industry-standard modeling techniques; experience with Data Vault methodology is a plus.

• Design, implement, and maintain a centralized semantic layer to enable consistent and reusable business metrics.

• Define and manage ontologies, taxonomies, hierarchies, and business definitions to ensure a common understanding of data across teams.

• Enable self-service analytics by simplifying complex data structures for business users.

• Develop, optimize, and maintain ETL pipelines, with a strong focus on SSIS, to automate data ingestion, transformation, and loading.

• Ensure high reliability, performance, and availability of data pipelines across multiple source systems and data platforms.

• Support batch and near–real-time processing where required.

• Implement data quality checks and controls throughout the data lifecycle, starting from source systems.

• Monitor data accuracy, completeness, and consistency, and proactively resolve data quality issues.

• Collaborate with stakeholders to define and enforce data quality standards.

• Work closely with data scientists, analysts, BI developers, and business stakeholders to gather requirements and translate them into scalable data solutions.

• Support analytical use cases, feature engineering, and reporting needs through well-designed data assets.

• Document data models, ETL workflows, semantic layer configurations, and data definitions.

• Promote best practices in data engineering, naming conventions, version control, and deployment processes.

• Ensure transparency, traceability, and knowledge sharing across teams.

• Mentor and guide junior data engineers.

• Provide technical leadership in data modeling, SSIS development, and semantic layer design.

• Contribute to continuous improvement of data engineering standards and frameworks.

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field.

• Strong hands-on experience as a Senior Data Engineer or SSIS Engineer.

• Advanced expertise in SSIS, SQL, and relational data warehouses.

• Strong knowledge of data modeling techniques (star schema, snowflake, dimensional modeling).

• Experience designing and maintaining data marts and semantic layers.

• Solid understanding of data quality management and ETL best practices.

• Strong communication skills and ability to work with both technical and non-technical stakeholders.

• Experience with Data Vault modeling.

• Exposure to modern analytics platforms, cloud data services, or feature stores.

• Experience supporting self-service BI and analytics use cases.