Database Analyst

Job title: Database Analyst

Company: Deloitte


Job description: Company DescriptionJoin us. But be you. At Deloitte, you’ll do more than just join something, you’ll add something. You’ve found a place that values your curiosity, passion, and desire to work alongside brilliant people on the things that really matter. There really is only one question: What impact do YOU want to make?Our Information Technology team is looking for a Database Analyst to join our Auckland office!Job DescriptionAbout this team:Deloitte’s Information Technology Services (ITS) team is dedicated to providing high-quality solutions for managing enterprise data and database systems. We work closely with stakeholders to design and optimize database environments, ensuring the seamless operation of applications. We are looking for a Database Analyst to join our team and help manage, enhance, and support our SQL Server databases and data warehouse infrastructure.What will your typical day look like?As a Database Analyst at Deloitte, you will collaborate with internal teams and business units to manage enterprise-level databases and data solutions. In this role, you can expect to:

• Design and implement databases to support the development of local applications and system integrations.
• Collaborate with developers and stakeholders throughout the Software Development Life Cycle (SDLC) and support released applications.
• Performance-tune complex queries to enhance application speed and ensure a seamless experience for end-users.
• Manage SQL Server databases, ensuring they are optimized, patched, and fully supported.
• Provide Level 2 and 3 support for database-related issues escalated by the Database Analysts.
• Perform routine maintenance and manage release deployment activities, including off-hours support when necessary.
• Support Business Continuity and Disaster Recovery (BC/DR) efforts, ensuring data integrity through scheduled backups and restoration tasks.
• Ensure security and compliance for database systems, performing monitoring and logging activities (e.g., index rebuilds, error logs, and security logs).
• Contribute to Data Warehousing projects, optimizing cloud data infrastructure and implementing ETL processes.
• Collaborate with business and technical stakeholders to ensure effective utilization of data warehouse architecture.
• Take ownership of major incidents, resolving escalated issues in a timely and effective manner.
• Develop and maintain comprehensive documentation for system configurations and database-related processes.

QualificationsEnough about us, let’s talk about you. You are someone with:

• Minimum of 2 years of experience in a full-time IT role, with expertise in database administration and data management.
• Proficiency with Microsoft SQL Server, Azure PaaS SQL, and data warehousing concepts.
• Experience with ETL/ELT processes and tools such as Azure Data Factory, SSIS, and SSRS.
• Strong understanding of dimensional modeling, slowly changing dimensions, and data normalization.
• Familiarity with Azure DevOps and CI/CD automation practices.
• Experience with Power BI and SSAS Tabular for data reporting and analytics.
• Strong problem-solving skills with the ability to troubleshoot and resolve complex database-related issues.
• Excellent communication skills, with the ability to work effectively with both technical and non-technical stakeholders.
• Ability to work independently and prioritize tasks in a fast-paced environment.

Additional InformationSo, who is Deloitte in Aotearoa?We are driven to create an impact that matters at every opportunity. Supported by a strong leadership team and member firms from over 150 countries across the globe, Deloitte New Zealand is in the business of solving complex problems.Over our 175-year history, we have built a reputation for impactful delivery across audit and assurance, consulting, financial advisory, risk advisory, tax, and technology services.Deloitte in Aotearoa recognises the uniqueness of our country identified in our founding document, Te Tiriti o Waitangi. We uphold our responsibility(s) to the founding document and acknowledge Māori as the Tangata Whenua/Indigenous people.Our workplace and cultureWe are driven by our desire to create positive outcomes for our clients, communities, and people. Our purpose is to make an impact that matters. Everything we do is with intent – the intent to make a meaningful difference.
Our shared values are at the heart of everything we do. Living these values, including ‘taking care of each other’ and ‘fostering inclusion’, is essential to ensuring everyone feels included at work and able to reach their full potential.
For us to succeed and thrive as an organisation, we understand the importance of creating a culture where diverse perspectives matter and where everyone is given an equal opportunity to grow and develop.Deloitte New Zealand rewardsWe hold a simple belief – that our people’s hard work should be recognised and rewarded beyond their remuneration.
We have reimagined what ‘work’ looks like and how we can empower all our people to create a work experience that is distinct to their needs. Founded on concepts of trust, balance, wellbeing, and the importance of personal connection, this is the Deloitte experience.We offer

• Flexible work arrangements – work in a way that suits you, us, and our clients best.
• Subsidised professional qualifications and paid professional memberships.
• Subsidised health insurance.
• Income protection insurance.
• 22 days annual leave.
• Social events, social sports teams, and monthly firm drinks.
• A focus on wellness and well-being.
• Community-focused volunteer days.
• A focus on the environment and sustainability.
• Plus much more.

Does this sound like the sort of role and organisation for you? Then apply now! We’d love to hear from you.We believe the strongest teams are made up of diverse individuals and we are proud to be an equal opportunities employer. We recognise that women and individuals from under-represented backgrounds may hesitate to apply if they don’t meet all criteria. If you’re passionate about this role and believe you have the skills, we encourage you to apply, even if your experience, ideal working hours or qualifications aren’t a perfect match.Please be aware of phishing attempts posing as Deloitte recruiters. Official communications from Deloitte New Zealand will come from “@deloitte.co.nz,” “@smartrecruiters.com,” or our video interview platform deloittenz.hirevue.com. If you receive a suspicious email, verify its authenticity by contacting us at .

Expected salary:

Location: Auckland

Job date: Tue, 08 Apr 2025 23:25:23 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.pro) you saw this job posting.Thanks&Good Luck