About the role
About the role
As a Business Intelligence (BI) Developer II, you will design, develop, test, maintain, and enhance enterprise BI applications that support data-driven decision-making across the organisation. You will own BI solutions end to end, provide specialised technical expertise and mentorship, and play a lead role in modernising the BI platform by supporting the transition to Microsoft Fabric.
Key responsibilities
Perform detailed systems, business and data analysis as preparation for implementation of complex BI projects.
Lead requirements sessions with business stakeholders and translate business needs into functional and technical specifications.
Design and develop dimensional data models and enterprise Power BI semantic models, including DAX, Power Query (M), row-level security, and incremental refresh.
Develop and test database programming components including, but not limited to, stored procedures, views, user defined functions, and SSIS packages to support data warehouse batch processes as well as enterprise data integration.
Optimize the performance of SQL queries, data loads, semantic models, and reports.
Review the work of other developers, mentor BI Developer I staff, and help define team development standards.
Review and validate user-built and partner-built reports prior to promotion to enterprise workspaces.
Lead migration workstreams moving data warehouse workloads and Power BI semantic models to Microsoft Fabric, and help define the patterns and standards used to rebuild them in Fabric.
Provide production support of BI applications and systems, including root cause analysis of recurring issues.
Ensure changes to BI systems comply with SOX ITGC change management and access control processes.
What we're looking for
Proficiency in the analysis and support of Business Intelligence & Analytics products and platforms including but not limited to data warehouse, data visualizations, data modeling, dashboards, and interactive reports.
Strong analytical, troubleshooting and problem-solving skills.
Should possess the ability to approach deliverables with a macro-perspective and able to understand business needs and requirements when delivering their technical solutions.
Proficient skills in interpreting, diagnosing and developing software programs.
Effective organization and prioritization skills.
Effective interpersonal skills.
Proven ability to complete projects in a timely manner.
Must be able to write, read, and verbalize English at a fluent level.
Working knowledge of SOX controls, change management processes, and Data Governance processes.
Knowledge of effective testing practices and methodologies.
Ability to support a 24/7 global business operation as required.
Demonstrate discretion, confidentiality, independent judgment and professionalism when representing the company.
Ability to work individually and in teams.