Responsible for the foundation’s overall Business Intelligence (BI) platform, ensuring a reliable, stability, performance and guiding reporting and analytics design and development across multiple projects. The Sr. BI Engineer partners across multiple efforts to develop and drive the overall design, development and operational maturity of our BI and Analytics environment. Collaborate with a community of data architects, ETL developers, Business Analysts, and BI developers to build a new Data Warehouse and Reporting environment. Be a hands-on business intelligence developer with an execution mindset and lead core software development activities as they pertain to development of BI reports, dashboards, and visualizations. Champion efforts to ensure adoption of the our platform across the foundation. Introduce repeatable reporting and analytics patterns and approaches to development and deployment standards. Provide guidance, mentorship, and technical expertise to the core report developers on projects.
- Collaborate with our business partner community, Business Systems Analysts, and Solution Architects to identify BI requirements and design creative solutions for governed, self-service, and application embedded reporting.
- Translate strategic project requirements into usable artifacts guiding to the development of a scalable semantic model with reusable Objects, and Reports.
- Review completed code, documentation and other deliverables to ensure that they meet specifications and requirements based on defined expectations.
- Responsible for processes to support the design, construction & unit testing of reports and visualizations to ensure long-term maintainability and scalability.
- Ensure best practices are being followed across development efforts by developing smart auditing and code review practices.
- Mentor other team members on technology features and roadmap and be recognized as a business intelligence thought leader.
- Support end users with report creation and troubleshooting.
- Participate in user group meetings and training to improve the overall knowledge of the primary users of the tool to ensure adoption across the organization.
- Gain in-depth understanding of our transactional systems and the relationship between those environments and the data warehouse.
- Lead our relationship with technology vendors including a regular cadence of touchpoints to provide feedback and influence product roadmaps.
- Regularly engage vendors on operational issues including performance management and user provisioning
- Lead and mentor our consulting partners on project teams
- Lead reporting and analytics design sessions leading up to code migration into production, ensures timely bug fixes, and provides guidance to business and technology management on process and technical issues.
- Work together with ETL and EDW developers and architects to develop cohesive and performant BI solutions
- Partner closely with our IT Service Manager to understand and translate business requirements into stories, tasks, and subtasks in support of delivering consumable value to our business partners in an Agile manner.
We believe that energized people, working well together, fueled by great leadership in an inclusive environment in which they thrive, will do phenomenal things.
Core Knowledge and Skills
- Minimum 7+ Years of hands-on development, architecture, and analyst experience to support design of Enterprise Business Intelligence solutions (e.g. PowerBI or Tableau).
- 7+ Years of passionate experience in developing Dashboards, Governed Reports, Embedded-Analytics, Visualizations etc.
- Excellent experience in full data warehouse implementation and knowledge of developing semantic models for highly performant standard reports and visualization.
- Hands on experience with modeling, development of Metrics, Attributes, Filters, Hierarchies, and other reporting objects.
- Full lifecycle perspective (requirements gathering through production deployment and support) in aspects of Business Intelligence solutions using platforms such as PowerBI and Tableau.
- Proficient with SQL, Complex SQL Tuning, Stored Procedures, and other techniques to develop highly performant cubes and other means of assessing data.
- Hands on experience architecting and developing in a modern, cloud-based BI environment. Highly experienced understanding of Business Intelligence Frameworks.
- Ability to work with Enterprise Architects and Data Architects to develop BI roadmap, repeatable development and deployment frameworks etc.
- Thorough business skills, including stakeholder management, preparing and delivering presentations and workshops, and collecting and challenging requirements.
- Ability to mentor junior developers and consultants on the team.
- Proficient with working in a highly Agile (SCRUM) environment.
- Ability to advise senior IT management on BI & Analytics trends