Data Analyst, People Analytics

Our bottom line is different.

There’s something special about working at ATB, and it’s been recognized on every top employer list that matters. Maybe it’s our exceptional culture where your total wellness is supported through market-leading benefits and you’re free to bring your whole self to work. Maybe it’s our commitment to a growth mindset and our unrelenting thirst for making it possible for fellow Albertans—even the ones who aren’t our clients.

Whatever it is, you won’t find a more genuine, driven and knowledgeable group of humans anywhere. We foster a culture of purpose, performance and possibilities. We engage with intense curiosity, and bring our whole selves to work, every day. We know it starts with people like you, so take a chance and start with us.

Job Number: REQ3203

Location: Calgary/Edmonton, but option to work fully remote

Apply by: January 23, 2022

Paygrade: Under Review (K or L-OTH)

# Positions available: 1

Leader Name: Managing Director, Data Enablement & Human Insights

As ATB’s next Data Analyst, you will contribute to the overall success of the Data Enablement and Human Insights team within People & Culture. The DE&HI team is responsible for enabling Leaders, HR Consultants and Partners across ATB to make evidence-based decisions on Talent and People Analytics matters, which thereby support the creation and execution of People and Business strategies. This role is responsible for synthesizing complex data using advanced analytics, data visualizations, and storytelling to evaluate and communicate progress in support of maturing our talent practices.

Responsibilities:

• Data Analysis
  • As a key player in projects, gather and breakdown complex requirements, understand the root cause, and translate it into questions that can be approached through analytics
  • Generate and test hypotheses by completing ETL processes, running SQL queries and writing SQL scripts, building models, and creating dashboard views (Tableau reports)
  • Perform in-depth analysis and use relevant domain knowledge to identify trends and/or causal relationships to provide relevant, credible, and actionable recommendations
  • Provide reporting support, including the generation of accurate and timely standard and ad-hoc reports for senior leadership in TIE
  • Define KPIs and set up data sources for team and group performance scorecards
  • Use descriptive and predictive analytics to understand and forecast talent demand and supply to support strategic workforce decisions

• Storytelling and Dashboard Design
  • Synthesize data using data visualizations and dashboards tailored to the audience and use
  • Tell the story behind the analysis in a clear and compelling way by helping a variety of audiences understand the “so what” from their perspective

Requirements

• A Bachelor’s degree in Business, Finance, Math, Data Science or related field or equivalent experience
• 3+ years of practical progressive data analytics experience in building and supporting complex systems using latest technologies is essential
• Must be able to understand, modify and develop SQL/database queries for data analysis and building of business requirements
• Strong working knowledge of BI tools like Tableau and PowerBI is a must
• Comfort working with large sets of data with ability to merge and analyze data from disparate sources
• Strong understanding of Information design and storytelling concepts is a must
• Must be a self-starting, results-oriented and highly motivated individual with ability to work in a fast paced, agile environment
• Must be able to navigate ambiguity while being highly adaptable and flexible to changing demands
• Must have excellent written and oral communication, strong analytical, problem solving and troubleshooting skills to identify/document critical issues, prioritize and apply technology and industry practices in the most beneficial ways.
• Progressive business/IT experience with minimum of 3 years of exposure to latest technologies/platform (e.g., GCP Big Query, SQL programming, Tableau, Python, concept of cloud platform)
• Knowledge of the Human Capital and People Analytics domains will be considered a strong asset.
• Nice to have working experience in agile methodologies ( JIRA, Scrum).

At ATB, we know that as you develop in your career, you gain many transferable skills. If you believe your experience and qualities are a match for this position, please consider applying.

Benefits

Be great. Be you. Believe.

We are dedicated to building a workforce reflective of the diversity within our communities and creating an environment where every team member has what they need to reach their potential. We encourage candidates from all equity-seeking groups to apply.

What happens next?

Thank you for applying online. If you are shortlisted for this opportunity, you will hear from us after the posting close date regarding next steps. We might ask you to participate in a digital interview or phone interview. If you require any accommodations, please let us know.

ATB Financial team members are required to disclose their COVID vaccination status and provide proof of vaccination or complete COVID rapid testing as a condition of employment to help support client and team member safety. We thank all candidates in advance for their understanding.

Stay in touch!

ATB is excited to know you’re interested in a career with us! Follow us on LinkedIn, Facebook and Instagram to get the inside scoop on what our team is up to.