Senior Associate Data Engineer L2 (Public Sector)
Arlington, VA, United States
Full Time Mid-level / Intermediate USD 108K - 135K
Publicis Groupe
Company Description
As a Digital Business Transformation partner of choice at Publicis Sapient, we’ve spent nearly three decades utilizing the disruptive power of technology and ingenuity to help digitally enable our client's businesses in their pursuit of the next. Our 20,000+ people in 53 offices worldwide combine experience across technology, data sciences, consulting, and customer obsession to accelerate our clients’ businesses by designing the products and services their customers truly value. In the space between next and now is how. And we believe that how you seize that space is everything. We've been named a LEADER in Gen AI
Great Place to Work® Certified in the US
Job Description
Publicis Sapient- Public Sector is seeking an experienced Senior Associate Data Engineer with 7+ years of experience in Python, Snowflake, and ELT tools. The ideal candidate is a detail-oriented team player who will be the first line in creating innovative data solutions for our business. You will be responsible for the development, testing, and maintenance of data engineering frameworks and large-scale data processing systems.
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.
Qualifications
Primary Skill required: Python, SQL, ETL, Any Cloud, Snowflake
Must-Haves:
- Application open to ONLY U.S. Citizens and Permanent Residents (GC) **No sponsorship available**
- Must be eligible to obtain U.S. Government Clearance (Public Trust)
- Applicants must be residing in the U.S. and be legally authorized to work.
- Local to the Washington DC metro area, Maryland, and Virginia.
Required Skills & Qualifications:
- A minimum of 7 years of experience in a Data Engineer role.
- Proficiency in Python for legacy and modern ingestion in using libraries for data engineering like Pandas, SQLalchemy, and Snowpark, is required. Good understanding of Python syntax, data structures, control flow, and error-handling mechanisms.
- At least one project experience in deploying data ingestion framework using Python.
- 1-2 years of working exp with Snowflake and its features like snowpipe, snowpark, tasks, procedures, etc.
- Hands-on exp with ETL tools and processes (SSIS, Informatica, etc).
- Proficiency in SQL to write complex queries and stored procedures.
- Exp 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 GCP, 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 Have:
- Cloud certifications
- Proficiency in Azure Cloud services like Azure Data Factory and DevOps is advantageous.
Additional Information
Additional information
Annual Pay Range (in USD): $108,000 - $135,000
The range shown represents a grouping of relevant ranges currently in use at Publicis Sapient. The actual range for this position may differ, depending on location and the specific skillset required for the work itself.
Benefits include:
- 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)
All your information will be kept confidential according to EEO guidelines.
#Hybrid
Tags: AWS Azure Computer Science Consulting CSV Data management DevOps ELT Engineering ETL GCP Generative AI Git Informatica JSON Pandas Python Snowflake SQL SSIS Testing XML
Perks/benefits: Flex hours Flex vacation Parental leave Salary bonus Unlimited paid time off
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Junior Data Analyst jobs
- Open Data Engineer II jobs
- Open Principal Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open BI Analyst jobs
- Open Business Intelligence Engineer jobs
- Open Sr. Data Scientist jobs
- Open Data Science Intern jobs
- Open Senior Business Intelligence Analyst jobs
- Open Software Engineer, Machine Learning jobs
- Open Lead Data Analyst jobs
- Open Azure Data Engineer jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Manager, Data Engineering jobs
- Open Marketing Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Engineering Manager jobs
- Open Data Analyst II jobs
- Open Product Data Analyst jobs
- Open Data management-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Excel-related jobs
- Open ML models-related jobs
- Open Data pipelines-related jobs
- Open APIs-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open LLMs-related jobs
- Open Data visualization-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Consulting-related jobs
- Open Business Intelligence-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Git-related jobs
- Open Docker-related jobs
- Open Hadoop-related jobs