
Senior Data Engineer
Guidehouse
full-time
Posted on:
Location Type: Remote
Location: Illinois • New York • United States
Visit company websiteExplore more
Salary
💰 $98,000 - $163,000 per year
Job Level
About the role
- Design, build, test, and maintain scalable data pipelines (batch and/or streaming as applicable) with increasing independence.
- Integrate data from multiple sources, resolve inconsistencies, and deliver curated datasets for analytics and operational use.
- Own data quality for assigned domains by implementing validation checks, reconciliation, and monitoring/alerting patterns.
- Build, maintain, and deploy data products for analytics and data science teams on cloud platforms (e.g. AWS, Azure, GCP).
- Optimize performance of pipelines and queries (tuning, partitioning patterns, efficient compute usage).
- Collaborate cross-functionally with analysts, data scientists, and stakeholders to translate requirements into technical designs and delivery plans.
- Produce and maintain technical documentation for data flows, data models, and operational procedures.
- Contribute to governance and compliance practices (access controls, lineage awareness, controlled data handling) within your scope.
Requirements
- Bachelor’s degree from an accredited college/university.
- Based on our contractual obligations, candidate must be located within the United States and US Citizen.
- Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST".
- Advanced SQL and Python skills and experience with relational databases and database design
- Experience working with data ingestion tools such as AWS Lambda, AWS Data Migration Service, SFTP
- Experience making dashboards and using data visualization tools (Tableau, Power BI)
- Experience in integrating data from disparate systems and technologies (IBM Mainframe, Structured, Semi-structured and unstructured sources.)
- Proficiency with one or more cloud-based solutions (e.g., AWS, Azure, GCP)
Benefits
- 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.)
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLPythondata pipeline designdata quality managementdata integrationdata visualizationdatabase designperformance optimizationdata governancedata handling
Soft Skills
collaborationcommunicationproblem-solvingindependenceattention to detail
Certifications
Bachelor's degreeFederal or DoD Public Trust