Senior Data Engineer

LocationAllambie 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 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?
Apply through this job advert. 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 the rights of clients, we are a child safe organisation and all workers must adhere to the NDIS Worker Code of Conduct.

Skills
.NET, Git, Azure, CI/CD, SQL, ETL, Power BI, Agile, Jira, Confluence