Service Excellence_ETL Lead

Job description

Position Responsibilities

·  Design and develop enterprise and departmental business intelligence and data warehousing solutions.
·  Collaborate with project leads, business analysts and end users to design, implement and test data warehouse applications.
·  Design and implement ETL processes in support of business analytics and reporting.
·  Develop and perform unit, system, performance and regression testing on ETL mappings.
·  Create source-to-target mapping specifications for ETL development.
·  Follow established coding standards, perform code reviews and improve standards to assure compliance.
·  Support and improve production data integration system and environment.
·  Provide technical and business knowledge support to the team.
·  Ensure effective communication of user requirements.
·  Experience in defining and baselinining Data Visualization projetcs majolry through Power BI

Minimum Requirements

·  Bachelor's degree in IT or related major.
·  min 8+ years of data-related experience.
·  5+ years of hands-on experience in design and implementation of ETL framework for complex data warehouse projects.
·  Strong analytical skills to troubleshoot issues and identify resolutions.
·  Available for off-business hours implementation and support.
·  Excellent knowledge of relational data modeling (ERD), SQL and data warehousing.
·  Experience in multiple database platforms, including SQL Server, Oracle and Azure storages.
·  Hands-on experience in writing complex T-SQL and database performance tuning. Experience writing TSQL, views, stored procedures, functions and triggers
·  Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS and Power BI).
·  Minimum of 2 years working experience in technical data analysis, data science, or data warehousing with proven business analysis experience
·  Experience in at least one or more languages: R, Python, C#, .Net, JavaScript will be an added advantage
·  Experience in handling multiple data visualization and analytics tools

 

Position Responsibilities

·  Design and develop enterprise and departmental business intelligence and data warehousing solutions.
·  Collaborate with project leads, business analysts and end users to design, implement and test data warehouse applications.
·  Design and implement ETL processes in support of business analytics and reporting.
·  Develop and perform unit, system, performance and regression testing on ETL mappings.
·  Create source-to-target mapping specifications for ETL development.
·  Follow established coding standards, perform code reviews and improve standards to assure compliance.
·  Support and improve production data integration system and environment.
·  Provide technical and business knowledge support to the team.
·  Ensure effective communication of user requirements.
·  Experience in defining and baselinining Data Visualization projetcs majolry through Power BI