Data Warehouse Analyst

Get AI-powered advice on this job and more exclusive features. Direct message the job poster from Persistent Systems Senior Talent Acquisition - Persistent Systems About Persistent We are an AI‑led, platform‑driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry‑leading organizations across the world, including 12 of the 30 most innovative global companies, 60% of the largest banks in the US and India, and numerous innovators across the healthcare ecosystem. Our disruptor’s mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum by reporting $360.2M revenue in Q3 FY25, delivering 4.3% Q‑o‑Q and 19.9% Y‑o‑Y growth. Our 23,900+ global team members, located in 19 countries, have been instrumental in helping the market leaders transform their industries. We are also pleased to share that Persistent won in four categories at the prestigious 2024 ISG Star of Excellence™ Awards, including the Overall Award based on the voice of the customer. We were included in the Dow Jones Sustainability World Index, setting high standards in sustainability and corporate responsibility. We were awarded for our state‑of‑the‑art learning and development initiatives at the 16th TISS LeapVault CLO Awards. In addition, we were cited as the fastest‑growing IT services brand in the 2024 Brand Finance India 100 Report. Throughout our market‑leading growth, we’ve maintained a strong employee satisfaction score of 8.2/10. About Position: 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. Role: Data Warehouse Analyst Location: Toronto, (Hybrid) Experience: 8+ Job Description: 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) Competitive salary and benefits package Culture focused on talent development with quarterly promotion cycles and company‑sponsored higher education and certifications Opportunity to work with cutting‑edge technologies Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents Persistent Ltd. is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds. We offer hybrid work options and flexible working hours to accommodate various needs and preferences. Our office is equipped with accessible facilities, including adjustable workstations, ergonomic chairs, and assistive technologies to support employees with physical disabilities. If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment. We are committed to creating an inclusive environment where all employees can thrive. Our company fosters a values‑driven and people‑centric work environment that enables our employees to: Accelerate growth, both professionally and personally Impact the world in powerful, positive ways, using the latest technologies Enjoy collaborative innovation, with diversity and work‑life wellbeing at the core Unlock global opportunities to work and learn with the industry’s best Let’s unleash your full potential at Persistent For more detail, please contact – Puja (Puja_kumari@persistent.com) Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. Seniority level Seniority level: Mid‑Senior level Employment type Employment type: Contract Job function Job function: Analyst Industries: IT Services and IT Consulting and Banking Referrals increase your chances of interviewing at Persistent Systems by 2x Get notified about new Data Warehouse Analyst jobs in Toronto, Ontario, Canada. Business Data Analyst (Wealth Management) Business Analyst, Client Data Technology - Toronto, ON BI Analyst (Supply Analytics, Bangkok‑based, Relocation provided) Digital Business & Data Analyst - Global Agriculture Toronto, Ontario, Canada CA$68.96‑CA$68.96 1 month ago Toronto, Ontario, Canada CA$120,000.00‑CA$125,000.00 3 weeks ago Toronto, Ontario, Canada CA$30.00‑CA$40.00 19 hours ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr