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 us at razorfish.com.
Overview
This is a senior data engineer within our North American team. The data engineer will collaborate within a team of technologists to produce enterprise scale solutions for our clients' needs. This position will be focused on building out a customer data hubs/profile databases and building data warehouse solutions.
Responsibilities
Deliver quality work on defined tasks with little oversight and direction.
Ensure all deliverables are of high quality throughout the project by adhering to coding standards and best practices and participating in code reviews.
Participate in integrated test sessions of components and subsystems on test and production servers.
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 data integration and database system designs.
Solve business issues through the process of identifying and analyzing detailed requirements that translate business requirements into technical system designs.
Use information gained through prior experience, knowledge sharing with other Technology Associates, education and training to resolve issues and remove project barriers
Provide status updates to team members on a regular basis and clearly escalate issues and risks to project management as needed.
Qualifications
Responsible for the maintenance, improvement, cleaning, and manipulation of data in the business's operational and analytics databases. Works with the business's data analytics teams, data scientists, and software engineers in order to understand and aid in the implementation of database requirements, analyze performance, and troubleshoot any issues. Defines and builds the data pipelines that will enable faster, better, data-informed decision-making within the business.
BS in Computer Science or equivalent education/professional experience is required.
5+ years in a data engineering role with demonstrable experience with data integration and data warehouse projects.
Experience designing and building data warehouses, customer profile databases, data marts, etc.
Experience with data modeling, warehouse design, and fact/dimension concepts.
Experience working with different query languages (i.e. T-SQL, PostgreSQL, PL-SQL).
Prefer some experience in at least one programming language (i.e. Python, Java, Scala, C#, etc.).
Prefer some experience in data integration projects and automation via ETL Tools (i.e. Talend, Informatica, SSIS, etc.)
Experience in Amazon Redshift is a plus.
Experience with marketing data (Google Double-Click, Site Analytics, Paid Search, etc.) is also a plus.
Understanding and experience working with cloud platform services: Redshift, Aurora, Data Factory, SQL DW, Azure Datawarehouse, Data Lake, BigQuery, etc.
Experience working with code repositories and continuous integration (i.e. Git, Jenkins, etc.)
Understanding of development and project methodologies.
Ability to work collaboratively in teams with other specialized individuals.
Able to work in a fast-paced, technical environment.
Good verbal and written communication 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 USMSTACompliance@publicis.com.
All your information will be kept confidential according to EEO guidelines.
Compensation Range: $87,210 to $119,300. 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 9/1/25.
