Position Overview
The Business Intelligence Lead leads the design, development, support, and implementation of a enterprise level reporting solution that will replace Zones on-premise custom Microsoft based BI solution with a global Business Data Lake (ADL Gen2) infrastructure along with Power BI dataflows and embedded D365 Power BI architecture.
Responsibilities:
- Assist the envisioning of the to-be Zones BI solution and drive enterprise wide data strategy leveraging D365 and Azure Analytics
- Engage with stakeholders to identify business KPIs with the correct tools/mechanism to record them and present actionable insights through reports and dashboards
- Ensure the to-be Zones BI solution is in alignment with the Microsoft BI roadmap
- Develop and manage effective working relationships with other departments, groups and personnel with whom work must be coordinated or interfaced
- Define, review, and maintain Business Intelligence/Analytic programs for compliance with best practices, industry standards, enterprise architecture, requirements and processes
- Establish and enforce data warehousing standards to meet requirements and business needs
- Provide oversight and guidance to assigned team(s) for the effective and timely development
- Schedule and balance team activities to meet deadlines for deliverables and meetings
- Develop in-depth understanding of underlying data, data structures, and business uses
- Hands-on development assistance, troubleshooting and mentoring to direct reports
- Oversee and monitor code reviews, and deployment packages
- Manage application lifecycle workflow in TFS / Azure DevOps and ensure policies are followed by team members
- Collaborate with Test Automation team to define framework and automate BI testing
- Collaborate with DevOps Lead to implement build automation
- Manage the team following SDLC methodology
- Enforce industry standards to enhance and maintain the to-be BI infrastructure
- Partner with others to assist with conducting root cause analysis to resolve performance and production problems and data issues and data validation
- Provide ongoing maintenance and support of all business intelligence applications
- Manage, control, direct, and supervise assigned direct reports, including general leadership, planning, organizing, and reviewing
- Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrate respect for others
Experience:
- Bachelor s Degree in Computer Science or Information Systems; or equivalent combination of education and relevant experience
- Certifications or direct experience in BI Development, Database Development, SQL Server or Cloud Platforms, also IT leadership preferred
- Knowledge of the capabilities of the Azure Analytics tools
- Experience with ERP and CRM data . Dynamics AX and CRM preferred
- Five years developing and implementing enterprise-scale BI tools/reports and dashboards
- Five years MS-SQL/TSQL writing stored procedures and database schema design
- Five years with Microsoft BI Stack including SSAS, SSIS, and SSRS development
- Three years of direct management/supervisory experience
- Extensive experience with data warehouse technologies and implementations such as ETL processes, dimensional modeling cloud services, and reporting tools
- Experience in automatically deploying reporting solutions, analytical tools and dashboards