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

Advance Delivery Consulting; Hornsby; On-site; AUD 140,000 - 190,000; Full time

Job summary

Advance Delivery Consulting is seeking a Data Migration / Warehouse Project Manager with 10+ years of hands-on experience in delivering DM/DW/BI solutions, including strong ETL/DW background and cloud technologies. The role is based in Sydney CBD and requires 3 days in the office weekly.

The successful candidate will lead end-to-end data migration projects, manage data integrations, governance, and analytics delivery, working with stakeholders across regulatory reporting and BI tools.

Qualifications

• 10-12+ years of experience in Data Migration, Data Warehousing and BI solutions.
• Excellent communication skills and experience leading onsite and offshore teams with multiple stakeholders.
• Strong understanding of ETL concepts and data migration, reporting and warehousing.

Responsibilities

• Plan, execute, and oversee data migration, reporting and warehouse projects on time, within scope and budget.
• Gather technical data requirements, design solutions, develop code/reports, test and deploy.
• Manage end-to-end data migration across legacy and modern systems.
• Oversee master data governance to ensure data consistency across platforms.
• Collaborate with stakeholders to identify needs and business models for regulatory reporting.
• Build data pipelines using cloud-based technologies and modern automation.
• Design data architecture, data modeling, and physical DB design and tuning.
• Design and implement ETL processes across multiple platforms.
• Create data models to transform raw data into insights for reporting and analytics.
• Design, develop, test, deploy, operate, and maintain streaming and batch pipelines.
• Work with SQL, DBT for data transformation workflows.

Job description

Job SummaryWe 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.

Job SummaryWe 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 reporting
• Build 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