AWS Data Architect (FS experience)

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 around the world 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.

Great Place to Work® Certified in the US: https://www.greatplacetowork.com/certified-company/1000228

Job Description

Publicis Sapient is looking for a Data Architect to join our team of bright thinkers and
doers. You will team with top-notch technologists to enable real business outcomes for
our enterprise clients by translating their needs into transformative solutions that provide
valuable insight. Working with the latest data technologies in the industry, you will be
instrumental in helping the world’s most established brands evolve for a more digital
future.

Your Impact:

• Play a key role in delivering data-driven interactive experiences to our clients
• Work closely with our clients to understand their needs and translating them to technology solutions
• Provide expertise as a technical resource to solve complex business issues that translates into data integration and database systems designs
• Problem-solving to resolve issues and remove barriers throughout the lifecycle of client engagements
• Ensuring all deliverables are high quality by setting development standards, adhering to the standards and participating in code reviews
• Participate in integrated validation and analysis sessions of components and subsystems on production servers
• Collaborate with stakeholders to understand their reporting requirements and translate them into actionable BI solutions.
• Design and develop scalable and efficient BI solutions using PowerBI and Snowflake database.
• Design optimal data models for effective data analysis and reporting within PowerBI
• Identify and implement best practices for data visualization, dashboard design, and report development.
• Perform data profiling and analysis to identify data quality issues and provide recommendations for improvement.
• Monitor and troubleshoot performance issues in PowerBI reports and take necessary actions to enhance performance.
• Implement data governance and security practices in a Power BI environment.
• Mentor, support, and manage team members

Qualifications

Primary Skill: PowerBI, Snowflake, SQL

Must-Haves:

• ***Application open to ONLY U.S. Citizens and GCs***
• Prefers Financial Services industry experience
• 9 years of demonstrable experience in enterprise-level data platforms involving the implementation of end-to-end data pipelines
• Hands-on exp with at least one of the leading public cloud data platforms (Amazon Web Services, Azure, or Google Cloud)
• Exp with column-oriented database technologies (Big Query, Redshift, Vertica), NoSQL database technologies (DynamoDB, BigTable, CosmosDB, Cassandra, DocumentDB, HBase, etc.), and traditional database systems (i.e. SQL Server, Oracle, MySQL)
• Exp in designing and implementing reporting frameworks for organizations, ideally to enable a self-servicing model
• Ability to handle multiple responsibilities simultaneously in leadership and contributing to tasks “hands-on”
• Understanding of data modeling, warehouse design, and fact/dimension concepts.

Nice to have:

• Exposure to a wide range of reporting and visualization tools, Python, DBT
• Certifications for any of the cloud services like AWS, GCP, or Azure
• Experience working with code repositories and continuous integration
• Understanding of development and project methodologies
• Willingness to travel

Additional Information

Annual Pay Range: 123,000 - 165,000 USD

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.

Benefits of Working Here:

• Flexible vacation policy
• Unlimited PTO's
• 15 company paid holidays annually
• Work Your World program
• Generous parental leave and new parent transition program
• Tuition reimbursement
• Corporate gift matching program

All your information will be kept confidential according to EEO guidelines.