Job Specifications
Role: Bi Data Analyst
Location:Toronto,ON (Hybrid)
Needs strong Snowflake, SQL skills
Job Description:
· 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)
About the Company
Rivago Infotech Inc has been a leader in IT staffing and Software development for over 5 years and is one of the largest diversity and development firms in the industry. We are known for our high-touch, customer-eccentric approach, offering our clients unmatched quality, responsiveness and flexibility . We are appreciated by our clients for our streamlined execution, highly efficient service and exceptional talent management that go above and beyond traditional staffing services.
Know more