Senior Data Engineer

With Us You Will

• Design and Development: Design, develop, and maintain scalable data warehouse solutions to support business intelligence and reporting needs.
• ETL Implementation: Develop ETL processes to extract, transform, and load data from various sources into the data warehouse while ensuring data integrity and consistency.
• Data Modeling: Design and implement data models, schemas, and dimensional models to support analytical reporting and ad-hoc queries.
• Data Governance: Implement and enforce data governance policies and procedures within the data warehouse environment to ensure data quality, compliance, and security standards are upheld.
• Documentation and Collaboration: Document data warehouse processes, data flows, and system architectures, and collaborate with cross-functional teams to drive data-driven decision-making and enhance data accessibility and usability.

Requirements

What We Expect From You

• Expertise in SQL: Proficiency in writing complex SQL queries for data extraction, transformation, and analysis within a data warehouse environment.
• ETL Development: Experience in designing and implementing ETL processes such as Informatica, Talend, or custom scripting to load data from disparate sources into the data warehouse.
• Programming: Proficiency in Python programming language for data manipulation, automation, and scripting tasks related to data processing and analysis.
• Data Modeling: Strong understanding of data modeling concepts including dimensional modeling, star schema, and snowflake schema to design efficient and scalable data warehouse structures. Familiarity with data lake concept is advantageous.
• Performance Tuning: Ability to optimize data warehouse performance through indexing, partitioning, and query optimization techniques to ensure fast and reliable data retrieval.