Data Integration Lead

Overview

The successful candidate will be a key member of the Data Warehouse Development Team and should be passionate about Data Warehousing, have experience through all aspects of the Standard Development Life Cycle and keeps abreast of emerging trends in the DW/BI domain. The role requires the development of data warehouses ETL processes and data marts.

Duties

• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
• Work with business analysts and project managers to develop and refine reporting and analytics requirements.
• Work on complex projects that require both depth and breadth of knowledge in a number of technologies and the business.
• Participate on projects, clarifying the business requirements, performing systems analysis, development and modification activities, as well as related maintenance & support.
• Assist in planning sessions with the business users to analyze business requirements, and provide design recommendations.
• Write concise and clear technical specifications based on analysis of complex business requirements.
• Develop and modify complex software systems using disciplined software development processes.
• Design and implement ETL procedures for intake of data from both internal and outside sources, as well as ensure data is verified and quality is checked.
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
• Translate business and technical requirements into business application systems.

 Experience

• Advanced knowledge of SQL including complex stored procedures, functions, query optimization, indexing strategy.
• 4+ years of experience of SSIS and SQL Server Database.
• Experience with overall Data Warehouse infrastructure capacity planning and scaling.
• Proven track record in delivering scalable and reliable DW solutions.
• Strong data modeling and dimensional modeling skills (including slowly changing dimensions).
• Experience with data quality and data profiling.
• ETL/ELT design and development experience.
• Experienced in designing, building and maintaining large/complex DW systems is desirable.