Senior Data Engineer - 8+ Years Experience

• Posted 4 hours ago • Updated 4 hours ago
Full Time
Fitment

Dice Job Match Score™

🎯 Assessing qualifications...

Job Details

Skills

  • Stored Procedures
  • Orchestration
  • Data Validation
  • Change Data Capture
  • Data Security
  • Encryption
  • Collaboration
  • Workflow
  • Root Cause Analysis
  • Emerging Technologies
  • Artificial Intelligence
  • Python
  • SQL
  • Relational Databases
  • PostgreSQL
  • MySQL
  • Microsoft SQL Server
  • Oracle
  • NoSQL
  • MongoDB
  • Amazon DynamoDB
  • Apache Cassandra
  • Database Design
  • Query Optimization
  • Apache Spark
  • PySpark
  • Apache Hadoop
  • Distributed Computing
  • Parallel Computing
  • Performance Tuning
  • Apache Airflow
  • Informatica
  • Talend
  • Microsoft SSIS
  • Unstructured Data
  • Amazon Web Services
  • Amazon S3
  • Electronic Health Record (EHR)
  • Amazon Kinesis
  • Data Lake
  • Storage
  • Microsoft Azure
  • Google Cloud Platform
  • Google Cloud
  • Cloud Storage
  • Data Flow
  • Data Warehouse Architecture
  • Amazon Redshift
  • Slowly Changing Dimensions
  • SCD
  • Data Marts
  • Clustering
  • Data Modeling
  • Management
  • DevOps
  • Git
  • GitHub
  • GitLab
  • Bitbucket
  • Continuous Integration
  • Continuous Delivery
  • Docker
  • Kubernetes
  • Terraform
  • Automated Testing
  • Meta-data Management
  • Access Control
  • Privacy
  • Regulatory Compliance
  • HIPAA
  • Computer Science
  • Information Technology
  • Data Science
  • Big Data
  • Data Engineering
  • Agile
  • Scrum
  • Business Intelligence
  • Microsoft Power BI
  • Tableau
  • Machine Learning (ML)
  • Machine Learning Operations (ML Ops)
  • Databricks
  • Snow Flake Schema
  • Apache Kafka
  • Analytical Skill
  • Problem Solving
  • Conflict Resolution
  • Data Architecture
  • Communication
  • Stakeholder Management
  • Virtual Team
  • Accountability
  • FOCUS
  • Scalability
  • Data Processing
  • Streaming
  • Cloud Computing
  • Migration
  • Data Warehouse
  • Extract
  • Transform
  • Load
  • ELT
  • Data Quality
  • Optimization
  • API
  • Database
  • Real-time
  • Analytics
  • Data Governance
  • Production Support
  • Incident Management
  • IT Management
  • Mentorship

Summary

Job Summary

We are looking for an experienced Senior Data Engineer with 8+ years of hands-on experience in designing, developing, and maintaining scalable data platforms, data pipelines, and analytics solutions. The ideal candidate will have strong expertise in Python/SQL, ETL/ELT, cloud data platforms, data warehousing, distributed data processing, orchestration, and data architecture.

The candidate will work closely with Data Scientists, BI Developers, Software Engineers, Product Managers, and business stakeholders to build reliable, secure, high-performance data solutions that support business-critical analytics and AI/ML initiatives.

Key Responsibilities
  • Design, develop, and maintain scalable and reliable batch and real-time data pipelines.
  • Build robust ETL/ELT workflows to ingest, transform, validate, and distribute data from multiple sources.
  • Develop highly optimized and complex SQL queries, stored procedures, and data transformations.
  • Design and implement data warehouses, data lakes, lakehouses, and dimensional data models.
  • Work with large datasets using distributed processing technologies such as Apache Spark/PySpark.
  • Develop data pipelines using orchestration tools such as Apache Airflow, Azure Data Factory, AWS Glue, or similar platforms.
  • Implement data solutions on major cloud platforms such as AWS, Azure, or Google Cloud Platform.
  • Design and optimize cloud data platforms and services such as Amazon Redshift, Snowflake, Databricks, Azure Synapse, BigQuery, or equivalent technologies.
  • Implement data quality, data validation, reconciliation, monitoring, and observability frameworks.
  • Develop solutions for incremental data processing, CDC, slowly changing dimensions, partitioning, and performance optimization.
  • Build and maintain real-time/streaming data pipelines using technologies such as Kafka, Kinesis, or equivalent tools.
  • Implement appropriate data security, governance, access control, encryption, and compliance practices.
  • Collaborate with data architects to translate business requirements into scalable technical solutions.
  • Perform performance tuning of data pipelines, databases, Spark jobs, and cloud data workloads.
  • Establish and maintain CI/CD practices for data engineering workflows.
  • Write unit, integration, and data-quality tests to ensure reliability of production pipelines.
  • Troubleshoot production data issues and participate in incident resolution and root-cause analysis.
  • Conduct code reviews and promote engineering best practices across the data engineering team.
  • Mentor junior and mid-level data engineers and provide technical leadership.
  • Document data architecture, pipeline designs, data models, operational procedures, and technical decisions.
  • Stay current with emerging technologies in cloud, big data, data engineering, data platforms, and AI/ML.

Required Technical Skills

Programming & Database
  • Strong proficiency in Python.
  • Advanced SQL skills.
  • Experience with relational databases such as PostgreSQL, MySQL, SQL Server, or Oracle.
  • Experience with NoSQL databases such as MongoDB, DynamoDB, Cassandra, or similar is advantageous.
  • Strong understanding of database design, indexing, query optimization, and transaction management.

Big Data & Distributed Processing
  • Strong experience with Apache Spark / PySpark.
  • Experience with Hadoop ecosystem technologies is desirable.
  • Understanding of distributed computing, partitioning, parallel processing, and performance optimization.

Data Engineering & ETL
  • Extensive experience building ETL/ELT pipelines.
  • Experience with tools such as:
    • Apache Airflow
    • Azure Data Factory
    • AWS Glue
    • dbt
    • Informatica
    • Talend
    • SSIS
  • Experience handling structured, semi-structured, and unstructured data.

Cloud Technologies

Strong experience with at least one major cloud platform:

AWS
  • S3
  • Glue
  • EMR
  • Redshift
  • Lambda
  • Kinesis
  • Athena
  • IAM

Azure
  • Azure Data Factory
  • Azure Data Lake Storage
  • Azure Databricks
  • Azure Synapse Analytics
  • Azure Functions
  • Event Hubs
  • Key Vault

Google Cloud Platform
  • BigQuery
  • Cloud Storage
  • Dataflow
  • Dataproc
  • Pub/Sub
  • Cloud Composer

Data Warehousing & Lakehouse
  • Strong understanding of data warehouse architecture.
  • Experience with Snowflake, Databricks, Redshift, Synapse, BigQuery, or equivalent.
  • Expertise in:
    • Star and Snowflake schemas
    • Fact and dimension tables
    • Slowly Changing Dimensions (SCD)
    • Data marts
    • Data lakes
    • Lakehouse architecture
    • Partitioning and clustering
    • Data modeling

Streaming & Real-Time Data
  • Experience with Apache Kafka or equivalent streaming platforms.
  • Understanding of producers, consumers, topics, partitions, offsets, consumer groups, and schema management.
  • Experience developing real-time or near-real-time data processing pipelines.

DevOps & Engineering Practices
  • Experience with Git/GitHub/GitLab/Bitbucket.
  • Experience with CI/CD pipelines.
  • Knowledge of Docker and Kubernetes is desirable.
  • Experience with Infrastructure as Code tools such as Terraform is advantageous.
  • Familiarity with automated testing, deployment, monitoring, and observability.

Data Governance & Security
  • Understanding of data governance, metadata management, lineage, data cataloging, and data quality.
  • Experience implementing role-based access control and secure data access.
  • Knowledge of privacy and compliance requirements such as GDPR, CCPA, HIPAA, or equivalent regulations, depending on business requirements.

Preferred Qualifications
  • Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, Data Science, or a related field.
  • 8+ years of professional experience in Data Engineering, Big Data, or related disciplines.
  • Experience leading data engineering projects from requirements through production deployment.
  • Experience working in Agile/Scrum environments.
  • Experience with BI and analytics platforms such as Power BI, Tableau, Looker, or similar.
  • Understanding of Machine Learning data pipelines and MLOps is a plus.
  • Experience with modern data stack technologies such as dbt, Databricks, Snowflake, Kafka, and cloud-native services is highly desirable.

Key Competencies
  • Strong analytical and problem-solving skills.
  • Excellent understanding of data architecture and engineering principles.
  • Ability to translate complex business requirements into scalable technical solutions.
  • Strong communication and stakeholder-management skills.
  • Ability to work independently and collaboratively in a distributed team.
  • Strong ownership and accountability for production data systems.
  • Ability to mentor engineers and provide technical leadership.
  • Focus on performance, reliability, scalability, security, and maintainability.

Experience Profile

The ideal candidate should demonstrate experience with:
  • Enterprise-scale data platforms
  • High-volume data processing
  • Batch and streaming architectures
  • Cloud migration and modernization
  • Data warehouse and lakehouse implementations
  • ETL/ELT modernization
  • Data quality and observability
  • Performance and cost optimization
  • API and database integrations
  • Real-time analytics
  • Data governance and security
  • Production support and incident management
  • Technical leadership and mentoring
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.
  • Dice Id: 91134517
  • Position Id: a4abc227a4efd51263416d34efa24f73
  • Posted 4 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

McLean, Virginia

Today

Full-time

USD 130,000.00 - 140,000.00 per year

Remote

Today

Full-time

USD 128,039.00 - 173,229.00 per year

Boston, Massachusetts

Today

Full-time

USD 150,000.00 - 215,000.00 per year

Mexico City, Mexico City

Today

Full-time

USD 75,000.00 - 115,000.00 per year

Search all similar jobs