Data Engineer (SQL, Python, ETL, Cloud)

Data Engineer

Employment Type: Full-Time / Direct-Hire

Workplace Type: Hybrid

Location: Santa Monica (CA), McAllen (TX), El Paso (TX), Denver (CO)

Industry: Advertising Services/Ad Tech

Compensation: $90,000 - $110,000

SUMMARY:

We are seeking a highly skilled and motivated Data Engineer to join our dynamic data team. The ideal candidate will have deep expertise in SQL, cloud platforms, data modeling, and building production-ready ETL pipelines. This role will be essential in designing and maintaining scalable data infrastructure, ensuring seamless data integration, and optimizing end-to-end data workflows. As a key player in shaping our data architecture, you will contribute to building robust, cloud-based solutions that support data analytics and business intelligence initiatives across the organization.

RESPONSIBILITIES:

• Develop, test, and deploy ETL pipelines to move and transform data across multiple data sources.


• Build integrations with third-party tools, APIs, and services, ensuring data is synchronized and accessible.


• Manage and optimize data storage, particularly in cloud-based OLAP databases (e.g., Snowflake, Redshift).


• Work with cross-functional teams including data scientists, business analysts, and product teams to understand data needs and ensure effective solutions.


• Monitor and tune data processes and queries for optimal performance and efficiency.


• Help design, deploy, and maintain cloud infrastructure and storage


• Maintain clear and comprehensive technical documentation of data pipelines, workflows, and infrastructure.


• Knowledge of containerization technologies like Docker and Kubernetes and experience with deploying data pipelines in containerized environments

REQUIREMENTS:

• Bachelor's degree in Mathematics, Statistics, Economics, Computer Science, Engineering, or a related quantitative discipline


• Strong skills with data manipulation/modeling and creating complex SQL query scripts.


• Hands-on experience with cloud-based data warehouses such as Snowflake or Redshift.


• Familiarity with ETL tools such as Fivetran, Stitch, Rivery, or Airbyte.


• Experience working with AWS cloud services including S3, AWS Batch, ECR, Lambda, SNS, SQS, and other managed cloud platforms.


• Experience writing production-ready, testable code in languages like Python, Scala, or Java.


• Familiarity with project management and documentation tools like JIRA Software, JIRA Service Management and Confluence.


• Experience with data transformation tools such as DBT (Data Build Tool).


• Advanced experience with API integrations and automating data ingestion.


• Experience with data orchestration tools like Apache Airflow or Luigi for scheduling and managing workflows.


• Experience with data modeling techniques such as Kimball, Inmon, or Data Vault.


• Experience with CI/CD pipelines, deployment, and automation using Git and other DevOps tools.


• Strong problem-solving skills and the ability to work independently and as part of a team.


• Excellent communication skills with the ability to explain complex technical concepts to non-technical stakeholders.

DESRIED SKILLS:

• Understanding of data governance practices and tools for managing data quality, lineage, and security.


• Experience with large-scale data processing frameworks such as Spark or Hadoop.


• Knowledge of data streaming tools and best practices using Kafka, Kinesis, or similar technologies.


• Experience with NoSQL technologies like MongoDB, Cassandra, or Elasticsearch.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.

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.