Senior Data Engineer (Snowflake)

Overview

Hybrid
Depends on Experience
Contract - W2

Skills

Data Warehouse
Business Analytics
Communication
Data Engineering
Data Modeling
Data Quality
Amazon Redshift
Analytical Skill
Performance Tuning
Programming Languages
Dimensional Modeling
Extract
Transform
Load
Orchestration
Presentations
Analytics
Apache Kafka
Apache NiFi
Database
Relational Databases
Databricks
Normalization
PySpark
Python
Systems Design
Agile
Reasoning
Recruiting
Reporting
SQL
Scrum
Snow Flake Schema

Job Details

Software Resources has an immediate, job opportunity for a Senior Data Engineer with a major corporation in Santa Monica, CA.
This team focuses on analytics and business stakeholders, building a data warehouse for their needs.
Duration: 12+ month(s)
Pay Rate: $85 - $90/hr DOE

The required tech stack includes Snowflake and Databricks (preference for Snowflake), Airflow experience, and Kafka (especially valued by Brent). These requirements are consistent with previous hiring rounds for similar roles.
Description:
Subscriber Data Solutions builds and maintains best in class data products enabling business teams to analyze and measure subscriber movements and support revenue generation initiatives.

The Senior Data Engineer will contribute to the Company's success by partnering with business, analytics and infrastructure teams to design and build data pipelines to facilitate measuring subscriber movements and metrics. Collaborating across disciplines, they will identify internal/external data sources, design table structure, define ETL strategy & automated Data Quality checks.
Responsibilities:
Partner with technical and non-technical colleagues to understand data and reporting requirements.
Work with engineering teams to collect required data from internal and external systems.
Design table structures and define ETL pipelines to build performant Data solutions that are reliable and scalable in a fast growing data ecosystem.
Develop Data Quality checks
Develop and maintain ETL routines using ETL and orchestration tools such as Airflow
Implement database deployments using tools like Schema Change
Perform ad hoc analysis as necessary.
Perform SQL and ETL tuning as necessary.
Basic Qualifications:
5+ years of relevant data engineering experience.
Strong understanding of data modeling principles including Dimensional modeling, data normalization principles.
Good understanding of SQL Engines and able to conduct advanced performance tuning.
Ability to think strategically, analyze and interpret market and consumer information.
Strong communication skills written and verbal presentations.
Excellent conceptual and analytical reasoning competencies.
Comfortable working in a fast-paced and highly collaborative environment.
Familiarity with Agile Scrum principles and ceremonies
Preferred Qualifications:
2+ years of work experience implementing and reporting on business key performance indicators in data warehousing environments, required.
2+ years of experience using analytic SQL, working with traditional relational databases and/or distributed systems (Snowflake or Redshift), required.
1+ years of experience programming languages (e.g. Python, Pyspark), preferred.
1+ years of experience with data orchestration/ETL tools (Airflow, Nifi), preferred.
Experience with Snowflake, Databricks/EMR/Spark, and/or Airflow.
Required Education:
Bachelor's Degree + 5 years of relevant experience

About Software Resources
Software Resources, founded more than 3 decades ago, is a trusted staffing partner specializing in Technology (IT, Creative, & Marketing), Finance, & Accounting placements. We work with companies nationwide that need skilled professionals and connect them with candidates like you looking for the right opportunity.
We are always looking for professionals at all experience levels and in various specialties to meet our clients' hiring needs. As a member of our team, you will have access to benefits including medical, dental, and vision coverage, a 401(k) with company match, short-term disability, life insurance with AD&D.
If this position fits interests you, we encourage you to apply.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.