BI Developer

Scope of Position

Reporting to the Director, Applications & Banking Support, the BI Developer is a seasoned professional providing strategic, analytic and project support to Alterna Savings as relates to the Data Analytics program. This role will involve understanding the business requirements and working closely with all business lines to ensure the program is closely aligned with our evolving business needs. The advice given and decisions made will have a measurable impact on the profitability or effectiveness of the organization.

Major Responsibilities

• Collaborate with business and IT teams to design databases, data marts, data lakes, and data warehouses to ensure stability, reliability, and performance
• Develop ETL processes to effectively move data into data repositories
• Design, develop and maintain business intelligence and reporting solutions
• Design and develop dashboards, reports, key performance indicators and metrics utilizing SSRS, Power BI and other front-end reporting tools.
• Crafting and executing queries upon request for data and conduct analysis.
• Work collaboratively in a team environment with the ability to interact effectively with other groups in the organization, both technical and non-technical, to ensure systems meet business demands.
• Evaluate, maintain, and troubleshoot existing applications and databases. Address production support break-fix in timely manner, keeping IT management and business informed of status and resolutions.
• Communicate with all levels of management regarding information needs.
• Translate business requirements into technical specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources
• Provide support as required to ensure the availability and performance of developed reports and dashboards for users
• Ensure proper configuration management and change controls are implemented for your sphere of influence
• Design and implement technology best practices, guidelines, and repeatable processes
• Maintains technical documentation for all packages, descriptions of the data and data structures including data definitions, metadata, data models, and data flow diagrams
• Recommend schedule and perform software improvements and upgrades.
• Establish and implement policies, procedures, and technologies to ensure operational best practices.
• Provide on call support and after hours support as required.

Qualifications

Education / Certifications / Experience

• University degree/diploma in a computer science or related field and equivalent working experience with business analysis/intelligence, and information technology related positions or assignments
• Minimum of five years of experience with Business Intelligence development and analytics and database technologies
• Minimum of two years of experience with Microsoft BI products. Including Power BI, Azure and MSSQL.
• Background in data warehouse design (e.g., dimensional modeling) and data mining
• Experience with architecting, designing, implementing, managing, and supporting OLTP, OLAP or Warehouse Database Management Systems.
• Experience with IBM Cognos would be an asset.
• Proven experience as a BI Developer or Data Scientist
• Experience in the creation, development, and writing of technical and training procedures
• Experience in gather business requirements from a BI perspective.

Knowledge / Skills

• Strong understanding of the Microsoft technology stack (Azure, SQL Server, Integration Services, Analysis Services, Tabular, Reporting Services, etc.)
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Knowledge and experience with database design principles, including SQL, and ability to troubleshoot data issues within a database.
• Strong understanding of data warehouse and business intelligence concepts and best practice methodologies.
• SQL and relational database, Data Warehouse
• Power BI, DAX, and security rules.
• Some coding skills like VB, C#, JavaScript etc.
• Experience in Business Intelligence, Data Integration and Reports/Analytics
• Prior experience working with Financial and Operational data.
• Ability to multitask and adapt to shifting/changing priorities.
• Proven team player with a commitment to excellence and continuous improvement.

About Alterna Savings

Alterna Savings and Credit Union Limited (Alterna) has been the good in banking™ for over 110 years. Alterna is made up of Alterna Savings and Credit Union Limited and its wholly owned subsidiary, Alterna Bank.

As the first full-service, member-owned cooperative financial institution outside Quebec, Alterna Savings shares its expertise with 217,000 members through a network of 46 branches across Ontario, as well as call centre and digital channels. Members and customers also benefit from an industry-leading online brokerage, investment management services, and have access to over 43,000 surcharge-free ATMs in North America with THE EXCHANGE Network in Canada and the Allpoint Network in the US.

Working at Alterna

Alterna offers a fast-paced, impactful work experience in an organization that cares about doing good. For over 110 years, Alterna has been creating financial services that transform lives for the better, all while giving back to our community.

We are incredibly proud of our corporate culture, where everyone works together towards a common goal, the financial wellbeing of our members and customers. This commitment has earned us several prestigious employer awards, including the National Capital Region's Top Employers award for seven years running.

* Although we appreciate all applicants, preference will be given to candidates who most closely meet the qualifications, key skills, and competencies outlined above.

* Alterna is compliant with the Ontarians with Disabilities Act. If you have a disability, please contact the recruiter to let us know how we can accommodate you.