About Synechron
At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs, we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications, and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,500+ and has 48 offices in 19 countries within key global markets.
Job Opportunity
Full time or contract hybrid – relocation assistance is provided. Must be in either Toronto or Montreal from day one. We are looking for a Data and Warehouse Engineer with strong Python, Pyspark, SQL ETL Warehousing and ideally some Snowflake with a financial background typically who plays a crucial role in a cloud-based data warehousing platform to manage and analyze financial data. Top technical skills required:
- Python
- SQL
- Data Warehousing
- Data integration/ETL
- Azure
- Snowflake
Primary Responsibilities
Working on Azure Architecture, design, implementation and operationalization of large-scale data and analytics and warehousing solutions on Snowflake Cloud Data Warehouse. Hands-on development experience with Snowflake features such as; Python; SQL, Tasks; Streams; Time travel; Zero Copy Snow SQL; Snow Pipe Cloning; Optimizer; Metadata Manager; data sharing; and stored procedures. Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling. Need to have working knowledge of MS Azure configuration items with respect to Snowflake. Developing ETL pipelines in and out of data warehouse using combination of Data bricks, Python and SQL/Snow SQL. Developing scripts UNIX, Python etc. to Extract, Load and Transform data, as well as other utility functions. Provide production support for Data Warehouse issues such data load problems, transformation translation problems. Translate mapping specifications to data transformation design and development strategies and code, incorporating standards and best practices for optimal execution. Understanding data pipelines and modern ways of automating data pipeline using cloud based testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions. Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.
Basic Qualifications
Minimum 8 years of hands on experience with productionized data ingestion and processing pipelines using Python, PySpark, Data bricks and SQL/Snow SQL. Experience designing and implementing an operational production grade large-scale data solution on Microsoft Azure Snowflake Data Warehouse experience highly desired. Understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies desired. Excellent presentation and communication skills, both written and verbal, ability to problem solve and design in an environment with unclear requirements.
Employment Benefits
- Highly competitive compensation and benefits package
- Multinational organization with 48 offices in 19 countries and the possibility to work abroad
- Laptop
- 15 days of paid annual leave (plus sick leave of 10 days and national holidays)
- Maternity & Paternity leave plans
- Comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
- Retirement savings plans
- Higher education certification policy
- Commuter benefits (varies by region)
- 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
- Flat and approachable organization
- Truly diverse, fun-loving and global work culture