Data Engineer, Consultant

Employer
Guidehouse
Location
Washington, DC
Posted
Oct 04, 2021
Closes
Oct 18, 2021
Ref
147285094
Function
Engineer, IT, QA Engineer
Hours
Full Time
OverviewGuidehouse is a leading global provider of consulting services to the public and commercial markets with broad capabilities in management, technology, and risk consulting. We help clients address their toughest challenges and navigate significant regulatory pressures with a focus 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 prepare our clients for future growth and success. The company has more than 10,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: .ResponsibilitiesOur 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.Responsibilities:Developing detailed ETL source to target mappings materials and design documents to support a large and complex data integration and conversion effortStrong experience with SQL and stored procedures with Microsoft SQL Server, Microsoft SQL Server Integration servicesStrong data analysis expertise to validate source data for data quality issuesInteract closely with business stakeholders and technical developers as well as team membersSupporting team members, business stakeholders and technical developers to address emerging data challenges, risks, and issues as they emerge in the development and conversion effort of the new application.QualificationsQualifications for Data Engineer:At least 3 years of experience in a related field.Holds a degree from an accredited college / university.Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.Strong experience with SQL and stored procedures with Microsoft SQL Server, Microsoft SQL Server Integration services.Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.Strong analytic skills related to working with unstructured datasets.Build processes supporting data transformation, data structures, metadata, dependency and workload management.A successful history of manipulating, processing and extracting value from large, disconnected datasets.Strong project management and organizational skills.Experience supporting and working with cross-functional teams in a dynamic environment.Experience using the Agile methodology.Strong written and oral communication skills.Ability to solve problems and resolve issues independently.Strong attention to detail and analytical skills.Nice to Have:Experience building and optimizing "A< oebig data' data pipelines, architectures and data sets.Experience with establishing data platforms and data pipelines in Microsoft Azure.Master's degree in computer science or related.Relevant certifications demonstrating aptitude in data management.Working knowledge of environments that use Mulesoft.Additional RequirementsThe 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.DisclaimerAbout GuidehouseGuidehouse 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 RecruitingAccommodation@. 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 BenefitsGuidehouse 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 InsurancePersonal and Family Sick Time & Company Paid HolidaysPosition may be eligible for a discretionary variable incentive bonusParental Leave and Adoption Assistance401(k) Retirement PlanBasic Life & Supplemental LifeHealth Savings Account, Dental/Vision & Dependent Care Flexible Spending AccountsShort-Term & Long-Term DisabilityTuition Reimbursement, Personal Development & Learning OpportunitiesSkills Development & CertificationsEmployee Referral ProgramCorporate Sponsored Events & Community OutreachEmergency Back-Up Childcare Program