Business Analyst and Business Intelligence Developer

Job Purpose

The DST Business Analyst and Business Intelligence Developer for Husky will be responsible for building the business intelligence system for the company, based on the internal and external data structures. Responsible for leading the design and support of enterprise-wide business intelligence applications and architecture. Works with enterprise-wide business and IT senior management to understand and prioritize data and information requirements. Solves complex technical problems. Optimizes the performance of enterprise business intelligence tools by defining data elements which contribute to data insights which add value to the user. Creates testing methodology and criteria. Designs and coordinates a curriculum for coaching and training customers in the use of business intelligence tools to enhance business decision-making capability. Develops standards, policies, and procedures for the form, structure, and attributes of the business intelligence tools and systems. Develops data/information quality metrics. Researches new technology and develops business cases to support enterprise-wide business intelligence solutions.

Key Responsibilities & Key Success Metrics

• Leading BI software development, deployment and maintenance             
• Perform Data Profiling and Data Analysis activities to understand data sources
• Report curation, template definition and analytical data modeling                                                         
• Work with cross-functional teams to gather and document reporting requirements         
• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources                     
• Identifies and resolves data reporting issues in a timely fashion, while looking for continuous improvement opportunities.
• Build solutions that create value and resolve business problems                                                         
• Provide technical guidance to designers and other stakeholders                                                         
• Work effectively with members of Digital Solutions Team             
• Troubleshoots analytics tool problems and tunes for performance                                                         
• Develops semantic layer and analytics query objects for end users                                             
• Translation of business questions and requirements into reports, views, and analytics query objects
• Ensuring that quality standards are met
• Supporting Master Data Management Strategy

Qualifications

• Understanding of ERP and Operational systems databases, knowledge of database programming 
• Highly skilled at writing SQL queries with large scale, complex datasets
• Experience in data visualization and data storytelling
• Experience designing, debugging and deploying software in ADO (Azure Dev/Ops) development environment
• Experience with Microsoft BI stack - Power BI and SQL Server Analysis Services Experience working in an international business environment
• Experience with Azure Data Platform resources (ADLS, ADF, Azure Synapse, Power BI Services)
• Basic manufacturing and sales business process knowledge
• Strong communication & presentation skills
• Ability to moderate meetings and constructive design sessions for effective decision making
• English language skills are a requirement, German & French are considered an asset