Sr Data Engineer

Overview

On Site
Full Time

Skills

Software Development
Solution Architecture
Data Lake
Warehouse
Functional Requirements
Data Migration
Migration
Extract
Transform
Load
Collaboration
Mentorship
Prototyping
Agile
Programming Languages
Python
SQL
Scala
Java
Big Data
Apache Spark
Apache Hadoop
Amazon S3
Electronic Health Record (EHR)
Google Cloud
Google Cloud Platform
Data Flow
Data Warehouse
Amazon Redshift
Database
IBM DB2
PostgreSQL
MySQL
MongoDB
Apache Cassandra
Elasticsearch
Apache Kafka
Amazon Kinesis
Apache Storm
Docker
Kubernetes
Orchestration
Apache Parquet
Apache Avro
JSON
Data Modeling
Dimensional Modeling
Data Architecture
As-is Process
Data Engineering
Cloud Computing
Security Clearance
Amazon Web Services
Data Analysis
Microsoft Azure
Snow Flake Schema
Real-time
Analytics
Streaming
Data Processing
Data Governance
Apache Atlas
Data Quality
Test Methods
Financial Services
Health Care
Personal Development
Community Development
Insurance
Legal
SAP BASIS
Law
LOS
Communication
Banking
Reporting
Recruiting

Job Details

Job Family:
Software Development & Support (Digital)

Travel Required:
Up to 10%

Clearance Required:
None

What You Will Do:

The Data Engineer will work closely with clients, digital leaders, solutions architects and technical/functional leads across Guidehouse digital teams and market segments to support client projects and provide solutions for growth efforts and capabilities build out.
  • Serve as a key member of the data team to support technical challenges/demos, building innovative data solution prototypes using modern data architectures and processing technologies.
  • Solutions architecture and hands-on engineering of scalable and secure distributed data systems using modern data technologies, cloud-native data services, data lake/warehouse architecture, and streaming data processing patterns.
  • Work collaboratively with data scientists, analytics engineers, platform engineers, product owners, solution architects, and business analysts to design, build, test, and deploy high-value, operationally resilient data products and pipelines that satisfy functional and non-functional requirements.
  • Support data migrations and modernization including migration from legacy data systems to modern cloud-based data platforms and real-time analytics architectures.

What You Will Need:
  • Bachelor's degree , Additional Four (4) years of exo will be needed in lieu of degree.
  • 6+ years of prior relevant experience in data engineering and data pipeline development
  • 3+ years of experience with cloud data platforms to build/modernize data systems and analytics solutions
  • Proven ability to work autonomously and collaborate, mentor, help, and support other team members, as needed to solve complex data engineering problems.
  • Proven ability to develop data solution prototypes and use prototypes to validate technical solution strategies and communicate and explain the pros and cons of complex data architecture alternatives.
  • An in-depth understanding of the Agile and Scaled Agile practices and principles experience. Must be an experienced Agile practitioner with proven ability to plan and implement data products with agility.
  • Experience and proficiency implementing data pipelines and analytics solutions including:
    • Programming Languages: Python, SQL, Scala, Java
    • Big Data Technologies: Apache Spark, Hadoop, Kafka, Airflow, Snowflake
    • Cloud Data Services: AWS (S3, Redshift, Glue, EMR, Kinesis) or Azure (Data Factory, Synapse, Event Hubs), or Google Cloud Platform (BigQuery, Dataflow, Pub/Sub)
    • Data Warehousing: Snowflake or Redshift, BigQuery, Synapse Analytics
    • Databases: DB2 or PostgreSQL, MySQL, MongoDB, Cassandra, Elasticsearch
    • Streaming Technologies: Apache Kafka, AWS Kinesis or Azure Event Hubs, Apache Storm
    • Containerization: Docker or Kubernetes, container orchestration for data workloads
    • Data Formats: Parquet, Avro, JSON, ORC, Delta Lake
  • Familiarity with data modeling techniques (dimensional modeling, data vault) and proven data architecture patterns (Lambda, Kappa, medallion architecture) required, as is the ability to design and build cloud-based data products that conform with data governance and security best practices.
  • This is a hands-on data engineering position and requires the ability to proficiently and predictably build and deploy custom data pipelines and analytics solutions in cloud environments.
  • Proven ability to design, build, test, and deploy data products and solutions on cloud data platforms.
  • Excellent written and verbal communication skills with an ability to handle customer requirements and engineer data solutions.
  • ship, or will be needed.
  • Ability to obtain public trust clearance

What Would Be Nice To Have:
  • AWS Certified Data Analytics - Specialty or Azure Data Engineer Associate or Google Professional Data Engineer or Snowflake Certification
  • Real-time analytics and streaming data processing
  • Data governance and lineage tools (Apache Atlas, DataHub, Collibra)
  • Experience with data quality frameworks and testing methodologies for data pipelines
  • Experience in the Financial Services industry preferred

What We Offer:

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:
  • Medical, Rx, Dental & Vision Insurance
  • Personal and Family Sick Time & Company Paid Holidays
  • Parental Leave
  • 401(k) Retirement Plan
  • Group Term Life and Travel Assistance
  • Voluntary Life and AD&D Insurance
  • Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
  • Transit and Parking Commuter Benefits
  • Short-Term & Long-Term Disability
  • Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
  • Employee Referral Program
  • Corporate Sponsored Events & Community Outreach
  • Care.com annual membership
  • Employee Assistance Program
  • Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
  • Position may be eligible for a discretionary variable incentive bonus

About Guidehouse

Guidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1- or via email at All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse's Ethics Hotline. If you want to check the validity of correspondence you have received, please contact Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant's dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.
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.