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.

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.

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.

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 Rate