Data Engineer

Position : Data Engineer Location : Mississauga, ON Experience : 8 plus years Type : Hybrid (2-3 days from office) Job Description: We are seeking an experienced Data Engineer with a strong background in Snowflake and SQL to join our technology team. The ideal candidate will be responsible for developing, optimizing, and maintaining our Snowflake data warehouse environment to support financial data analysis and reporting needs. The role requires a deep knowledge of Snowflake's unique capabilities, as well as proficiency in advanced SQL techniques and a comprehensive understanding of financial data. Responsibilities: Design, build, and maintain scalable and efficient Snowflake data warehouse solutions tailored for financial industry applications. Develop complex SQL queries, stored procedures, and scripts for data manipulation and retrieval. Optimize Snowflake performance through effective data modeling, partitioning, and indexing strategies. Collaborate with financial analysts and business stakeholders to understand data requirements and deliver precise reporting and analytical solutions. Ensure data integrity and security within the Snowflake environment, complying with industry regulations and standards. Manage data migration projects from legacy systems to Snowflake, ensuring minimal disruption to business operations. Provide technical expertise and support for Snowflake to internal teams, including troubleshooting and resolving issues. Stay up to date with Snowflake features and updates, continuously improving and expanding our data warehouse capabilities. Develop and maintain documentation for Snowflake processes, systems, and procedures. Requirements: Proven 8 years of experience in Snowflake data warehousing Development Strong expertise in Strong SQL and SQL query optimization skills Strong knowledge of data warehousing concepts and best practices. Familiarity with Snowflake's architecture, features, and best practices. Experience with data modeling, ETL development, and data integration techniques. Experience with Azure Data Factory (ADF) and other Azure services. Knowledge of financial industry standards, regulatory requirements, and data security protocols. Proficiency in Python for data processing and automation. Preferred Qualifications: Experience with financial reporting, risk management, or investment analytics. Familiarity with other data integration tools and BI platforms. Relevant certifications such as the Snowflake SnowPro Core Certification Valid Canada Work Authorization is needed. We can offer you: A highly competitive compensation and benefits package. A multinational organization with 55 offices in 20 countries and the possibility to work abroad Laptop and a mobile phone. 15 days of paid annual leave (plus sick leave and national holidays) A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region) Retirement savings plans A higher education certification policy Extensive training opportunities, focused on skills, substantive knowledge, and personal development On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms A flat and approachable organization A truly diverse, fun-loving and global work culture SYNECHRON’S DIVERSITY & INCLUSION STATEMENT Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more. All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Location: Mississauga, CA

Posted Date: 11/6/2024