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

Advance Delivery Consulting; Hornsby; In loco; AUD 140.000 - 180.000; Tempo pieno

Descrizione del lavoro

Advance Delivery Consulting is seeking a seasoned Data Migration / Warehouse Project Manager with 10+ years of hands-on experience in delivering DM/DW/BI solutions. The role emphasizes ETL/DW expertise, analytics tooling, and cloud technologies, alongside strong organizational and leadership capabilities.

The candidate will plan, execute, and oversee end-to-end data migration projects, collaborate with stakeholders, and ensure data governance across platforms.

Competenze

• 10-12+ years of experience in Data Migration, Data Warehousing and BI solutions.
• Excellent communication skills and experience leading onsite and offshore teams.
• Strong understanding of ETL concepts and data warehousing.
• Experience with BI tools such as Power BI and Tableau.

Mansioni

• Plan, execute, and oversee DM/DW/BI projects within scope, time, and budget.
• Gather requirements and design solutions, through development and testing.
• Manage end-to-end data migration across legacy and modern systems.
• Oversee data governance and master data maintenance for consistency.
• Collaborate with stakeholders to define regulatory and compliance reporting needs.
• Build data pipelines and automate data using cloud technologies.
• Design data architectures, modeling and ETL processes across platforms.
• Create data models to transform raw data into insights and reporting.
• Develop pipelines for streaming and batch data.

Conoscenze

ETL/ DW

Project management

Analytics tools

Cloud technologies

Leadership

Formazione

Bachelor's degree in CS/IT

Master's degree or certifications (plus)

Strumenti

SQL Server

SSIS

IBM Informix

Descrizione del lavoro

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.

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