Database Analyst

About Deloitte and the Role

At Deloitte, you will be joining a team that values individuality, curiosity, and collaboration with top professionals on meaningful projects. Deloitte's Information Technology Services (ITS) team in Auckland focuses on delivering robust solutions for enterprise data and database management. As a Database Analyst, you will play a key role in managing and enhancing SQL Server databases and data warehouse systems, supporting seamless application functionality and business operations.

Key Responsibilities

• Design and execute database solutions to facilitate local application development and systems integration.
• Work closely with developers and stakeholders throughout all phases of the Software Development Life Cycle (SDLC) and support live applications.
• Optimize performance by tuning complex queries to improve application responsiveness.
• Maintain and manage SQL Server databases, including patching, optimization, and support tasks.
• Provide advanced support (Level 2 and 3) for database issues escalated within the team.
• Conduct routine database maintenance and oversee release deployments, occasionally requiring off-hours support.
• Ensure business continuity and disaster recovery by managing data backups and restoration procedures.
• Implement security measures and monitor databases through logging and indexing activities to guarantee compliance and integrity.
• Participate in data warehousing projects by enhancing cloud data environments and managing ETL operations.
• Collaborate with both business and technical groups to leverage data warehouse architectures effectively.
• Take responsibility for resolving major incidents efficiently and thoroughly.
• Create and update detailed documentation related to database configurations and processes.

Candidate Profile

• At least 2 years of full-time IT experience focusing on database administration and data management.
• Proficient with Microsoft SQL Server, Azure Platform as a Service (PaaS) SQL, and concepts of data warehousing.
• Skilled with ETL/ELT tools such as Azure Data Factory, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
• Strong grasp of dimensional modeling, including handling slowly changing dimensions and data normalization.
• Experience with Azure DevOps and implementing Continuous Integration/Continuous Deployment (CI/CD) practices.
• Familiarity with data visualization and analysis tools like Power BI and SQL Server Analysis Services (SSAS) Tabular.
• Excellent problem-solving abilities with a track record of identifying and fixing complex database problems.
• Effective communicator capable of engaging with both technical teams and business stakeholders.
• Ability to work autonomously and manage priorities in a dynamic environment.

Additional Details

Deloitte New Zealand operates with a commitment to meaningful impact, rooted in a history of more than 175 years of service across multiple domains including audit, consulting, and technology. The organisation embraces the unique cultural heritage of Aotearoa New Zealand, acknowledging Te Tiriti o Waitangi and fostering inclusivity and diversity within its workplace culture.

Workplace and Culture: Deloitte prioritizes creating positive outcomes for clients, communities, and employees by fostering an inclusive environment that values diverse perspectives and personal growth.

Benefits:

• Flexible work arrangements tailored to personal and client needs.
• Support for professional development including subsidized qualifications and memberships.
• Health and income protection insurance packages.
• 22 days of annual leave.
• Engagement in social events, sports teams, and regular firm gatherings.
• Wellness programs and community volunteer opportunities.
• Commitment to environmental sustainability initiatives.

Deloitte is an equal opportunity employer and encourages applications from individuals of all backgrounds. Candidates are urged to apply even if their experience or qualifications do not precisely match every requirement.

Please note: All official Deloitte New Zealand communications will come from verified email domains only. Be cautious of phishing scams.