Associate Data Engineer supporting data engineering projects at The Hartford in Hartford, CT and Charlotte, NC. Engaging in projects that involve data analysis and developing data assets using various technologies.
About the role
- Senior Data Engineer / Snowflake Architect leading the design and optimization of data solutions. Working closely with clients and internal teams to build scalable architectures in a hybrid environment.
Responsibilities
- Lead the design, development, and optimization of Snowflake-based data solutions for enterprise clients
- Work closely with the client's internal architect and delivery teams to shape scalable, secure, and high-performing data architecture
- Confidently challenge technical decisions when needed, bringing a strong point of view grounded in Snowflake best practices and modern data architecture principles
- Assess current-state data platforms, pipelines, and patterns, then identify opportunities for improvement, simplification, modernization, and optimization
- Design and implement robust batch and near real-time data pipelines to support analytics, reporting, and advanced data use cases
- Develop and optimize data transformation layers using SQL, Python, dbt, and related modern data engineering practices
- Drive Snowflake platform excellence across performance tuning, workload optimization, cost efficiency, data modeling, security and governance, and orchestration and automation
- Proactively introduce and evaluate relevant Snowflake capabilities such as Snowpark, Streams and Tasks, Dynamic Tables, data sharing, and other platform enhancements
- Contribute to platform strategy discussions, including articulating the strengths and tradeoffs of Snowflake versus other modern data platforms
- Partner with engineers, analysts, architects, and business stakeholders to deliver production-ready solutions in a fast-paced consulting environment
- Support pre-sales, discovery, and technical advisory conversations when needed
Requirements
- Bachelor's degree in Computer Science, Engineering, Information Technology, or equivalent practical experience
- 7+ years of experience in data engineering, cloud data, or modern data platform roles
- Strong hands-on experience with Snowflake development and architecture
- Snowflake certification: SnowPro Core or any SnowPro Advanced certification
- Strong command of advanced SQL and solid experience with Python for transformation, automation, and pipeline development
- Proven experience designing and delivering end-to-end production data solutions
- Strong understanding of data warehouse, lakehouse, and modern cloud data architecture patterns
- Experience working directly with client stakeholders, architects, and technical leads
- Ability to operate with confidence and credibility in front of client teams, including the ability to push back constructively and influence architecture direction
- Experience with dbt or similar transformation and testing frameworks
- Experience with ingestion and integration patterns using APIs, file-based ingestion, ELT platforms such as Fivetran or equivalent, and cloud-native services
- Strong communication skills with the ability to explain technical concepts clearly to both technical and non-technical audiences
- Experience working in Agile / Scrum delivery environments
Benefits
- A strong culture of innovation and entrepreneurship
- Occasions to celebrate your success: 5 @ 7, team activities, birthdays, breakfasts and other special events
- Group insurance for you and your family members
- RRSP and DPSP participation plan
- Monthly Wellness Allowance
- Reimbursement of telecommunication costs
- 4 weeks of paid vacation
- Language courses (French & English)
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Data Engineer II developing ETL/ELT solutions for higher education data warehouse. Ensuring reliable institutional data for strategic decision - making by university leaders.
Associate Data Engineer building and maintaining data systems at Incedo. Transforming raw information into accessible datasets for decision - making and collaborating with analysts and data scientists.
Intern Data Engineer at Flutter Studios learning to create applications in the gaming industry. Join a cross - functional team to implement a basic application in an Agile environment.
AI/Data Engineer at Comcast developing data pipelines and AI solutions for audit processes. Leading team efforts to ensure data quality and compliance with audit objectives across business units.
Senior Data Engineer involved in AWS Cloud and Big Data solutions for Financial Crime. Join CommBank's team to tackle complex data - centric problems with advanced technologies.
Senior Data Engineer leading and mentoring a team in building scalable data pipelines for digital transformation projects in an international software company.
Senior Data Operations Engineer at iKnowHow designing and implementing scalable data - driven applications. Focus on data pipelines, APIs, and collaboration across teams for project success.
Data/AI Engineer supporting innovations in corporate travel with AWS technologies at HRS Group. Collaborating with data teams to develop AI solutions and maintain data pipelines.
AS
Data Engineer developing data solutions for reporting and analytics at Assurant. Implementing and optimizing Data Warehouse solutions in cloud and on - premise environments with Agile methodology.