Senior Data Engineering Analyst Job at Publicis Groupe Holdings B.V in New York

Company description Hi there! We're Razorfish. We've been leading the marketing industry with our digital expertise since the start of the internet. But in 2020, we did a full reboot. What's different? It all starts with people. Weird, wonderful, complex people - with diverse backgrounds in strategy, creative and technology. But no matter how different we are, we all have one thing in common. We believe our differences are our strength. So we push for inclusion, challenge convention and bring in new perspectives, to inspire new ideas. Because when we connect by understanding what makes people different, we can create unforgettable experiences that enrich lives. Join . Overview Sr. Data Engineering Analyst will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The Sr. Data Engineering Analyst is gaining experience by building data pipeline and standardized processes. They enjoy optimizing data systems and building them from the ground up. The Sr. Associate Data Engineer will support data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. Responsibilities

• Deliver quality work on defined tasks with infrequent oversight and on undefined tasks with frequent oversight from senior level data engineer.
• Implementing and maintaining relational and columnare databases like BigQuery, Redshift, and Azure. Responsibilities could include database clustering, partitioning, etc.
• Implementation of tables, indexes, stored procedures, functions, or ad-hoc query support.
• Implementation of other data related activities such as standardized automated ETL processes, reports, dashboards, models, etc.
• Provide status updates to team members on a regular basis and clearly escalate issues and risks to project management as needed.
• Serve as technical resource during software development life cycle to solve business issues through the process of identifying and analyzing detailed requirements that translate into system designs.
• Ability to estimate own work when provided with sufficient task definition.
• Focus daily on best practices to ensure a quality deliverable.
• Troubleshoot, diagnose and quickly respond to database and application issues minimizing disruption to services and escalate to third parties vendors for support as needed.
• Proactively monitor and report on database performance and capacity and provide trend analysis for all environments

Key Differentiators

• Understands Razorfish data capabilities and how data fits into a client's overall strategy
• Understands the breadth of data services and crafts
• Able to manage data team responsibilities within cross-capability projects
• Understanding of SQL
• Understanding of Python coding best practices.
• Architect Data Structures
• Understand Cloud Platforms (AWS, GCP, Azure)
• Mentor Associate Data Engineers

Qualifications

• BS in Computer Science or equivalent education/professional experience is required
• Experienced database administrator/developer role, preferably in a professional services environment.
• Experience working with or general knowledge of RDBMS (DB2, Oracle, MySQL, SQL Server, etc).
• Experience working with or general knowledge of Big Data or NoSQL database system (DynamoDB, MongoDB, Redshift, BigQuery, Azureetc) a plus.
• Understanding of cloud infrastructure services like Amazon Web Services and Google Cloud Platform a plus.
• Experience working with data modeling and normalization concepts.
• Experience or Knowledge of different query languages (i.e. PL-SQL, T-SQL).
• Knowledge and experience with ETL toolsets (i.e. SSIS, Talend, etc.)
• Knowledge and experience writing ETL processes.
• Understanding of application programming and interactions with database technologies.
• Ability to estimate level of effort for tasks.
• Ability to learn new languages, tools, and techniques as needed to meet project requirements.
• Ability to work collaboratively in teams with other individuals. Able to work in a fast-paced, technical environment.
• Good verbal and written communication skills.
• Attention to detail and quality.
• Excellent problem solving skills

Additional information The Power of One starts with our people! To do powerful things, we offer powerful resources. Our best-in-class wellness and benefits offerings include:

• Paid Family Care for parents and caregivers for 12 weeks or more
• Monetary assistance and support for Adoption, Surrogacy and Fertility
• Monetary assistance and support for pet adoption
• Employee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balance
• Tuition Assistance
• Paid time off that includes Flexible Time off Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and more
• Matching Gifts programs
• Flexible working arrangements
• 'Work Your World' Program encouraging employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based upon eligibility)
• Business Resource Groups that support multiple affinities and alliances

The benefits offerings listed are available to eligible U.S. Based employees, are reviewed on an annual basis, and are governed by the terms of the applicable plan documents. Razorfish is an Equal Opportunity Employer. Our employment decisions are made without regard to actual or perceived race, color, ethnicity, religion, creed, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, childbirth and related medical conditions, national origin, ancestry, citizenship status, age, disability, medical condition as defined by applicable state law, genetic information, marital status, military service and veteran status, or any other characteristic protected by applicable federal, state or local laws and ordinances. If you require accommodation or assistance with the application or onboarding process specifically, please contact . All your information will be kept confidential according to EEO guidelines. Compensation Range: $73.150 - $96,200 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be.