Business Intelligence Report Analyst - Jobs in Calgary, AB

Job Description

AMA:YOU’VE never MET A PROBLEM YOU COULDN’T SOLVE.Posted: 2022-01-20Closing: Until FilledLocation: Bridgewater Bank, CalgaryWhen you hear a problem - paths to solutions leap into your brain. You love using your strong analytical background and lending/risk management experience to help your team find solutions. You have a thorough understanding of relational data modelling systems and reporting requirements. You’re fluent in Power BI and other Business Intelligence (BI) tools and you work well with a broad group of people to clearly communicate every step of the way.*Please note that remote work is offered temporarily during the COVID pandemic. Only candidates that live in Calgary will be considered for this position.*WHO IS BRIDGEWATER BANKUnlike a traditional bank, we have no branches. This means less time managing logistics and more time focussed on you and our ‘why’ – helping you succeed. Our focus is providing honest, straightforward service and financial solutions for everyday living and important life events.We’re financial service experts with flexible mindsets. Being a smaller bank makes us nimble, and that means we can respond quickly with innovative approaches that don’t need to go through multiple levels of approvals.Our customers are everything. When you become a customer of Bridgewater Bank you’re like our neighbour – even family – and we treat you that way.WHAT MOVES YOU

• At your core, you are analytical, detail oriented and technically astute.
• You have a professional demeanor with the ability to develop cooperative working relationships in all areas of the business.
• You’re self-motivated and comfortable working effectively and creatively with little direction.
• You’re comfortable working in a team environment, collaborating with people from all levels of the organization to accomplish common goals.
• You have a knack for quickly adapting to change and embracing new challenges.
• You don’t need anyone to light a fire under you; you know what needs doing and you get things done.
• You’re a problem solver, with the ability to understand business priorities and align current objectives accordingly.
• You’re a stickler for details and accuracy and have an uncanny ability to get your hands on the right information quickly.

WHAT YOU’LL DO

• Report to the Senior Team Lead, Business Intelligence.
• Gather effective requirements from the business to create BI reports, dashboards, KPIs, and visualizations from various data sources.
• Work with end-users to design and develop highly informative, visually appealing analytical reports depicting a data story and generate insights through dashboards that inform and influence business decisions and is easily consumed by the business.
• Design, develop, deploy, and maintain high-quality BI reporting such as: standard tabular reports, dashboards, KPI’s, ad-hoc, drill down, interacting reporting and geographic visualization for geo analysis.
• Collaborate with the business to elicit data and reporting requirements, manage, and standardize all reporting and test to ensuring the accuracy of the deliverable.
• Assist in ad-hoc needs - data validation, clean up and import/export requests as needed.
• Participate in various data infrastructure projects.
• BI report delivery focus, but you still have a good grasp on database management systems, ETL concepts and BI reporting platforms.
• Work independently as well as within a team in various projects in growing and improving our current data warehouse environment and reporting.

WHAT YOU’VE DONE

• You have post secondary education in Business Administration, Statistics, Computer Science or equivalent combination or education and experience.
• You’re no newbie. You have 3-5 years of experience working in a financial institution – on this we must insist.
• You have about 3-5 years of work experience as BI Developer such as: gathering and documenting business requirements and translating into BI reporting specifications; design and develop data sets using ETL; designing and developing various high-quality BI reporting and dashboards.
• Solid understanding of business requirements, aligning all deliverables with Analytics BI standardized analytical products and can easily be used across the organization.
• Knowledge of software development practices, concepts, and technology obtained through formal training and/or work experience.
• Proficient level of knowledge in following reporting technologies: WebFocus, PowerBI, Microsoft BI Stack technology: MSSQL, SSIS, SSAS, SSRS.
• Proficiency in data extraction and transformation from various sources used for BI reporting.
• Proficient in T-SQL Queries, views, procedures, functions, in memory data processing, code optimization, data transformation.
• Strong interpersonal skills with the ability to communicate and understand the needs of non-technical business owners.
• Experience with multi-dimensional data modeling
• Knowledge of concept fundamentals, architecture, design, data loading & processing, modeling and/or implementation of different components of our data warehouse
• Ability to work on multiple projects and prioritize in a deadline-oriented environment.
• Maintains Agile workflow with Analytics team and delivers exceptional accuracy and timely delivery of all production deliverables
• Proficient with MS office applications: specifically, Word, Excel, Visio, PowerPoint.

WHAT YOULL GET

• Competitive salary.
• Flexible benefits.
• Outstanding employer-paid Pension Plan.
• Great AMA discounts.
• Unlimited learning opportunities.

We thank all applicants for their interest; however, only those selected for an interview will be contacted.Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job

Stay Connected