Business Intelligence DevOps Consultant

**Business Intelligence DevOps Consultant**
- **Full time permanent role**:

- **Data-led industry leader**:

- **Inclusive and diverse organisation**:

- **Flexible working arrangements**:

- **Parramatta CBD location - close to all transport**

**About us**

At Uniting, we believe in taking real steps to make the world a better place. We work to inspire people, enliven communities and confront injustice.

We are **bold, imaginative, respectful **and** compassionate.**

**About the role**

Uniting is a data-led organisation. In the Data & Analytics team, we boldly lead Uniting on the data and analytics journey - to inform staff to make the right decisions at the right time.

This role is a consulting role - you will work directly alongside management of front-line services that impact thousands of clients. You will work with people who are passionate about making a difference from many parts of the organisation. You will work end-to-end on data product development - requirements, design, development, testing, release, and product improvement through usage analytics.

You’ll also get to use the latest technology to make the world a better place - PowerBI, Snowflake, Azure Data Factory, Azure DevOps, Python, ServiceNOW, Dynamics 365 CRM/ERP. If you want a challenge to automate and innovate using DevOps tools and techniques, whilst making a huge social impact, then this opportunity is for you.

**Responsibilities**
- Design and develop data products (Visualisations, Reports, Dashboards, Data Warehousing, Data Integration, Data Insights) to add lasting value to Uniting services: Gathering, clarifying and documenting requirements; designing solutions; developing code/SQL/DAX, testing, UAT support, releases; usage analytics and monitoring.
- Running and improving the process of data product support and development through automation: e.g. access requests, data refreshes, releases, source control, knowledge management.
- Ensure functional & non-functional quality through data profiling, automated and manual tests, performance testing.
- Work under general direction and ensure good staff experience through effective communication such as written confirmation, expectation management, personal accountability, scope and time management.
- Plan through the logical steps to deliver a product from end to end through sprints whilst putting yourself in the shoes of Uniting staff to make your products understandable and intuitive.

**Qualifications**
- Tertiary qualifications in IT or a related discipline.
- 2-3 years' experience in your field of expertise

**Skills**
- Fluent written and oral communication
- ability to communicate with non-technical and technical staff - to be understood by staff.
- Empathy and insight to understand the roles, pain points and opportunities for data products for Uniting staff around managing services and caring for customers.
- **Strong SQL skills**:

- Data profiling (understanding, testing and proving assumptions about the format of data, and relationships between data; able to articulate the meaning of data; understanding of cardinality).
- Querying (correlated and uncorrelated subqueries, left, inner, anti joins, aggregations and filters and subqueries, union/except, null ordering, analytic and partitioning functions).
- **Strong PowerBI skills - specifically DAX.**:

- Data modelling skills:

- Kimball or other methodologies.
- PowerBI/Tabular cube design patterns, etc.
- Performance tuning.
- Time, scope and quality management through oral and written communication.
- Programming/Scripting - Python (preferred), PowerShell, or similar.
- Git or similar source control tools.
- Problem-analysis and problem-solving skills.

**Experience**
- Hands-on experience designing, developing and supporting Data Warehousing and Business Intelligence / Data Engineering solutions.
- DevOps and automation - hand-on experience automating aspects of product development and support such as Python scripting, calling APIs, automated releases etc.
- Significant experience with non-technical staff showing your skills in communication, empathy and insight.
- Experience in mastering new tools or techniques related to data.

**Benefits & culture**

Uniting is proud to be an EEO employer who supports an inclusive approach in the workplace. Aboriginal and Torres Strait Islander people are encouraged to apply.
- Have access to NFP benefits - an extra 16k tax free + up to $2650 of accommodation / meals
- Ongoing training & development
- Career development opportunities

**At Uniting we believe vaccination to be the best way to keep our employees and clients safe from COVID-19. COVID-19 and flu vaccination strongly encouraged but not mandatory.