BI Developer

Project description

We are looking for experienced BI Developers with strong expertise in SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services) to join our team. You will work on developing, implementing, and optimizing Business Intelligence solutions for our clients, contributing to data integration, analysis, and reporting requirements. The role demands a deep understanding of database management, data warehousing concepts, and hands-on experience with the Microsoft BI Stack.

- Responsibilities
- Provide technical expertise to the team.
- Delivery results based on requirements set by the team lead.
- Provide oversight for the quality of the application and artifacts related to the application analysis and development.
- Collaborate with the production support team to implement sound change planning and change management.
- Be proactive in uncovering risk, manage and drive risks and issues understanding business impact.
- Strive for Best Practice in design and development.
- Contribute to the technology strategic agenda by driving application architecture simplicity and by minimizing production incidents through high quality development and processes.
- Be an active participant in regular task elaboration, prioritization and estimation workshops.
- Ensure Documentation is up-to-date and relevant.
- Build effective relationships with key Business Stakeholders.
- Overall
- Excellent people and communication skills.
- Excellent Team Player and driven to succeed
- Establish trust and credibility with stakeholders
- Embrace and be a role model for Enterprise Behaviours @ NAB.
- Comfortable assuming ownership for their work, and working independently with minimal supervision.
- Experience with requirements gathering as part of a team using agile development methods, e.g. User Stories.
- Confident working through various aspects of technology solutions (e.g. user interfaces, databases, system integration) and dealing with technology specialists
- Able to quickly build an understanding of the business environment, operating model, and terminology
- Solid understanding and experience in business process analysis, as-is and to-be process design, process decomposition. Able to apply varying techniques to model and communicate
- Strong problem-solving and troubleshooting. Focus on attention to detail.
- Ensuring relevant standards are applied to requirements deliverables.
- Provide professional and ethical behavior in your actions by ensuring compliance with external legislation, bank standards, and internal operating policies and procedures relevant to the position
- Skills Must have
- 7+ years of hands-on experience in BI development with a focus on SSIS and SSAS.
- Familiarity with all aspects of SDLC.
- Detailed experience with SQL Server, Analysis Services, Integration Services, Reporting Services (SSRS and PowerBI), and MDX queries for Cubes.
- Experience in SSAS multi-cube
- Excellent system design skills in a SQL Server Business Intelligence.
- Experienced with Source control
- GIT, Jenkins.Domain Knowledge
- Knowledge of Banking, Markets / Treasury products highly Desirable.
- Ability to be able to handle the complexity and dynamic nature of the Financial Services environment, requirement applications to adapt, be flexible, and learn quickly in a complex environment. Nice to have
- Experience with other BI tools such as Power BI or Tableau.
- Knowledge of data warehousing concepts and technologies (e.g., Azure Data Factory, Snowflake, or Google BigQuery).
- Familiarity with Agile methodologies and DevOps practices for CI/CD in BI development.
- Knowledge of MDX (Multidimensional Expressions) and DAX (Data Analysis Expressions).
- Experience in automating and scheduling jobs using SQL Server Agent or third-party tools.
- Exposure to cloud-based BI solutions like Azure Synapse Analytics or AWS Redshift.
- Understanding of financial data and reporting requirements.