Senior Data Engineer Consultant
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.A' Responsibilities:Create and maintain optimal data pipeline architecture.Assemble large, complex data sets that meet functional / non-functional business requirements.Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using ETL tools.Improve enterprise-wide data gathering, storage, and preparation to optimize data analysis capacity.Assist with development of designs that enhance the data infrastructure, improve reliability and maintainability of data storage solutions, and minimize duplicate instances of data (eg, master data management).Support design discussions, code reviews and help develop performant solutions to maintain a high level of quality in data systems through sound development and data management practices. QualificationsRequirements:At least 3-5+ years of experience in a related field.US Citizenship is contractually required.Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.In-depth knowledge of the software development lifecycle (design, build, test, deploy, support).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.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.A' Must Have:MS degree in Computer Science or Engineering OR equivalent years of relevant work experience. 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. DisclaimerDisclaimerA' About GuidehouseGuidehouseA' 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.A' 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.A' If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contactA' GuidehouseA' Recruiting at 1-571-633-1711 or via email atA' RecruitingAccommodation@. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.A' 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.A' Rewards and BenefitsGuidehouseA' 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.A' Benefits include:Medical, Rx, Dental & Vision InsurancePersonal and Family Sick Time & Company Paid HolidaysParental 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 ProgramPosition may be eligible for a discretionary variable incentiveA'