Business Intelligence Specialist
- 💼
- 📅
- Aug 25, 2022 Post Date
Grow with the best. Join a smart, creative, and inspired team that works behind the scenes to support operational excellence. As part of the Innovation Office, the Digital Technology & Innovation team is composed of digital experts who conduct research and development to keep our teams—and our client’s projects—ahead of the technological curve. They implement established technologies and find emerging solutions for all business lines (Buildings, Energy & Resources, Environmental Services, Infrastructure, and Water), bridging existing knowledge domains and facilitating the integration of powerful tools and methods. The team’s goals are to digitalize our organization, support Stantec’s digital transformation, and to increase the capacity of our designers, engineers, and scientists, providing higher-quality results and solutions to our clients.
Your Opportunity
The Innovation Office’s Digital Technology & Innovation (DTI) team has an opportunity for a Business Intelligence Specialist. This individual contributor position will be a member of the Data and Analytics Program Group, which leads the firm in Business Intelligence and data services by providing architectural guidance, technological vision, and solution development. Specifically, this position will use advanced analytics, reporting, and data visualization to give our business and our products a competitive advantage. It includes understanding and managing the data and how it interconnects as well as architecting data for self-serve BI and BA opportunities. This position requires a person who is business savvy, experienced in data analysis, data visualization, and enjoys framing a problem, shaping & creating solutions, and helping to champion implementation. As a member of the Digital Technology & Innovation team, the Data and Analytics group also engages in research & development and provides guidance and oversight as a center of excellence for the business. This group also engages in new product research and testing and the incubation of data analytics ideas.
The ideal candidate will be a self-starter, a critical thinker, and highly interested in the application of new data analysis and data visualization technologies and methods. The candidate will become a member of the Digital Technology & Innovation team; however, he or she will also be accessible to Stantec’s project teams to support project work as needed.
Your Key Responsibilities
Reporting to the Data Analytics Leader, your key responsibilities will include:
- Design, build and deploy powerful BI solutions as per business requirements.
- Connect to data sources, import data, and transform data for Business Intelligence.
- Customize data models to deliver new product features and support user experience through performance tuning, monitoring, and optimization.
- Generate insights & present effective data-driven business recommendations to various stakeholders.
- Help business units make informed decisions and understand the “what” and “why” via data analysis and visual storytelling.
- Apply automation and innovation on new and existing data projects.
- Work with data scientists, data engineers and project teams to assist with data related issues and support their data needs.
- Implement BI leading practices throughout the project lifecycle.
- Help identify the business data needed to produce the most useful insights and future analytics.
- Present periodic TechTalk/Spotlight (internal company) webinars throughout the year on the topic of data analysis and business intelligence, and present to external audiences as needed.
Your Capabilities and Credentials
- Curious, passionate about helping business lines drive their success utilizing data.
- Innovative problem-solver, ability to imagine new analytical solutions to any problem.
- Confident, able to challenge perceptions and biases of individuals diplomatically at every level of the organization in order to enact improvements.
- Ability to communicate to both technical and non-technical people.
- Ability to effectively organize, plan, prioritize, and manage time and competing priorities.
- Ability to execute complex or specialized projects.
- Business-oriented with a solid understanding of business requirements and vernacular.
- Highly detailed when required.
- Results-focused, able to focus on results and set an example for the team.
- Stays abreast of current and upcoming technologies and tools.
- Help build and deliver interactive dashboards with a robust design aesthetic.
- Professional experience in SQL, R, Python, or related tools for large-scale analysis.
- Experienced in analyzing extremely complex, multi-dimensional data sets with a variety of tools.
- Experience dealing with both structured & unstructured datasets and drawing the insights from the data.
- Advanced knowledge of Microsoft Power BI development, publishing, and scheduling reports.
- Proficiency in DAX queries.
- Basic Knowledge of Azure DevOps, Git Hub repository, and other DevOps tools.
- Experience using big data databases with Cloud experience preferred.
Education and Experience
- A Bachelor’s or Master’s degree in business, IT, mathematics, statistics, or another relevant area of study.
- Minimum 2 years of experience in BI development, data modeling, and report management.
Typical office environment working with computers and remaining sedentary for long periods of time.
This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.
Stantec is a place where the best and brightest come to build on each other’s talents, do exciting work, and make an impact on the world around us. Join us and redefine your personal best.