Data Warehouse Manager

April 13, 2023

Apply for this job

Email *
Upload Resume *

Job Description

Demonstrated industry leadership in the technology fields such as Development, Database and/or Data Warehousing and Data Processing with strong expertise on QlikSense/QVD’s etc
Knowledge of software engineering best practices across the development lifecycle including agile methodologies, coding standards, code reviews, source management, build processes, testing and operations
Excellent oral and written communication skills with the ability to communicate effectively with technical and non-technical stakeholders
Excellent analytical skills
Experience in leading Data Warehouse & BI teams
Experience in managing data related technology implementations projects (e.g., Data Warehousing, Business Intelligence, Master Data Management, ETL tools etc.)
Experience in Information Technology leadership, system design and application development.
Monitor and manage data loads from various data sources into the Data Warehouse
Manage ETL routines according to the Data Warehouse design and architecture
Contribute in developing data modeling and ETL mapping solutions within structured Data Warehouse environment
Support the development and validation required through the lifecycle of the Data Warehouse and Business Intelligence systems
Maintain connectivity, and provide adequate security for Data Warehouse
Align to the best practices for data loading and extraction processes
Ensure that data validation process from external sources is running efficiently
Collaborate with Reporting team (e.g. Tableau) and ensure accuracy of data in dashboards and reports
Analyze data management processes and establish Data Governance best practices and supporting structure.
Experience in Data Warehousing, Big Data or Cloud technology areas
End to end design and development of Data Warehousing systems
Experience of ETL and data modelling
Experience in SQL, Big Data technologies EMR, Python, Spark, Oozie and Redshift
Understanding of concepts related to CRM and Reporting for Commercial (Sales & Marketing) processes is desired
Experience working in projects with environments of BI Visualization Technologies Tableau, PowerBI a plus
Ability to work with partial overlapping hours with the US team is required for this position
Strong collaboration skills and ability to deliver projects in a team setting is expected from this role.
Technical understanding of Data Warehouse architecture, development methodology and BI systems
Hands-on technical development in Data Warehousing required. Additionally;
Technical experience in SQL, Big Data technologies EMR, Python, Spark, Oozie, Redshift required.
Experience working in projects with CRM and Reporting components is desired
Exceptional knowledge in designing modern Databases such as
MySQL, Postgres, Redshift, Snowflake, Hive or Presto.  Has good experience working in agile based projects.  Has experience in understanding & converting BRD’s into
technical designs.  Work with management to provide effort, estimation and
timelines.  Work closely with IT, Business teams and other internal
stakeholders to resolve business queries within the defined SLA.  Exceptional knowledge in SQL and in designing tables, databases, partitions and query optimization.  Has good experience in designing ETL solutions in tools such as
Talend/AWS Glue/EMR.  Have at least 3 years of experience working on AWS Cloud
Hands-on in monitoring ETL jobs and performing health check to
ensure data quality
Have good exposure with AWS Services such as RDS, Aurora, S3, Lambda, Glue, EMR, Step Functions etc.  Design quality assurance tests for ensuring data integrity and
Good to have Python and big data knowledge