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

Advance Delivery Consulting; Hornsby; On-site; AUD 180,000 - 240,000; Full time

Benefits offered by this job

Sydney CBD office three days a week

Job summary

Advance Delivery Consulting seeks a Data Migration / Warehouse Project Manager with 10+ years of hands-on experience delivering DM/DW/BI solutions, strong ETL/DW background, analytics tools, and cloud-based technologies. Domain experience in Health Insurance is strongly preferred; the role demands excellent organizational, communication, and leadership skills to ensure efficient end-to-end data delivery.

The role involves planning, executing, and overseeing data migration, building data

Qualifications

• 10-12+ years in data migration, DW and BI
• Proven leadership of onsite/offshore teams
• Strong ETL, data modeling and analytics background

Responsibilities

• Plan, execute, and oversee DM/DW/BI projects on time and within budget.
• Develop data pipelines using cloud technologies and ETL tools.
• Collaborate with stakeholders on regulatory and compliance reporting needs.
• Design data models and manage data architecture for analytics.
• Lead end-to-end data migration from legacy to modern systems.

Skills

Data migration

Data warehousing

ETL processes

BI tools

Cloud technologies

Project management

Team leadership

SQL Server

Education

Bachelor's degree

Master's degree

Data warehousing cert

Tools

SSIS

IBM Informix

Power BI

Tableau

SQL Server

Job description

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.

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 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