5 results for Data Warehouse Analyst

Data Engineer Our client is seeking a Business Systems Analyst (BSA) with expertise in data integration and ETL processes to support the design, development, and maintenance of data workflows using Matillion ETL/ELT. This role involves working with diverse data sources, ensuring data quality and security, and optimizing SQL queries within a cloud data warehouse environment (Snowflake). This is a long term engagement hybrid opportunity in London, Ontario. Key Responsibilities:<ul><li>Design, develop, and maintain data integration workflows using Matillion ETL/ELT.</li><li>Extract, load, and transform (ETL/ELT) data from multiple sources, including SQL Server, Oracle, Salesforce, and integrate into Snowflake or other cloud data warehouses.</li><li>Identify and implement process improvements for data collection, cleansing, and standardization.</li><li>Develop and optimize complex SQL queries and stored procedures to support efficient data processing.</li><li>Ensure data quality, security, and compliance with best practices and industry standards.</li><li>Troubleshoot and resolve data integration issues and performance bottlenecks.</li><li>Collaborate with data analysts, developers, and other stakeholders to support business needs.</li></ul>Critical Competencies:<ul><li>Strong attention to detail and execution-focused mindset.</li><li>Ability to manage unstructured and complex tasks independently.</li><li>Self-motivated with the ability to prioritize and manage multiple projects.</li><li>Demonstrates a continuous improvement mindset and drives process enhancements.</li><li>Strong team collaboration skills within a cross-functional environment.</li><li>Understanding of global business needs and emerging data trends.</li></ul>Qualifications & Skills:<ul><li>Bachelor’s degree in Computer Science, Software Engineering, or a related field.</li><li>3+ years of experience in data engineering, ETL/ELT development, or related fields.</li><li>Proficiency in Matillion or other ETL/ELT tools.</li><li>Strong knowledge of SQL, data modeling, and data warehouse concepts.</li><li>Experience working with cloud platforms such as Azure, AWS, or GCP.</li><li>Hands-on experience with Snowflake or similar cloud data warehouse solutions.</li><li>Excellent communication, problem-solving, and analytical skills.</li></ul>If you're a data-focused BSA looking for a dynamic opportunity to contribute to data integration and analytics projects, we'd love to hear from you!

ETL/BI Developer We are in search of an ETL/BI Developer to join our team located in Mississauga Ontario. As part of the team, you will be instrumental in developing and maintaining ETL processes, integrating data from different sources into data warehouses and BI systems, and working within the Azure Data Factory framework. You will also play a crucial role in supporting the data migration process related to M& A activities. Responsibilities:• Take charge of the development and maintenance of ETL processes to seamlessly integrate data from a variety of sources into data warehouses and BI systems• Design and optimize data models for use in business intelligence and analytics applications• Implement and maintain data transformation processes to ensure accurate reporting and analysis• Collaborate effectively with stakeholders to gather requirements for data solutions• Actively support the M& A data migration process, preparing and consolidating data to be imported into business applications• Integrate data sourced from M& A activities into the data warehouse to facilitate consolidated analytics• Utilize the Azure Data Factory framework to manage data integration and transformation• Manage data lake and warehouse artifacts using TimeXtender or similar ETL toolsets• Leverage Azure Synapse and/or Fabric Link to enable near real-time data integration and enhance the performance of analytics and reporting across cloud systems• Troubleshoot, test, and resolve issues related to ETL jobs and BI reports• Assist in the development of visualizations in Power BI as and when required.

Technical Business Analyst We are seeking a highly skilled Technical Business Analyst to act as the primary IT point of contact and liaison between the PMO (Project Management Office) and IT teams. This individual will be responsible for assessing project requirements, identifying technical solutions, and ensuring seamless execution of IT-related initiatives. This Technical Business Analyst opportunity is offered on a 12-month contract, includes a full salary, benefits and vacation time. Based hybrid on-site in Downtown Calgary two-days per week, this is a great opportunity for a technical resource to grow their projects experience. Key Responsibilities:<ul><li>Act as Lead Analyst for this years IT projects, including but not limited to a Windows 11 deployment, Network access control implementation, Switch refresh and eSignatures solution implementation.</li><li>Collaborate with Systems Engineers to ensure successful implementation of IT projects.</li><li>Lead technical research and solution recommendations for Secure Messaging (EPMO) projects, ensuring secure and effective communication between Advisors, PPI, and Clients.</li><li>Analyze complex business requirements, architect solutions with the team and vendors, and develop workplans leveraging Azure and On-Prem technologies.</li><li>Create and maintain high-quality documentation for new services and technologies to support seamless handoff to operational teams.</li><li>Work with Security and IT Operations Teams to ensure applications meet business-defined SLAs and security policies.</li></ul>

Technical Business Analyst We are offering a long term contract employment opportunity for a Technical Business Analyst in the manufacturing industry, based in Mississauga, Ontario. As a Technical Business Analyst, you will be instrumental in reviewing and understanding code, managing transformations, and documenting technical processes. You will also be required to liaise with the business and developers to ensure optimal performance. Responsibilities: • Review and comprehend code to ensure it aligns with the business requirements • Manage and understand transformations from various layers of architecture • Document technical processes for clarity and future reference • Collaborate with developers on the technical aspects of projects • Understand business output for PowerBI, ensuring it is critical and relevant • Utilize tools such as SQL for Azure data lake, Synapse, and PowerBI effectively • Provide technical documentation as required • Ensure the accuracy of project and configuration documentation • Assist in the understanding of medallion level architecture • Work with the business to understand and improve current processes.

Business Intelligence (BI) Analyst Notre client, une grande entreprise du domaine des services professionnels, est à la recherche d'un consultant en intelligence d'affaires (BI) pour un projet d'implantation de tableaux de bord de gestion. Il s'agit d'un contrat d'une durée de 6 mois, à temps plein, s'effectuant à 50% en télétravail (bureau au centre-vile de Montréal). Le titulaire du poste sera appelé à prendre un rôle central dans ce projet, tant au niveau de l'analyse des besoins d'affaires que de la réalisation technique. Le candidat idéal a une feuille de route éprouvée en BI et une capacité à rapidement livrer des résultats. Principales responsabilités: <ul><li>Définir les objectifs et l'étendu du projet avec les différents partis prenants;</li><li>Documenter les besoins d'affaires en matière d'intelligence d'affaires;</li><li>Définir les KPIs et différentes mesures à implanter;</li><li>Participer à la mise en place de l'architecture des données;</li><li>Participer à la mise en place des rapports et tableaux de bord;</li><li>Voir à la mise en place de bonnes pratiques de gouvernance des données dans le cadre de ce projet;</li><li>Autres tâches connexes au projet.</li></ul>