Senior Data Engineer

Senior Data Engineer

Job Family:

Travel Required:

Clearance Required:

What You Will Do:

• Design, develop, and maintain robust, scalable, and efficient data pipelines and ETL/ELT processes.
• Lead and execute data engineering projects from inception to completion, ensuring timely delivery and high quality.
• Build and optimize data architectures for operational and analytical purposes.
• Collaborate with cross-functional teams to gather and define data requirements.
• Implement data quality, data governance, and data security practices.
• Manage and optimize cloud-based data platforms ( Azure\AWS).
• Develop and maintain Python/PySpark libraries for data ingestion, Processing and integration with both internal and external data sources.
• Design and optimize scalable data pipelines using Azure data factory and Spark(Databricks)
• Work with stakeholders, including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Develop frameworks for data ingestion, transformation, and validation.
• Mentor junior data engineers and guide best practices in data engineering.
• Evaluate and integrate new technologies and tools to improve data infrastructure.
• Ensure compliance with data privacy regulations (HIPAA, etc.).
• Monitor performance and troubleshoot issues across the data ecosystem.
• Automated deployment of data pipelines using GIT hub actions \ Azure devops

What You Will Need:

• Bachelors or master's degree in computer science, Information Systems, Statistics, Math, Engineering, or related discipline.
• Minimum 5 years of solid hands-on experience in data engineering and cloud services.
• Extensive working experience with advanced SQL and deep understanding of SQL.
• Good Experience in Azure data factory (ADF), Databricks , Python and PySpark.
• Good experience in modern data storage concepts data lake, lake house.
• Experience in other cloud services (AWS) and data processing technologies will be added advantage.
• Ability to enhance , develop and resolve defects in ETL process using cloud services.
• Experience handling large volumes (multiple terabytes) of incoming data from clients and 3rd party sources in various formats such as text, csv, EDI X12 files and access database.
• Experience with software development methodologies (Agile, Waterfall) and version control tools
• Highly motivated, strong problem solver, self-starter, and fast learner with demonstrated analytic and quantitative skills.
• Good communication skill.

What Would Be Nice To Have:

• AWS ETL Platform – Glue , S3
• One or more programming languages such as Java, .Net
• Experience in US health care domain and insurance claim processing.

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.

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 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 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.