Data Analyst
Job Summary
We are banking at another level.
Choosing BDC as your employer means working in a healthy inclusive and skilled workplace that puts forward the best conditions to bring together unique teams where employees are empowered to act. It also means being at the centre of ambitious economic and financial projects to see further and to do things differently to fuel the success of Canadian entrepreneurs.
Choosing BDC as your employer also means:
Flexible and competitive benefits including an Employee Savings and Investment Plan where BDC matches part of your voluntary contributions a Defined Benefit Pension Plan a $750 wellness and health care spending account to name a few
In addition to paid vacation each year five personal days sick days as necessary and our offices are closed from December 25 to January 1
A hybrid work model that truly balances work and personal life
Opportunities for learning training and development and much more...
Explore the BDC Way in our Culture Book
POSITION OVERVIEW
The Data Analyst is a vital member of the Data Platforms and Tools Team playing a key role in ensuring the reliability and efficiency of BDCs Enterprise Data Platforms.
You will collaborate with data scientists data engineers data governance team and business data analysts to ensure timely access to high-quality data enabling advanced analytics and the delivery of actionable business insights.
Playing a key role in the Data & AI value chain your work will focus on data lineage data cataloguing and ensuring quality of data flowing through pipelines from streaming and batch data sources into the Enterprise Data Platforms.
You will also contribute to enterprise-wide best practices processes frameworks and libraries that data platform team creates and maintains to create value from data.
CHALLENGES TO BE MET
- Analyze and document source data to understand structure lineage and business relevance.
- Act as a bridge between data engineers and business or data analysts/data scientists by translating technical data structures into business-friendly formats and preparing mapping documentation.
- Identify data anomalies inconsistencies and gaps; collaborate with data engineers to resolve issues.
- Develop and maintain data quality dashboards and reports.
- Support root cause analysis and resolution of data-related incidents.
- Contribute to the continuous improvement of monitoring and alerting mechanisms.
- Provide ad hoc data extracts and support for internal users when needed.
- Engage in the estimation of user stories based on defined Acceptance Criteria ensuring alignment with data engineering workflows.
- Participate in the Data Platforms and Tools user community by sharing insights providing guidance and promoting best practices.
- Collaborate with Data Stewards and Data Governance team to ensure compliance with data policies and standards.
WHAT WE ARE LOOKING FOR
- A bachelors degree in IT Computer Science Statistics Mathematics or related fields.
- 4 years of industry experience as a Data Analyst.
- 4 experience withSQLfor data querying validation and transformation.
- 2 years of experience using Microsoft Power BI for dashboard development and data visualization.
- Proficiency with the Databricks platform.
- Experience with Google BigQuery is a plus.
- Proficiency with version control systems primarily Azure DevOps.
- Basic knowledge of scripting () is a plus.
- Experience with relational database management systems.
- Experience with data modeling data warehousing and data profiling tools and techniques.
- Familiarity with Agile methodologies and processes.
- Strong analytical mindset with attention to detail and data accuracy.
- Ability to interpret complex data structures and communicate findings clearly.
- Strong interpersonal communication and documentation skills.
- Bilingual (French & English).
Proudly one of Canadas Top 100 Employers and one of Canadas Best Diversity Employers we are committed to fostering a diverse equitable inclusive and accessible environment where all employees can thrive and feel empowered to bring their whole selves to work. If you require an accommodation to complete your application please do not hesitate to contact us at .
While we appreciate all applications we advise that only the candidates selected to participate in the recruitment process will be contacted.
Required Experience:
IC
About Company
We are BDC, the Business Development Bank of Canada and the financial institution devoted to Canadian entrepreneurs. We help create and develop strong Canadian businesses through financing, advisory services and capital, with a focus on small and medium-sized enterprises.