Senior Associate Data Engineer- Snowflake SME

Publicis Sapient is a digital transformation partner helping established organizations get to their future, digitally-enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting and customer obsession to accelerate our clients’ businesses through designing the products and services their customers truly value.

We are seeking an experienced Data Engineer with 7+ years of experience in Python, Snowflake, and ELT tools. This role is responsible for the development, testing, and maintenance of data engineering frameworks and large-scale data processing systems. The ideal candidate is a detail-oriented team player who will be the first line in creating innovative data solutions for our business.

Key Responsibilities:

• Design, construct, install, test, and maintain highly scalable data management systems.
• Work closely with IT architects, data analysts, and business stakeholders to design and implement data solutions that meet business requirements and goals.
• Collaborate with business stakeholders to identify opportunities for data-driven improvements.
• Develop and implement data standards, procedures, and guidelines to ensure data integrity, dependability, and regulatory compliance.
• Develop and implement complex database queries, stored procedures, and scripts.
• Anticipate future demands of initiatives related to data, and make recommendations to upper management on necessary upgrades or new systems.

Required Skills & Qualifications:

• A minimum of 7 years of experience in a Data Engineer role.
• Proficiency in Python is one of the fundamental requirements. This includes a deep understanding of Python syntax, data structures, control flow, and error handling mechanisms.
• At least one project experience of deploying data ingestion framework using python.
• Extensive experience with Snowflake and its features like snowpipe, snowpark, tasks, procedures, eetc.
• Hands-on experience with ELT (Extract, Load, Transform) tools and processes.
• Proficiency in SQL is essential, including the ability to write complex queries and stored procedures.
• Experience working with legacy and modern sources and file formats like json, csv, xml. and classified data with PII, PHI etc.
• Proficiency in python for legacy and modern ingestion is essential and experience in usage of libraries for data engineering like pandas, sqlalchemy, snowpark, etc. is required
• Familiarity with version control systems like Git for managing and collaborating.
• Familiarity with at least one cloud platform, such as AWS, Azure, or Google Cloud, and understanding how Snowflake integrates with these platforms. Proficiency in Azure Cloud services like Azure data factory, DevOps are advantageous.
• Exceptional analytical and problem-solving skills.
• Strong communication and collaboration skills.
• A degree in Computer Science, Engineering, or a related field.

Pay Range: $108,000 - $140,000

The range shown represents a grouping of relevant ranges currently in use at Publicis Sapient. Actual range for this position may differ, depending on location and specific skillset required for the work itself.

Benefits of Working Here:

• Flexible vacation policy; time is not limited, allocated, or accrued
• 16 paid holidays throughout the year
• Generous parental leave and new parent transition program
• Tuition reimbursement 
• Corporate gift matching program 

As part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at [email protected] or you may call us at +1-617-621-0200.