Guidehouse | Sr. Lead Data Engineer | Washington, DC | United States | | 17 Oct 2022

Before u proceed below to check the jobs/CVs, please select your favorite job categories, whose top job alerts you want in your email & Subscribe to our Email Job Alert Service For FREE


Job Location: Washington, DC


Guidehouse is a leading global provider of consulting services to the public sector and commercial markets, with broad capabilities in management, technology, and risk consulting. By combining our public and private sector expertise, we help clients address their most complex challenges and navigate significant regulatory pressures focusing on transformational change, business resiliency, and technology-driven innovation. Across a range of advisory, consulting, outsourcing, and digital services, we create scalable, innovative solutions that help our clients outwit complexity and position them for future growth and success. The company has more than 12,000 professionals in over 50 locations globally. Guidehouse is a Veritas Capital portfolio company, led by seasoned professionals with proven and diverse expertise in traditional and emerging technologies, markets, and agenda-setting issues driving national and global economies. For more information, please visit


Guidehouse is looking for a Sr/Lead Data Engineer to support one of our high performing teams supporting application and reporting systems. Team consists of experienced data analysts, software engineers, developers, DevSecOps and client environments. The team works directly with clients to implementing data analytics, data engineering, data gathering, data visualization, dashboarding, as well as a large application development team. The Sr Data Engineer will be responsible for supporting the team focusing on architecture, administration and maintenance of the critical platforms and tools used by the team. Providing team support covering reporting, ETL development and maintenance, data system availability, data environment administration, performance, and other improvements. The Systems Engineer will bring hands-on experience with the administering, maintenance, monitoring, performance, and providing team support and guidance. Resulting in a high performing data environment for data team, development team, and clients.
Sr/Lead Data Engineer will support a high-paced client environment and team of experienced full stack application developers, software engineers, data analysts, and quality assurance engineers. Sr/Lead Engineer will be responsible for developing DB Schemas, ETLs via Pentaho, supporting development of reports and data analytics built using Java, Angular CLI, Spring Boot, Postgres (EDB) architecture and Tableau all residing in a DevSecOps environment on prem and in cloud.

Sr/Lead Data Engineer will bring hands-on experience with reviewing and implementing requirements, SQL scripting, unit testing, peer reviewing, working with QA team to resolve code defects. Carrying a sense of urgency to ensure implementations are well built to adhereing to coding standards and prescribed development processes. Able to work effectively with the team to identify and perform root cause analysis of any defects. Sr/Lead Data Engineer should be performance minded. Be aware of business needs and the software functionality being created or maintained, inclusive of automated QA, security integration, and system monitoring efforts. With an ability to learn new development tools as the need arises. Provide mentorship of team mates that are more junior or are learning new technologies or standards.

Qualifications: Jyotish Jyotish - Career & Life Prediction

  • US Citizenship and the ability to obtain a Public Trust is contractually required
  • 7+ years minumum experience working with relevant technology stack
  • Bachelor’s degree or equivalent work experience
  • Strong experience with Big Data concepts, Pentaho, ETL process, Reporting and Analytics and Transactional SQL, PL SQL, NoSQL database development
  • Extracting pertinent data and transferring it into the warehousing environment
  • Ability to analyze big-picture data needs
  • Experience with database performance
  • Strong troubleshooting and diagnostic skills with ability to resolve issues
  • Ability to work in Linux environment such as Red Hat Enterprise Linux, Open Shift, Core OS
  • Shows experience applying technical knowledge and experience to recommend and implement database schema structures, complex stored procedures, and solutions that achieve business reporting and analytical requirements.
  • Experience working as team lead for small projects with limited duration. Directs, monitors, reviews the work of team members. While contributing to coding efforts with the team.
  • Has experience collaborating with teammates, architects, business clients and stakeholders to document business requirements and create both functional and technical specifications.
  • Experience providing estimates and task planning as needed to support business cases and portfolio prioritization.
  • Responsible for achieving project schedule and functional objective

  • Experience in designing, coding, testing, debugging, maintaining, and documenting database schema, data dictionaries, and usage.
  • Familiarity with Spring Boot, Microservices, Restful API patterns and best practices
  • Exposure to CI/CD tools such as Jenkins, Maven, Docker
  • Has experience using JIRA or an equivalent agile project management tool (i.e. Pivotal Tracker, VersionOne)
  • Following established software development standards and procedures and contribute towards their improvement.
  • Developing complex application features and creating technical designs.
  • Participating in design, peer and code reviews.
  • Researching, developing and writing complex high end, mission critical, role-based enterprise level computer programs requiring high degree of security and computational ability.
  • Reviewing and analyzing complex programming specifications to resolve issues.
  • Debugging code and troubleshooting skills independently
  • Analyzing and debug Application/Integrations root causing issues and able to create recovery plans.
  • Remediation of security, 508, performance related issues as they arise.
  • Automation of ETL process within Jenkins or other CI/CD pipeline tools
  • Data validation and testing practices of ETL’s
  • Performing application unit testing using Junit, JMeter, Nexus, SonarQube, RestEasy, Selenium, or Katalon

Additional Requirements:

The successful candidate must not be subject to employment restrictions from a former employer (such as a non-compete) that would prevnt the candidate from performing the job responsibilities as described.


About Guidehouse

Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, 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-571-633-1711 or via email at [email protected]. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

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.

Rewards and Benefits

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
  • 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
  • Tuition Reimbursement, Personal Development & Learning Opportunities
  • Skills Development & Certifications
  • Employee Referral Program
  • Corporate Sponsored Events & Community Outreach
  • Emergency Back-Up Childcare Program

Apply Here

Submit CV To All Data Science Job Consultants Across United States For Free


Please enter your comment!
Please enter your name here