About the role

We have an exciting chance 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

📌 Senior Data Engineer (Australia)
🏢 Cerebral Palsy Alliance
📍 Australia