Data Engineer, Senior Consultant

Location: Washington, DC 20006

*** Mention DataYoshi when applying ***

Guidehouse is a leading management consulting firm serving the public and commercial markets. We guide our clients forward towards new futures that build trust in society and your professional skills along the journey. Join us at Guidehouse.
Our Data IT Strategy consultants help our clients improve business value through optimizing the efficiency and effectiveness of their IT capabilities. This high performing group plays a critical role in multi-disciplinary strategy teams. We enable our clients to understand, plan for, and realize strategic opportunities presented by information technology through a collection of capabilities such as Enterprise IT Management, Mission Enablement, and IT Transformation.

  • Candidate will be part of data solutions/integration team deeply involved in a data conversion/integration effort supporting a major system modernization
  • Developing detailed ETL mapping materials to support a large and complex data integration and conversion effort
  • Interact closely with business stakeholders and technical developers as well as team members
  • Participating in daily stand-up (scrum calls), sprint ceremonies such as review, demo, and planning
  • Supporting team members, business stakeholders and technical developers to address emerging challenges, risks, and issues as they emerge in the development and conversion effort of the new application
  • Bachelor’s Degree or equivalent work experience
  • 5+ years of technical experience; preferred 2+ years of consulting experience
  • Strong oral and written communicator
  • Strong ability to understand, modify and create SQL queries
  • Experience conducting data profiling of ERP legacy systems with emphasis on Relational data bases (e.g. IBM DB2, Oracle, SQL)
  • Experience analyzing application source code (various languages)
  • Experience with logical and physical data modeling
  • Experience developing Source-to-Target Mapping documentation and source/target data models
  • Experience developing ETL documentation to define the specifications for the technical developers
  • Experience developing documentation for data migration and/or integration projects
  • Ability to develop technical documentation for ETL developers
  • Experience with a ETL tool (e.g. IBM DataStage)
  • Experience in coding using JSON, JavaScript, API integration
  • Experience or knowledge of working with software development coordinating with developers, and collecting feedback from stakeholders
  • Experience in Agile development projects and implementing process improvements that align with Agile best practices
  • Ability to use PowerPoint and Word to create polished, visually appealing presentations and documents for clients and stakeholders
  • Strong written and oral communication skills
  • Analytical and solution-oriented to help clients assess and improve data integration solutions
  • Familiar with Jira/Kanban or Atlassian Suite tools leveraged in software development projects
  • Experience working in AWS and ElasticSearch
  • Experience analyzing and working with legacy systems/applications
  • Experience in managing communications between business stakeholders and technical developers
  • Experience with reviewing, documenting and decommissioning legacy applications
Additional Requirements:
  • The successful candidate must not be subject to employment restrictions from a former employer (such as a non-compete) that would prevent 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 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
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
Position may be eligible for a discretionary variable incentive

*** Mention DataYoshi when applying ***

Offers you may like...

  • Grubhub Holdings, Inc.

    Senior Data Engineer
    New York, NY 10018
  • Splunk

    Data Engineer, DevOps - Remote OK
    Sun Prairie, WI 53590
  • Cognizant Technology Solutions

    Senior Data Engineer (Remote) - Advanced Technolog...
    Chicago, IL 60601
  • Lessonly

    Senior Data Engineer
    Indianapolis, IN 46202
  • Numerator

    Sr. Data Engineer
    Chicago, IL 60606