Associate Data Engineer (Public Sector)

We are seeking an experienced Data Engineer with 3+ 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:

• Develop and implement complex database queries, stored procedures, and scripts.
• Develop, test, and maintain data ingestion and transformation pipelines.
• Work closely with 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.

Required Skills & Qualifications:

1. A minimum of 3 years of experience in a Data Engineer role.
2. 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.
3. At least one project experience of deploying data ingestion framework using python.
4. Extensive experience with Snowflake and its features like snowpipe, snowpark, tasks, procedures, eetc.
5. Hands-on experience with ELT (Extract, Load, Transform) tools and processes.
6. Proficiency in SQL is essential, including the ability to write complex queries and stored procedures.
7. Experience working with legacy and modern sources and file formats like json, csv, xml. and classified data with PII, PHI etc.
8. 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
9. Familiarity with version control systems like Git for managing and collaborating.
10. 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.
11. Exceptional analytical and problem-solving skills.
12. Strong communication and collaboration skills.
13. A degree in Computer Science, Engineering, or a related field.

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 hiring@publicis.sapient.com or you may call us at +1-617-621-0200.

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.