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 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.