Senior Data Engineer AWS

Company Description

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.

Job Description

Data Lead role is responsible for architecting, designing, developing and maintaining data architecture across the Agile Release Train(ART), while ensuring high levels of data integrity and availability. The ideal candidate will be responsible for understanding the business requirements and implementing data solutions to facilitate Engineering Tool Suite

Qualifications

Job Responsibilities

• Runway development, gap analysis, data migration and integration strategy
• Design, develop, implement and maintain data models, which include the use of relational, dimensional and NoSQL databases.
• Manage complete lifecycle of Database, Business Intelligence and Data Analytics projects from inception to phased operationalization.
• Large database migrations from on-prem to AWS cloud adhering to complex government standards.
• Work with government business sponsors to understand intent and clarify business/technical requirements and impacts across train.
• Map systems and interfaces used to manage data, set standards for data management.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Monitor system performance by performing regular tests, troubleshooting, and integrating new features and estimate cost projections.
• Recommend solutions to improve new and existing database systems.
• Educate team members through training and individual support.

Requirements

Desired Skills & Qualifications

• Over 5+ years of experience in leading and implementing data solutions.
• Experience with data architecture, data modeling, database design, and data warehousing.
• Extensive hands-on experience with MS SQL Server, Oracle, MySQL and NoSQL databases
• Excellent communication and documentation skills to articulate complex database concepts.
• Advanced knowledge of data modeling techniques and database design for both transactional and analytical systems.
• Proven experience in managing large-scale databases and handling data migration projects.
• Proficiency in advanced SQL concepts and development of complex SQL queries, stored procedures, triggers and packages
• Strong background in developing, testing, and maintaining data applications, including ETL processes, data pipelines, and APIs.
• Hands-on experience with AWS cloud services.
• Knowledge of database administration tasks, including backup, recovery, performance tuning, and monitoring.
• Knowledge of data visualization tools (e.g., Tableau, MS Power BI).
• Experience with version control systems like Git. Ability to work collaboratively in an Agile, scrum-based team environment.
• Good to have experience in data engineering concepts using python

Additional Information

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