Guidehouse

Solving big problems, building trust in society, and empowering our clients to shape the future.

Senior Data Engineer

Data EngineerData EngineerFull TimeRemoteTeam 10,001+Since 2018H1B SponsorCompany SiteLinkedIn

Location

Illinois + 1 moreAll locations: Illinois, Virginia

Posted

11 days ago

Salary

$130K - $216K / year

Bachelor Degree8 yrs expExperience acceptedEnglishCloudETLSQL

Job Description

• Design, build, and maintain data pipelines and integrations that ingest, transform, and model data from enterprise systems • Develop robust SQL‑based data models, including dimensional and star schema designs, to support analytics and reporting • Implement and maintain semantic models that clearly define business logic and metrics • Work independently to own end-to-end technical delivery, from requirements through implementation and validation • Partner with Finance, Analytics, and Engineering stakeholders to translate business requirements into scalable technical solutions • Contribute to improving data quality, reliability, and maintainability across the platform • Participate in design reviews and collaborate on architectural decisions, while remaining primarily hands-on

Job Requirements

  • Strong hands-on experience designing and building data pipelines and data integrations
  • Deep expertise in SQL-based data modeling and transformations
  • Solid understanding of ETL/ELT patterns, semantic modeling, and star schema design
  • Experience working with cloud-based data platforms (data warehouse, lakehouse, or similar)
  • Proven ability to work independently, take ownership, and deliver high-quality solutions
  • Strong communication skills and the ability to explain technical designs to non-technical stakeholders
  • Comfort operating as a senior individual contributor, not a people manager
  • Expert level understanding of Data Mesh concepts (Data products, Data governance, etc)
  • Bachelor’s degree plus 8 years of relevant experience; Or 12 years of relevant experience in lieu of degree

Benefits

  • Medical, Rx, Dental & Vision Insurance
  • Personal and Family Sick Time & Company Paid Holidays
  • Position may be eligible for a discretionary variable incentive bonus
  • Parental Leave and Adoption Assistance
  • 401(k) Retirement Plan
  • Basic Life & Supplemental Life
  • Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
  • Short-Term & Long-Term Disability
  • Student Loan PayDown
  • Tuition Reimbursement, Personal Development & Learning Opportunities
  • Skills Development & Certifications
  • Employee Referral Program
  • Corporate Sponsored Events & Community Outreach
  • Emergency Back-Up Childcare Program
  • Mobility Stipend

Related Categories

Related Job Pages

More Data Engineer Jobs

Senior Data Engineer

Federato

When underwriters have real-time risk selection and portfolio insights at their fingertips, profitable growth follows!

Data Engineer11 days ago
Full TimeRemoteTeam 11-50H1B Sponsor

Senior Data Engineer focusing on scalable data infrastructure at Federato

AirflowAWSCloudETLGoogle Cloud PlatformPythonSQLTerraformTypeScript
United States
$185K - $215K / year
ContractRemoteTeam 2-10

The SAP S/4HANA Solution Architect is the technical and functional lead responsible for reviewing the current CLIENT blueprint and identifying process and system gaps between the existing SAP ECC / MES / PLM landscape and S/4HANA OOTB capabilities. Lead architecture review of CLI...

United States
Full TimeRemoteTeam 51-200

Join Our Team at Rancho BioSciences ! As we continue to grow, Rancho BioSciences is seeking an experienced and dynamic R&D Architect/Principal Architect to join our team. This role is critical in driving results across a project, ensuring successful execution, strategic alignment...

AWSAzureGCPPythonSQLdbtReactVueDockerKubernetesTerraformCI/CDELTETLSnowflakeDatabricksBigQueryDevOps
United States

Data Migration Specialist

Govcio LLC

GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

Data Engineer11 days ago
Full TimeRemoteTeam 1,001-5,000

GovCIO is currently hiring for a highly skilled and experienced Data Migration Specialist to support the migration of legacy HR data systems into a new Workday based HR environment. The successful candidate will play a critical role in ensuring a seamless and efficient transition...

United States