AVP - Data Warehouse Development and Application Support Specialist

POSITION

Data Warehouse Development and Application Support Specialist

JOB PURPOSE

• The Data Warehouse Implementation Specialist will primarily focus on the development of ETL processes, data integration workflows, and the creation of reports and dashboards to support the implementation and operations of the organization's Data Warehouse. This role involves hands-on development using Microsoft SQL Server, SSIS, and Power BI while collaborating with business users to ensure that solutions meet their data and reporting needs.
• The candidate will play a key role in transforming raw data into actionable insights by designing, developing, and optimizing the Data Warehouse and its supporting components.

JOB RESPONSIBILITIES

ETL Development:

• Design, develop, and implement robust ETL (Extract, Transform, Load) processes using Microsoft SSIS.
• Automate data workflows to ensure consistent and reliable data integration into the Data Warehouse.
• Ensure that ETL processes are optimized for performance and scalability, particularly when dealing with large data sets.

Data Mapping and Design:

• Map and design efficient data flows from source systems to the Data Warehouse, ensuring data integrity, accuracy, and alignment with business requirements.
• Develop Data Warehouse schemas and table structures that support business objectives and ensure high performance for queries and reports.
• Implement indexing, partitioning, and other performance tuning techniques to ensure optimal data retrieval and processing.
• Continuously assess and enhance the performance of the data warehouse design, ensuring it scales effectively with growing data volume.
• Work with business and technical stakeholders to refine design requirements, focusing on both data quality and high-performance needs.

Reporting and Dashboard Development:

• Design and develop interactive, user-friendly reports and dashboards using Microsoft Power BI.
• Optimize reports and visuals for performance and usability to meet business requirements and provide actionable insights.

Requirement Gathering and Collaboration:

• Liaise with business analysts and business users to understand and document data and reporting requirements.
• Work closely with internal and external teams to translate business needs into technical solutions.

Testing and Troubleshooting:

• Conduct thorough testing of ETL processes and reporting solutions to ensure accuracy, performance, and reliability.
• Troubleshoot technical issues, including performance bottlenecks, and resolve them efficiently.

Monitoring and Maintenance:

• Develop and manage job schedulers to ensure smooth execution of data workflows.
• Monitor job schedulers and workflows to ensure the smooth execution of data integration processes.
• Troubleshoot and resolve operational issues, including failed jobs, data quality problems, or system performance bottlenecks.

System Maintenance and Upgrades:

• Perform regular updates, patches, and enhancements to the Data Warehouse system.
• Ensure adherence to best practices for data security, governance, and compliance.
• Maintain documentation of operational workflows, ETL processes, and system changes.

QUALIFICATION & EXPERIENCE

Education:

• Bachelor's degree in computer science, Information Technology, or a related field.

Experience:

• Minimum of 3 years of experience in developing ETL workflows and data warehouse solutions.
• Strong proficiency in
  Microsoft SQL Server and SSIS.
• Hands-on experience with data visualization tools, especially
  Microsoft Power BI.
• Proven ability to design and develop data warehouse schemas and data mapping with a focus on performance and scalability.
• Insurance/reinsurance industry and
  MFRS17
  knowledge is an advantage.

TECHNICAL COMPETENCIES REQUIRED

• Expertise in SQL development and query optimization.
• Strong understanding of data warehouse concepts, data analysis, data profiling of source systems and ETL best practices.
• Familiarity with large-scale data integration and reporting systems.
• Strong performance tuning experience in SQL and ETL processes.
• Excellent problem-solving skills with strong attention to detail.
• Effective communication skills to collaborate with technical and non-technical stakeholders.
• Ability to work independently and manage multiple development tasks simultaneously.