Senior Data Engineer

Cerebral Palsy Alliance; New South Wales; On-site; AUD 140,000 - 200,000; Full time

Benefits offered by this job

Meal & venue card (tax-free)

WFH/flexible hours

Additional leave

Well-being allowance

Fitness Passport

Employee Assistance Program

Referral bonus

Job summary

Cerebral Palsy Alliance in Australia seeks a Senior Data Engineer to design, develop and maintain data solutions on CPA’s Microsoft Fabric platform. The role covers the fundraising data platform from ingestion through to a dimensionally modeled data warehouse and semantic models.

The position is a 24-month fixed-term contract with potential extension, requiring collaboration with stakeholders, data governance and CI/CD automation across sources including Salesforce.

Qualifications

• 5+ years in complex outsourced environments.
• Bachelor's degree or higher in Data Engineering, CS or related.
• Knowledge of BI, data warehousing and data lake concepts.
• Experience building ingestion, processing and analytics pipelines.
• Designed data warehouses with star schemas on Fabric.
• Experience with Microsoft Fabric CI/CD pipelines and related tools.
• Collaborates with Analytics/BI teams to model and prepare data for insights.
• Adheres to data governance and testing within change management.

Responsibilities

• Set up data architecture and the Data Lake with Senior Manager, Enterprise Data.
• Assemble large, complex data sets meeting business requirements.
• Develop end-to-end ETL/ELT packages and data pipelines.
• Load data from diverse sources using SQL/.Net and Azure technologies.
• Troubleshoot data infrastructure with stakeholders and support teams.
• Create data tools for analytics and BI developers.
• Lead reporting, dashboards and analytics development.
• Document designs aligning to overall data architecture.
• Lead testing and sign-off with stakeholders.

Skills

Communication skills

Agile project experience

Data modeling

ETL pipelines

Cloud data warehouse

Azure Data Factory

CI/CD

Documentation

Education

Degree in Data Engineering

Postgraduate qualifications in Data Engineering

Tools

Azure Data Factory

SQL

Git

PowerShell

Synapse

BigQuery

SSIS/SSRS/SSAS

Job description

About the role

We have an exciting opportunity for a skilled Senior Data Engineer to join our IT Services support team to support designing, developing and maintaining data solutions on CPA’s Microsoft Fabric platform.

Working with internal and external subject matter experts and stakeholders, the role delivers CPA’s Fundraising data platform, from ingestion through to a dimensionally modelled data warehouse and semantic models.

The role manages all stages of data development, including requirements, technical design, build, testing and deployment. It delivers reliable, well-modelled data that supports consistent reporting and analytics and informed operational and financial decision making.

Please note that this role is a 24-month fixed-term contract with an opportunity to extend.

Required skills:

• 5+ years’ experience working in complex outsourced environments
• Relevant tertiary degree and/or post graduate qualifications in Data Engineering, Computer Science, or a related discipline and/or experience working with large volume databases
• Understanding and knowledge of business intelligence, data warehousing and data lake concepts
• Experience in developing data ingestion, data processing and analytical pipelines for big data, relational databases and/or data warehouse solutions
• Demonstrated experience in designing and build cloud data warehouse solutions using dimensional models (star schemas) on Fabric
• Hands on engineering of solutions and data pipelines utilising CI/CD and automation in Microsoft Fabric (Data Factory pipelines, notebooks, Dataflows Gen2) for a range of sources including Salesforce
• Collaboration with Technology teams, Data Analysts and BI Developers to model, curate and prepare data for analytics and insights
• Strictly adhere to our data governance framework ensuring a high degree of accuracy of outputs from the Information Management team
• Works to build out a framework to fully complete and document all testing in relation to change management, as part of a continuous delivery and integration framework
• Modern cloud data experience in Microsoft SQL Server BI Stack, ELT/ETL development processes, Azure, .Net or PowerShell
• Experience with Azure Data Factory, GIT, SQL
• Strong communication skills with experience in presenting and translating business needs into technical solutions and producing informative technical and nontechnical documentation as well as the ability to communicate, support and train non-IT staff
• Highly independent, with the ability to work constructively with teams and senior management
• Demonstrated experience in documenting System Architecture
• Microsoft Azure familiarity include Synapse, Data Factory or Google Cloud and Big Query
• Experience with SSIS, SSRS, SSAS
• Knowledge of FIA Code of Conduct/Standards of Fundraising
• Agile project experience and knowledge of Jira and Confluence will be highly regarded.
• Experience with business analysis
• Experience with change management and liaising with business change management practices
• Relevant tertiary qualifications in Information Technology / computing
• Understanding of data and/or CRM transformation
• Previous experience in the Not-for-Profit fundraising space
• Previous experience with ThankQ

Responsibilities of the role (not limited to):

• Work with the Senior Manager, Enterprise Data to setup the data architecture and the Data Lake
• Assemble large, complex data sets that meet functional / non-functional business requirements
• Undertake development activities across the full end-to end development cycle, from initial analysis to design, development, testing, implementation of data processing (ETL) packages, documentation, and post-delivery maintenance and support using agreed practices consistent with maturing data quality assurance
• Support planning and building the platform required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL/.Net and Azure/SaaS ‘big data’ technologies
• Work with internal stakeholders to resolve data-related technical issues and support their data infrastructure needs
• Create and facilitate data tools for analytics and BI developers. Assist them in building and optimizing our data lake
• Support in the development of reporting, dashboards and analytics using systems and tools as required
• Lead the data engineering function and support team members to build accurate dashboards and reports
• Assist in the gathering of requirements from business stakeholders, internal and external clients
• Document and contribute to the design of solutions that align with the overall data architecture for the business
• Create test scenarios and lead the testing and reconciliation of data/processes for signoff by stakeholders
• Become a subject matter expert on the data domain
• Deliver solutions that ensure projects are delivered on-time, on-budget and to CPA quality standards

Working for CPA offers you exceptional remuneration & benefits:

• Access to a tax-free meal, entertainment & venue benefit card valued at $2,650 per year
• Flexible ways of working - working from home options, flexibility surrounding hours
• Additional leave days
• $100 per year well-being allowance that you can use to enhance your wellbeing (eg: purchase sports equipment, have a massage, take a meditation class, the choice is yours)
• Discounted gym membership for you and your family, using Fitness Passport
• Employee Assistance Program
• Paid Employee Referral Bonus Program, where you can be generously rewarded for referring a friend that joins CPA.

Our Values:

At Cerebral Palsy Alliance we champion diversity and equitable opportunities for people with disabilities and lived experience, Aboriginal and Torres Strait Islander people, culturally and linguistically diverse backgrounds and the LGBTQIA+ community.

We are passionate, respectful, ethical, curious and courageous. Great Minds Think Differently.

Ready to Join Us?

We are committed to supporting inclusivity for anyone with diverse needs and lived experience. Workplace adjustments can be discussed to create a safe and comfortable workplace that supports your health, abilities, and personal needs.

More information about working for CPA:

For the safety of staff and clients we have assessed that this role requires a low level of physical functionality.

Cerebral Palsy Alliance upholds and advocates for therights of clients, we are achild safeorganisation and all workers must adhere to theNDIS Worker Code of Conduct.

Be careful - Don’t provide your bank or credit card details when applying for jobs. Don't transfer any money or complete suspicious online surveys. If you see something suspicious, report this job ad .