BI Developer

Alterna Savings - Ottawa, ON (4 months ago)

Apply Now

Scope of Position

Reporting to the Manager of IT Applications, 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.

Expectations / Outcomes

Recommendations for new approaches for continuous improvement at Alterna.
Ensure Alterna stakeholders will experience continuous uninterrupted access to the BI and ancillary services as per the agreed upon SLAs.
Development and execution of multiyear roadmap to ensure Alterna keeps abreast of changes in technology and business processes.

Contacts

Alterna Staff at all levels and departments
Senior IT Management
Consultants working for Alterna

Qualifications

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.

Competencies

Ability to perform multiple technical and complex tasks and adapt to changing priorities.
Review complex technical information and analyze situations to define issues and draw conclusions.
Ability to exercise initiative, tact, discretion and judgment.
Ability to deal effectively with people, work under pressure and meet deadlines.
Ability to think creatively and a willingness to pursue previously untried solutions.
Good organizational and time management skills as well as facilitation skills.
Excellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teams.
Analytical mind with a problem-solving aptitude
Ability to identify actions and follow up on issues.
Proven team player with a commitment to excellence and continuous improvement.
Review and interpret complex technical information and analyze situations to define issues and draw conclusions.
Highly motivate and directed with key attention to detail.
Custom Service skills an asset.

About the Alterna Financial Group

Alterna Savings and Credit Union Limited (Alterna) has been the Good in Banking for 111 years!

Alterna has grown from its humble beginnings to be the second largest credit union in Ontario, and one of the Top 10 in Canada, with over $8 billion in assets under management and more than 167,000 members and a network of 35 branches across Ontario. The impressive growth throughout the years stems not only from merging with other credit unions, but also from significantly gaining new retail, business and not-for-profit members as people recognize Alterna’s philosophy of putting members first.

Known for its fast-paced environment, Alterna is viewed as a trailblazer in the industry. Led by a CEO with a passion for innovation, Alterna was the first credit union to introduce a digital bank and the first to offer a fully digital end-to-end mortgage through its wholly-owned subsidiary, Alterna Bank.

Alterna is proud of its long history of helping communities thrive. It shared its success in 2018 by donating more than $1 million to the community and, in partnership with employees, contributed 11,300 volunteer hours. Its flagship Community Micro Finance Program also helps underrepresented groups. Since inception, the program has disbursed more than $5 million in impact loans and helped change the lives of more than 1,000 participants and their families.

Alterna is also extremely proud of its corporate culture. With a workforce of more than 600 employees, Alterna is honoured to be recipient of prestigious employer awards, including the National Capital Region’s Top Employers and Aon’s Best Employers (Platinum level) awards.

For more information please visit www.alterna.ca and www.alternabank.ca and connect with us on https://twitter.com/alternasavings.

Compensation

  • At Alterna, we offer a competitive total rewards program and an opportunity to truly make a difference. If you put people first and value excellence and integrity, we hope you'll apply!
  • 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.