Data Warehouse/Migration/Reporting Project Manager – (Long-Term Project)

Job Summary

We are seeking a Data Migration / Warehouse Project Manager with 10+ years of hands-on experience in delivering DM/DW/BI solutions, with Strong ETL/DW background & knowledge of Analytics tools and Cloud based technologies responsible for end-to-end project delivery. Domain experience in Health Insurance industry strongly preferred.

The role requires excellent organizational, communication, and leadership skills to ensure the efficient and effective delivery of data solutions that meet business needs.

Key Responsibilities

Plan, execute, and oversee data migration/ reporting/ warehouse projects using established project management methodologies. Ensure projects are delivered on time, within scope, and within budget.Perform management activities from gathering technical data requirements and designing solutions, through developing code/ reports, to testing and release/ deployment.Manage end-to-end data migration project, ensuring accurate, secure, and efficient transfer of data across legacy and modern systems.Manage system integrations and oversee master data governance to maintain data consistency and integrity across platforms.Collaborate with end users, project stakeholders, and support partners to identify needs, goals, and business models around regulatory and compliance reportingBuild data pipelines and modern ways of automating data using cloud-based technologies.Data architecture management design, data modeling, and physical database design and tuning.Design and implementation of ETL processes across multiple platforms.Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights and data into reporting and analytics solutions.Design, develop, test, deploy, operate, and maintain pipelines that flow streaming and batch data.Managing models, tests, macros, analysis, Docs, end-to-end data transformation workflows using SQL using DBT.Understand business requirements to set functional specifications for reporting applications.Design and implementation of data analytics solution.Analyze current ETL procedures to define and create new systems.

Qualifications

Education: Bachelor’s degree in computer science, Information Technology, Business Administration, or a related field. A master’s degree or relevant Data warehousing , reporting technical certifications is a plus.

Experience

10-12+ years of experience with Data Migration/ Data Warehousing and BI solutions.Excellent communication skills and experience in leading onsite and offshore teams and managing deliveries with multiple stakeholders.Understanding of data migration and data warehousing concepts, clear understanding of ETL concepts, and mandatory experience on Data migration, data reporting and data warehousing.Experience on both Streaming and batch of Stream Sets, data collector and transformer, configure pipelines, and populate data in different databases.Experience in working with data related software like SQL Server, SSIS (SQL Server Integration Services), IBM Informix, etc.Experience in a role performing data warehouse and analytics solution design and development using a variety of techniques.Background with BI tools and systems such as Power BI, Tableau.

Please Note: This role requires you to work from the office (Sydney CBD) 3 days a week