This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

previous arrow
next arrow
Slider

Central 1: Business Intelligence Data & Systems Engineer

Central 1

This is a Contract position in Montreal, QC posted March 31, 2021.

Company DescriptionWe’re embarking on something BIGCentral 1 is the partner of choice for financial, digital banking and payment products and services – fueling the success of businesses across Canada.

With $16.9 billion in assets, we leverage our scale, strength and expertise to power progress for more than 225 credit unions and other financial institutions, enhancing the financial well-being of more than five million customers from coast to coast.

For more information, visit Central1.Com.Because of COVID19, all Central 1 offices are currently closed to non-essential employees.

This role will see you working remotely until our offices are reopened.

The timeline to reopen is still under consideration, as are our future remote working policies.Job DescriptionThe Business Intelligence Data & Systems Engineer will be responsible for designing, developing, and maintaining data pipelines and integrations between corporate systems at Central 1.

In this role, you will be an expert in using Microsoft SSIS packages to move data into the data warehouse and use SSIS to transform the raw data into data marts to meet business stakeholders’ data discovery and analytic needs.To succeed, you will need real-world experience building business intelligence solutions using Microsoft SQL Server, Integration Services, and Tableau.What you’ll be doing:Work with business and IT stakeholders to translate their business needs into business intelligence solutions Design, model and create data marts, views, and BI semantic layers Develop and maintain SSIS ETL jobs into the data warehouse and datamarts Develop and maintain Tableau Bridge & Tableau data sources tosupport reporting analytics Dive deep into data by leveraging SQL, Tableau, and Excel Recommend ways to improve data reliability, efficiency, and quality Participate in building a modern approach to Data Warehousing and the BI Platform to support self-service data discovery and analytics Monitor and test application performance for potential bottlenecks, identify possible solutions and work with developers to implement those fixes Maintains and owns Architectural documentation pertaining to the platform.

Performs other duties as required to deliver exceptional service and to support Central’s business goals QualificationsWhat you’ll bring:University degree in computer science (or equivalent) and 5 years relevant experience in a large-scale IT environment.Technical knowledgeDemonstrated experience using SSIS to design, develop and maintain ETL jobs and integration processes Experience with relational DBMS (MS SQL, MySQL, Postgres) is required Experience in data modeling, designing and documenting database schemas, both dimensional and relational, and data warehousing techniques, along with big data concepts is required Proven ability to identify, analyze, investigate and interpret trends or patterns in complex data sets Experience with Tableau and similar business intelligence analytic tools is required Understands source control and build management and the use of standard deployment tools like Jenkins, Bamboo, Bitbucket, JIRA, and Confluence is required Strong scripting and development experience with Python, R, C#, Java, or Javascript is required Experience using APIs as part of data pipelines is an asset Good understanding of Windows and Linux/Unix Operating Systems Experience in networks and firewalls – skillful ability to troubleshoot connectivity issues Familiarity with Azure Data Factory, Azure Databricks, Azure Data Lake, Snowflake AWS RedShift, and/or AWS Athena is an asset Soft SkillsAbility to communicate and facilitate ideas with developers and business stakeholders in both written and spoken form.

Ability to collaborate with various business stakeholders to address their data and information needs.Strong analytical and problem-solving skills.

Ability to work under pressure to meet process deadlines, project timelines Passionate about the customer experience and are not afraid to ask detailed technical and business questions.Strong understanding of Agile and Lean methodologies Experience in financial services, banking, and payments industry is a plus Additional InformationAs much as we believe in working hard, we also believe in personal growth and taking time for ourselves.

Accordingly, our total rewards philosophy amounts to one of the best compensation and benefits packages in the industry – from performance-based incentives and extended benefits, to training and education reimbursements and ample vacation time.Central 1 is committed to building a diverse and inclusive workforce by creating an environment where everyone feels like they belong and has the opportunity to be successful.

We are welcoming of all applicants and we will provide an accessible candidate experience.Reporting to: Manager, Business Intelligence & Corporate SystemsGrade: EDate Posted: March 19, 2021Internal Applicant due date: March 26, 2021External Applicant due date: April 16, 2021Location: Vancouver, British Columbia or Toronto/Mississauga, Ontario