Senior Data Analyst (PROJ-4496)

The Senior Data Analyst will be instrumental in building robust data automation solutions from complex data sources, streamlining data workflows, and developing interactive dashboards using Microsoft tools and Power BI. This role requires a proactive and innovative individual capable of translating complex data requirements into actionable insights and user-friendly visual tools. You will work directly to support better data-driven decision-making across the agency.

The Senior Data Analyst will possess a unique blend of technical mastery and strategic thinking, thriving in a dynamic and highly secure environment. They will be a proactive problem-solver with a meticulous approach to data, capable of transforming complex requirements into innovative and robust power platform solutions. Beyond their technical prowess in ETL, data modelling, power BI and Power Apps, they will demonstrate exceptional communication and collaboration skills, effectively bridging the gap between technical intricacies and diverse stakeholder needs to drive data-driven decision-making with ASD.

The Senior Data Analyst will require the ability to deliver high-quality, secure, and user-friendly data automation, analysis, and visualisation solutions that meet the stringent requirements of a national security environment.

The Senior Data Analyst will directly contribute to enhancing data-driven decision-making within ASD by providing timely, relevant, and insightful data, all while adhering to the highest standards of data security, privacy, and governance. This is a unique opportunity to apply your data expertise to a mission of national importance, making a tangible difference to Australia's safety and prosperity.

Key duties and responsibilities:

As a Data Specialist, primary responsibilities will include:

         Data Integration and Automation:

• Design, develop, and implement automated data pipelines to extract, transform, and load (ETL) data from diverse and complex internal and external sources.
• Ensure data quality, integrity, and consistency across all integrated data sets.
• Optimise data acquisition and processing workflows for efficiency and scalability.

         Data Analysis and Modelling:

• Perform in-depth data analysis to identify trends, patterns, and insights relevant to agency operations and strategic objectives.
• Develop and maintain robust data models that support complex analytical queries and reporting requirements.
• Collaborate with stakeholders to understand their data needs and translate them into technical solutions.

Data Visualization and Reporting:

** Develop and deploy interactive and user-friendly dashboards and reports using Microsoft Power BI.

** Create custom applications and forms using Microsoft Power Apps to enhance data collection and workflow automation.

** Ensure visualizations are clear, concise, and effectively communicate key insights to various audiences.

** Provide training and support to agency staff on the effective use of dashboards and data tools.

• Solution Design and Architecture:

** Contribute to the design and architecture of scalable and secure data solutions.

** Document data processes, data models, and visualization designs.

** Stay abreast of emerging technologies and best practices in data management, analytics, and business intelligence.

• Stakeholder Engagement:

** Work closely with business units and subject matter experts to gather requirements and validate solutions.

** Communicate technical concepts clearly to non-technical stakeholders.

** Provide expert advice and guidance on data-related matters.

         Technical Skills:

• Experience in database development, automation and implementation.

** Advanced visualisation and report writing skills in PowerBI, PowerApps, Microsoft Forms and SQL server reporting services.

** Effective data management and visualisation skills enabling the construction of a compelling story tailored to a variety of audiences.

** Experience with the Defence desktop environment and associated applications including the Enterprise Resource Planning management tools (human resources and finance).

** Highly experienced in using MS Work, MS Excel, MS PowerPoint 

Other information:

• WFH can be accommodated on occasion noting the majority of the work will need to be undertaken onsite at an ASD location.