Location
Allambie Heights, NSW, Australia
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
Desirable skills:
Microsoft Azure familiarity include Synapse, Data Factory or Google Cloud and Big Query
Microsoft Power BI, Looker Studio skills
Salesforce Sales Cloud experience
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…