Job Description

Role: IT Data Warehouse Analyst

Location: Toronto and Ottawa (Hybrid)

Needs strong Snowflake, SQL, Tableau, Python or Java, BI,

:

As a Data Warehouse Support Analyst, you will play a pivotal role in supporting ITIL related services for businesses by developing and implementing effective action plans that support optimal/efficient Data Warehouse (DW) operations.

Your responsibilities will include setting and enforcing standards for DW practices and operations, as well as performing DW administration and management duties to ensure the continuous improvement and stability of our Data Warehouse services.

In addition, you will design, develop and manage data warehouse KPIs to consolidate and organize data from various sources for reporting and analysis.

This includes escalating issues to the Cloud Vendor Manager, Service Owner, and vendors as needed for issues impacting normal business-as-usual activities.

Key responsibilities include:

Reporting & Analytics

: Develop and maintain reports, dashboards, and visualizations using tools like Power BI, Tableau, or Looker to provide business insights.

Documentation: Create business and technical documentation to support the development and end-user community.

KPI definition and continuous process improvement

Performance Optimization: Optimize the performance of the data warehouse and reporting systems and troubleshoot any issues that arise.

Ensuring Service Level Agreements (SLAs) are met for Snowflake related Tidal jobs.

Ensuring maximum system availability and prompt, accurate remediation of issues related to Snowflake and support components.

Continuously seeking optimal ways to move forward and improve Snowflake Cloud services.

Efficiently delivering Snowflake Cloud services to internal customers.

This role requires a combination of technical expertise, management skills, and leadership abilities to ensure smooth operations and the successful delivery of Data Warehouse services.

This role requires a combination of technical expertise, management skills, and leadership abilities to ensure smooth operations and the successful delivery of IT services.

Job Requirements:

Strong written and verbal communication skills.

Bachelor's degree in IT, information security, computer science, or a related field.

8 to 10 years of ITIL experience. Alternatively, candidates may possess an equivalent combination of relevant professional experience and education.

Technical:

Proficiency in Snowflake platform features, SQL, ETL tools, data modeling, database systems, and data warehousing concepts. They must also have a strong background in programming languages such as SQL, Python, or Java

Analytical:

Strong ability to analyze complex data sets, interpret trends, and identify issues.

Problem-Solving:

Excellent problem-solving skills to identify and resolve data-related challenges.

Communication:

Ability to clearly present complex data and insights to both technical and non-technical stakeholders.

Attention to Detail:

A strong focus on detail is crucial for ensuring data accuracy and integrity.

Develop and implement DW support service strategies aligned with business needs

Oversee the delivery of DW systems and services that support the stability of Snowflake and additional components

Analyze and monitor the effectiveness of DW support service delivery and implement improvements when needed

Ensure compliance with DW support standards, policies, and procedures, including disaster recovery and back-up procedures

Provide technical support and guidance, including problem resolution and troubleshooting

Develop and implement DW service quality control processes, policies, and procedures

Maintain current knowledge of technology trends and potential impact on the business

Additional Requirements:

Experience in database administration, data analysis, and data warehousing is often preferred.

Proficiency in Windows and Linux/Unix operating systems, including scripting with Bash or PowerShell.

Advanced knowledge of SQL and experience with web services.

Ability to provide technical support and guidance, including problem resolution and troubleshooting.

Hands-on experience with GitLab CI/CD pipelines, and Confluence

Assist in the development and implementation of the support strategy to include the definition and goals of the over-arching framework and methodologies.

Writing test cases to implement regression testing.

Support development teams with secure code (DAST, SAST, Dependency, Secret Detection, Container scans, Lint tests, etc.) reviews and other assessments to identify security weaknesses and vulnerabilities, code defects.

Establish and maintain secure coding standards and best practices to provide guidance and training for development teams on security and ISO best practices.

Review and research monthly continuous monitoring controls documentation tasks that are required by Senior Leadership Team (SLT).

Certifications/Licenses:

At least eight (8) years of experience working in information technology with a bachelor's degree. Minimum of 3 years' experience in change or release management, application and software support team management, root cause analysis, data analysis, information assurance, leading incident handling

Solid experience in application software development in one or more programming languages such as C#, Java, Python, etc.

Extensive experience with cloud-based technologies, specifically Snowflake, Azure Databricks, and Azure Data-Factory.

Proven experience with Tidal Automation Tool or other enterprise task schedulers

Experience with cloud-based infrastructure (AWS, Azure, or Google Cloud)

Job Type: Fixed term contract
Contract length: 12 months

Pay: $50.00-$60.00 per hour

Expected hours: 40 per week

Experience:

Data warehouse: 8 years (required) Business intelligence: 7 years (required) Snowflake: 5 years (required) SQL: 8 years (required) * Tableau: 5 years (required)