Senior Associate Data Engineer (Public Sector)

$108,000 - $135,000/Yr

Publicis Groupe - Arlington, VA

Full-time - Mid Level

Arlington, VA

10,001+ employees

Professional, Scientific, and Technical Services

About the position

Publicis Sapient's Public Sector team is seeking an experienced Senior Associate Data Engineer with over 7 years of experience in Python, Snowflake, and ELT tools. The ideal candidate will be a detail-oriented team player responsible for creating innovative data solutions that drive business success. This role involves the development, testing, and maintenance of data engineering frameworks and large-scale data processing systems. The Senior Associate Data Engineer will work closely with IT architects, data analysts, and business stakeholders to design and implement data solutions that meet business requirements and goals. Additionally, the candidate will collaborate with stakeholders to identify opportunities for data-driven improvements and develop standards, procedures, and guidelines to ensure data integrity and regulatory compliance. The position requires anticipating future demands related to data initiatives and making recommendations to upper management regarding necessary upgrades or new systems.

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.

Requirements

• A minimum of 7 years of experience in a Data Engineer role.
• Proficiency in Python for legacy and modern ingestion using libraries for data engineering like Pandas, SQLalchemy, and Snowpark.
• At least one project experience in deploying data ingestion framework using Python.
• 1-2 years of working experience with Snowflake and its features like snowpipe, snowpark, tasks, procedures, etc.
• Hands-on experience with ETL tools and processes (SSIS, Informatica, etc).
• Proficiency in SQL 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.
• Familiarity with version control systems like Git for managing and collaborating.
• Familiarity with at least one public cloud platform (AWS, Azure, or Google Cloud Platform) and understanding how Snowflake integrates with these platforms.
• Exceptional analytical and problem-solving skills.
• Strong communication and collaboration skills.
• A degree in Computer Science, Engineering, or a related field.

Nice-to-haves

• Cloud certifications
• Proficiency in Azure Cloud services like Azure Data Factory and DevOps is advantageous.

Benefits

• Flexible vacation policy
• Unlimited PTO's
• Bonus Plan
• 15 company paid holidays annually
• Work Your World program
• Generous parental leave and new parent transition program
• Tuition reimbursement
• 401 (k)