Senior Data Engineering Analyst

Company Description

Hello! We are Razorfish. We have been at the forefront of the marketing industry with our digital knowledge since the inception of the internet. However, in 2020, we underwent a complete overhaul. What's differed? Everything revolves around people. Unusual, wonderful, complex individuals - with diverse backgrounds in strategy, creativity, and technology. No matter how dissimilar we are, we all possess one mutual trait. We presume that our differences are our power. For this reason, we advocate inclusivity, defy traditions, and welcome fresh points of views to instigate fresh ideas. Because when we connect through understanding what makes people different, we can create unforgettable experiences that enrich lives. Join us at razorfish.com.

Job Description

A Senior Data Engineer will be responsible for the expansion and optimization of our data and data pipeline architecture, as well as optimizing data stream and collection across various functional teams. The Senior Associate of Data Engineering is gaining experience by constructing data pipeline and standardized procedures. They take pleasure in optimizing data systems and creating them from scratch. The Senior Associate Data Engineer will guide data analysts and data scientists on data projects and will ascertain optimal data delivery architecture is consistently maintained throughout continuing projects. They must be self-motivated and confidently meet the data requirements of various teams, systems, and products.

Tasks include:

• Delivering high-quality work on assigned duties with infrequent oversight and on undefined tasks with frequent guidance from senior level data engineers.
• Implementing and sustaining relational and columnar databases like BigQuery, Redshift, and Azure. Responsibilities could include database clustering, partitioning, etc.
• Implementation of tables, indexes, stored procedures, functions, or on-demand query support.
• Handling of other data-related activities such as standardized automated ETL processes, reports, dashboards, models, etc.
• Regularly providing updates to team members and promptly escalating issues and risks to project management as necessary.
• Serving as technical resource during software development life cycle to resolve business problems through identifying and analyzing detail requirements translated into system designs.
• Ability to estimate own work based on sufficient task definition.
• Daily focus on best practices to ensure delivery of quality work.
• Quickly diagnosing and resolving database and application issues to minimize service disruption and escalating to third-party vendors for support if necessary.
• Regularly monitoring and reporting on database performance and capacity and providing trend analysis for all environments.

Qualifications

• BS in Computer Science or equivalent education or work experience is required.
• Experience as a database administrator/developer is preferred, especially in a professional services environment.
• Working experience or general knowledge of RDBMS (DB2, Oracle, MySQL, SQL Server, etc.)
• Working experience or general knowledge of Big Data or NoSQL database system (DynamoDB, MongoDB, Redshift, BigQuery, Azure, etc) is a plus.
• Understanding of cloud infrastructure services like Amazon Web Services and Google Cloud Platform is a plus.
• Experience in 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 in writing ETL processes.
• Understanding of application programming and interactions with database technologies.
• Ability to estimate the level of effort for tasks.
• Ability to learn new languages, tools, and techniques as per project requirements.
• Ability to work collaboratively within teams.
• HSuitable for working in a fast-paced, technical environment.
• Has good verbal and written communication skills.
• Attention to detail and quality of work.
• Excellent problem-solving abilities.

Additional Information

The Power of One commences with our people! To do powerful things, we offer powerful resources. Our premier wellness and benefits include:

• 12-weeks or more of Paid Family Care for parents and caregivers .
• Monetary assistance and support for Adoption, Surrogacy, and Fertility.
• Financial assistance and support for pet adoption.
• Employee Assistance Programs and Health/Wellness/Comfort reimbursements to help 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 others.
• Matching Gifts programs.
• Flexible working arrangements.
• 'Work Your World' Program encouraging employees to work from any office of Publicis Groupe for up to 6 weeks a year (subject to eligibility).
• Business Resource Groups that support multiple affinities and alliances.

All benefits listed are available to eligible U.S. employees, reviewed annually, and governed by the terms of the applicable plan documents. Razorfish is an Equal Opportunity Employer. Our employment decisions do not consider 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 state law, genetic information, marital status, military service and veteran status, or other characteristic protected by federal, state, or local laws and ordinances. Your information will remain confidential according to EEO guidelines. The expected compensation range for this position is $70,000 - $110,000. The final compensation will be determined based on the skills, qualifications, and experience of the applicant along with the job requirements and it's subject to change. For this role, the company will offer medical coverage, dental, vision, disability, 401k, and paid time off.