Business Intelligence Developer
Top Benefits
About the role
Posting #: 25-89
Location: Hybrid
Reports to: Director, Data Analytics
Job Type: Regular Full-Time
Are you a community-minded person that’s passionate about investing locally and giving back to your community? Do you like working with other awesome and like-minded people toward a common goal?
Here at Your Neighbourhood Credit Union (YNCU), we are all about putting our money where our mouth is and keeping our dollars local and investing back into our members, staff, and community; and we are looking for people like you to join our team.
JOB SUMMARY:
Reporting to the Director, Data Analytics, the Business Intelligence Developer II plays an important role in supporting the information needs of the entire organization, with a finance focus. This role has a dotted line reporting into Director, Accounting, to collaborate on finance-related reporting tasks and projects.
As the Business Intelligence Developer II, you will combine your deep understanding of our business, with your passion for data visualization and user experience to streamline, optimize, and innovate analytical solutions that are easily understood, and drive high quality informed decision making and improve efficiencies across the business, particularly in the Finance area.
The Business Intelligence Developer II will be responsible for leading the process of defining and developing the system requirements of our internal business customers. This role will conduct data analysis, perform detailed database queries, and create report and dashboard solutions that turn data into insights and help meet finance and regulatory reporting requirements. The Business Intelligence Developer II will also lead the development of data transformation and data analytics solutions that the Business Intelligence (BI) team provides.
DUTIES & RESPONSIBILITIES:
- Lead the implementation of BI initiatives in support of overall business strategy with a finance focus.
- Responsible for end-to-end development of key performance metrics reporting.
- Understand business drivers, definitions, and metrics to interpret findings, and provide relevant direction.
- Proactively seek out areas of inefficiencies and provide technical solutions to solve issues.
- Collaborate on developing a governance framework to provide the right data to the right people.
- Accountable for ensuring concise documentation of BI related processes and procedures.
- Co-ordinate with the BI team and deliver outcome-focused data visualizations and data experiences that communicate actionable information to key stakeholders in a way that is informative, interpretive, and visually appealing.
- Preform and direct applicable QA and unit testing to ensure reporting analytics are accurate.
- Manage the design and development of high impact and timely information that actively supports Finance to manage performance, productivity and financial decisions.
- Collaborate with the Finance team on both external regulatory reporting projects and internal reporting initiatives and process improvements.
- Build and manage effective relationships with key stakeholders and functional groups and work collaboratively with the business and IT to leverage skills and experience and optimize the efficiency of project execution.
- Ability and desire to mentor other team members through projects independently from start to finish.
- Design, development, and deployment of AI and Machine Learning enabled solutions to address complex business problems.
- Develop Extract, Transform, and Load (ETL) processes to populate the data warehouse from various data sources.
- Utilize provided training as well as independent study to enhance skills to benefit YNCU.
- Act as backup for the Director of Data Analytics.
QUALIFICATIONS:
- Post-secondary degree or diploma in the field of computer science, data or business analytics or equivalent work experience.
- Minimum five (5) years of experience in advanced SQL queries and development.
- Experience with industry standard RDBMS (Oracle, MSSQL).
- Experience with Tableau.
- Experience with ORACLE and Microsoft BI Stacks (OBIEE, SSRS, SSIS, SSAS, PowerBI).
- Knowledge of Data Warehousing Methodologies (Tabular and Multi-Dimensional).
- Familiar with DAX and MDX query languages would be an asset.
- Experience using analytical tools such as python, R and Azure ML.
- Experience Developing AI and Machine Learning models.
- Proficient with Office 365 applications.
- Knowledge of banking systems and the financial services industry.
- Knowledge of Agile project methodologies.
- Must have a valid Ontario driver's license and reliable available vehicle.
- Must be bondable.
Why work at YNCU?
YNCU employees get to be a part of the growing credit union movement and help us get the word out on why banking locally is so important. We’re your friendly, helpful, and financially savvy neighbour who provides tailored financial services to our members, supports small businesses, creates local jobs, and gives back to causes that matter. Through our Good Neighbours Employee Volunteer Program and Monthly Staff Donation Draws, we even let you choose the causes we donate to and support. YNCU is recognized for the following:
- Certified Ontario Living Wage Employer
- B Corp Certified
- Flexible work arrangements once fully oriented
- Competitive Compensation, Incentive Programs and Benefits
- Remote/working from home hybrid option once fully oriented
- 37.5-hour work week
- 7% matching pension
- Benefits are 100% paid for by YNCU
- Employer under The Career Directory (2023): Canada’s Best Employers for Recent Graduates
- 2023 Canada's Healthy Workplace Month Great Employer Award
- Wellness Initiatives including our Employee and Family Assistance Program, premium membership for Calm, Consult+, and LIFT Virtual Fitness
- Training and Development Opportunities
- Community Sponsored Events Employee and paid Volunteer opportunities
- Opportunities to get involved with fun and meaningful committees
- Free banking account
- Discounted Employee Rates
To be considered for this opportunity please apply at https://careers.yncu.com/business-intelligence-developer-ii-finance-lead.
YNCU strives to be a diverse workplace reflective of the communities that we live in. We are committed to a diverse workforce and invite everyone to apply. YNCU makes hiring decisions solely on qualifications, merit, and business needs at the time.
YNCU is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, colour, sex, gender, religion, sexual orientation, national origin, disability, pregnancy, or any other protected characteristic as outlined by national, provincial, or municipal laws. This applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, and training.
Your Neighbourhood Credit Union will provide accommodations for persons with disabilities, where needed, to support their participation in our recruitment process. Please contact Human Resources at careers@yncu.com.
Job Types: Full-time, Permanent
Benefits:
- Casual dress
- Company events
- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- On-site gym
- On-site parking
- Paid time off
- RRSP match
- Vision care
- Work from home
Work Location: Hybrid remote in Kitchener, ON N2P 2N4
About Your Neighbourhood Credit Union (YNCU)
YNCU is a local credit union that's been serving communities across Southwestern and Northern Ontario for over 75 years. We pride ourselves on being an honest financial partner who understands the real trials and financial realities of our members' lives today. We’re the kind of partner who would rather use our profits to fuel local growth than let them leave the communities we belong to.
We're proud to be a Certified B Corp. As a cooperative organization, we believe in being a part of a larger movement to benefit all people, communities, and the planet. We are committed to being in business for purpose, not just for profit.
Our business thrives when people from the neighbourhood come to work with us, especially community-minded people who are passionate about giving back to the place they call home. Working here allows you to make meaningful connections and build a sense of community that sets YNCU apart from the big banks: we believe in keeping our dollars local by re-investing in our members, staff and neighbours.
Join our Neighbourhood and become part of a financial institution that is dedicated to making things happen for our members!
YNCU acknowledges the history of the traditional territory on which it operates. YNCU is headquartered on the traditional territory of the Neutral, Anishinaabeg and Haudenosaunee Peoples as well as on Robinson-Huron Treaty territory, traditional territory of the Anishnaabeg, specifically the Garden River and Batchewana First Nations, as well as Métis People. We recognize our responsibility to serve as stewards for the land and respect and honour the long standing relationships of the original caretakers who came before us.
This land acknowledgement is a small act of reconciliation on behalf of YNCU to our First Nations community members. We welcome any suggestions for this land acknowledgment, or for how we can better act as stewards of respect and reconciliation.
Business Intelligence Developer
Top Benefits
About the role
Posting #: 25-89
Location: Hybrid
Reports to: Director, Data Analytics
Job Type: Regular Full-Time
Are you a community-minded person that’s passionate about investing locally and giving back to your community? Do you like working with other awesome and like-minded people toward a common goal?
Here at Your Neighbourhood Credit Union (YNCU), we are all about putting our money where our mouth is and keeping our dollars local and investing back into our members, staff, and community; and we are looking for people like you to join our team.
JOB SUMMARY:
Reporting to the Director, Data Analytics, the Business Intelligence Developer II plays an important role in supporting the information needs of the entire organization, with a finance focus. This role has a dotted line reporting into Director, Accounting, to collaborate on finance-related reporting tasks and projects.
As the Business Intelligence Developer II, you will combine your deep understanding of our business, with your passion for data visualization and user experience to streamline, optimize, and innovate analytical solutions that are easily understood, and drive high quality informed decision making and improve efficiencies across the business, particularly in the Finance area.
The Business Intelligence Developer II will be responsible for leading the process of defining and developing the system requirements of our internal business customers. This role will conduct data analysis, perform detailed database queries, and create report and dashboard solutions that turn data into insights and help meet finance and regulatory reporting requirements. The Business Intelligence Developer II will also lead the development of data transformation and data analytics solutions that the Business Intelligence (BI) team provides.
DUTIES & RESPONSIBILITIES:
- Lead the implementation of BI initiatives in support of overall business strategy with a finance focus.
- Responsible for end-to-end development of key performance metrics reporting.
- Understand business drivers, definitions, and metrics to interpret findings, and provide relevant direction.
- Proactively seek out areas of inefficiencies and provide technical solutions to solve issues.
- Collaborate on developing a governance framework to provide the right data to the right people.
- Accountable for ensuring concise documentation of BI related processes and procedures.
- Co-ordinate with the BI team and deliver outcome-focused data visualizations and data experiences that communicate actionable information to key stakeholders in a way that is informative, interpretive, and visually appealing.
- Preform and direct applicable QA and unit testing to ensure reporting analytics are accurate.
- Manage the design and development of high impact and timely information that actively supports Finance to manage performance, productivity and financial decisions.
- Collaborate with the Finance team on both external regulatory reporting projects and internal reporting initiatives and process improvements.
- Build and manage effective relationships with key stakeholders and functional groups and work collaboratively with the business and IT to leverage skills and experience and optimize the efficiency of project execution.
- Ability and desire to mentor other team members through projects independently from start to finish.
- Design, development, and deployment of AI and Machine Learning enabled solutions to address complex business problems.
- Develop Extract, Transform, and Load (ETL) processes to populate the data warehouse from various data sources.
- Utilize provided training as well as independent study to enhance skills to benefit YNCU.
- Act as backup for the Director of Data Analytics.
QUALIFICATIONS:
- Post-secondary degree or diploma in the field of computer science, data or business analytics or equivalent work experience.
- Minimum five (5) years of experience in advanced SQL queries and development.
- Experience with industry standard RDBMS (Oracle, MSSQL).
- Experience with Tableau.
- Experience with ORACLE and Microsoft BI Stacks (OBIEE, SSRS, SSIS, SSAS, PowerBI).
- Knowledge of Data Warehousing Methodologies (Tabular and Multi-Dimensional).
- Familiar with DAX and MDX query languages would be an asset.
- Experience using analytical tools such as python, R and Azure ML.
- Experience Developing AI and Machine Learning models.
- Proficient with Office 365 applications.
- Knowledge of banking systems and the financial services industry.
- Knowledge of Agile project methodologies.
- Must have a valid Ontario driver's license and reliable available vehicle.
- Must be bondable.
Why work at YNCU?
YNCU employees get to be a part of the growing credit union movement and help us get the word out on why banking locally is so important. We’re your friendly, helpful, and financially savvy neighbour who provides tailored financial services to our members, supports small businesses, creates local jobs, and gives back to causes that matter. Through our Good Neighbours Employee Volunteer Program and Monthly Staff Donation Draws, we even let you choose the causes we donate to and support. YNCU is recognized for the following:
- Certified Ontario Living Wage Employer
- B Corp Certified
- Flexible work arrangements once fully oriented
- Competitive Compensation, Incentive Programs and Benefits
- Remote/working from home hybrid option once fully oriented
- 37.5-hour work week
- 7% matching pension
- Benefits are 100% paid for by YNCU
- Employer under The Career Directory (2023): Canada’s Best Employers for Recent Graduates
- 2023 Canada's Healthy Workplace Month Great Employer Award
- Wellness Initiatives including our Employee and Family Assistance Program, premium membership for Calm, Consult+, and LIFT Virtual Fitness
- Training and Development Opportunities
- Community Sponsored Events Employee and paid Volunteer opportunities
- Opportunities to get involved with fun and meaningful committees
- Free banking account
- Discounted Employee Rates
To be considered for this opportunity please apply at https://careers.yncu.com/business-intelligence-developer-ii-finance-lead.
YNCU strives to be a diverse workplace reflective of the communities that we live in. We are committed to a diverse workforce and invite everyone to apply. YNCU makes hiring decisions solely on qualifications, merit, and business needs at the time.
YNCU is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, colour, sex, gender, religion, sexual orientation, national origin, disability, pregnancy, or any other protected characteristic as outlined by national, provincial, or municipal laws. This applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, and training.
Your Neighbourhood Credit Union will provide accommodations for persons with disabilities, where needed, to support their participation in our recruitment process. Please contact Human Resources at careers@yncu.com.
Job Types: Full-time, Permanent
Benefits:
- Casual dress
- Company events
- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- On-site gym
- On-site parking
- Paid time off
- RRSP match
- Vision care
- Work from home
Work Location: Hybrid remote in Kitchener, ON N2P 2N4
About Your Neighbourhood Credit Union (YNCU)
YNCU is a local credit union that's been serving communities across Southwestern and Northern Ontario for over 75 years. We pride ourselves on being an honest financial partner who understands the real trials and financial realities of our members' lives today. We’re the kind of partner who would rather use our profits to fuel local growth than let them leave the communities we belong to.
We're proud to be a Certified B Corp. As a cooperative organization, we believe in being a part of a larger movement to benefit all people, communities, and the planet. We are committed to being in business for purpose, not just for profit.
Our business thrives when people from the neighbourhood come to work with us, especially community-minded people who are passionate about giving back to the place they call home. Working here allows you to make meaningful connections and build a sense of community that sets YNCU apart from the big banks: we believe in keeping our dollars local by re-investing in our members, staff and neighbours.
Join our Neighbourhood and become part of a financial institution that is dedicated to making things happen for our members!
YNCU acknowledges the history of the traditional territory on which it operates. YNCU is headquartered on the traditional territory of the Neutral, Anishinaabeg and Haudenosaunee Peoples as well as on Robinson-Huron Treaty territory, traditional territory of the Anishnaabeg, specifically the Garden River and Batchewana First Nations, as well as Métis People. We recognize our responsibility to serve as stewards for the land and respect and honour the long standing relationships of the original caretakers who came before us.
This land acknowledgement is a small act of reconciliation on behalf of YNCU to our First Nations community members. We welcome any suggestions for this land acknowledgment, or for how we can better act as stewards of respect and reconciliation.