Azure - Senior Data Engineering Architect

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. As digital pioneers with 20,000 people and 53 offices around the globe, our experience spanning technology, data sciences, consulting and customer obsession – combined with our culture of curiosity and relentlessness – enables us to accelerate our clients’ businesses through designing the products and services their customers truly value. Publicis Sapient is the digital business transformation hub of Publicis Groupe. For more information, visit publicissapient.com.

Job Description

Publicis Sapient is looking for a hands-on Senior Manager to join our team of bright thinkers and doers. You’ll use your problem-solving creativity to design, architect, and develop high-end technology solutions that solve our clients’ most complex and challenging problems across different industries. We are on a mission to transform the world, and you will be instrumental in shaping how we do it with your ideas, thoughts, and solutions.

Your impact:

• Develop, design, and implement consumer data models based on business requirements and objectives.
• Collaborate with various stakeholders, such as business analysts, architects, and developers, to understand data needs and convert these needs into effective data models.
• Evaluate and optimize existing data models for improvement.
• Ensure that data models adhere to industry best practices, standards, and guidelines.
• Conduct data profiling and analysis to identify data quality issues and propose data cleansing and remediation strategies.
• Collaborate with database administrators to optimize database performance and maintain data integrity.
• Work closely with ETL developers to integrate data models into data integration processes.
• Stay updated on the latest trends and technologies in data modeling, cloud computing, and database design.
• Mentor, support and manage team members

Qualifications

Your Skills and Experience:

• Demonstrable experience in enterprise level data platforms involving implementation of end-to-end data pipelines 
• Hands-on experience with at least one of the leading public cloud data platforms (Amazon Web Services, Azure or Google Cloud)  
• Experience with column-oriented database technologies (e.g., Big Query, Redshift, Vertica), NoSQL database technologies (e.g., DynamoDB, BigTable, Cosmos DB, etc.) and traditional database systems (e.g., SQL Server, Oracle, MySQL)
• Experience in architecting data pipelines and solutions for both streaming and batch integrations using tools/frameworks like Glue ETL, Lambda, Google Cloud DataFlow, Azure Data Factory, Spark, Spark Streaming, etc. 
• Metadata definition and management via data catalogs, service catalogs, and stewardship tools such as OpenMetadata, DataHub, Alation, AWS Glue Catalog, Google Data Catalog.
• Test plan creation and test programming using automated testing frameworks, data validation and quality frameworks, and data lineage frameworks
• Data modeling, querying, and optimization for relational, NoSQL, timeseries, graph databases, data warehouses and data lakes
• Data processing programming using SQL, DBT, Python, and similar tools
• Logical programming in Python, Spark, PySpark, Java, Javascript, and/or Scala
• Cloud-native data platform design with a focus on streaming and event-driven architectures
• Participate in integrated validation and analysis sessions of components and subsystems on production servers
• Data ingest, validation, and enrichment pipeline design and implementation
• SDLC optimization across workstreams within a solution
• Bachelor’s degree in Computer Science, Engineering, or related field

Additional Information

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

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