Data Engineer - Senior Consultant

Washington, DC
Nov 23, 2021
Dec 04, 2021
Engineer, IT, QA Engineer
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 consultants on the Advanced Analytics & Intelligent Automation team help clients maximize the value of their data and automate business processes. This high performing team works with clients to implement the full spectrum of data analytics and data science, from data engineering, data querying and wrangling, to data visualization and dashboarding, to predictive analytics, machine learning, and artificial intelligence as well as robotic process automation (RPA). Our services enable our clients to define their information strategy, enable mission critical insights and data-driven decision making, reduce cost and complexity, increase trust, and improve operational effectiveness. Our consultants focus on client services, while also supporting business development, internal firm initiatives, and ongoing professional development.Job Description/Responsibilities:Operate in a cloud environment and assess environment specifications and requirements for big dataDevelop, maintain, and test infrastructures for data generation to transform data into a format that can be easily analyzed to drive key business decisionsPartner with data scientists/analysts and cross-functional teams to discover, collect, cleanse, and refine the data needed for analysis and modelingDevelop, build, test, and maintain scalable data pipeline architectures and tools aligned with business requirementsManage ETL (Extract, Transform, Load) functionsMaintain data lakesPerform complex data queriesUtilize best practices for and identify ways to improve data management, reliability, efficiency, and qualityRemove roadblocks to development through collaboration, communication, and creative solutionsDrive development best practices and continuous integration and delivery in an Agile frameworkQualificationsRequired:Minimum Security Clearance: US Citizenship and ability to obtain a Public Trust security clearanceB.S./BA in Data Science, Computer Science, Information Systems, or other quantitative and computational discipline3+ years of relevant professional experienceSpark programming in PySpark or ScalaProficiency in SQLFirm understanding of Data Warehousing conceptsConstructing, developing, and utilizing data pipelines / ETLStrong understanding relational databases, columnar data warehouses, and data modelingInstrumenting basic automation and CI/CDDesigning and building distributed systems for scalability and securityData engineering to enable data science and machine learningFamiliarity with cloud-based services (AWS) and container technologies (Docker/Kubernetes)Understanding of Agile development methodologiesPreferred:M.S./MA in Data Science, Computer Science, Information Systems, or other quantitative and computational discipline5+ years of relevant experienceDeveloping data pipelines / ETLs and performing data engineering using SparkUtilizing Big Data platforms such as DatabricksCloud data movement such as KafkaCloud services including data storage, serverless computation, data movement, identity managementDatabases such as Snowflake, Redshift, Oracle, Sql Server or PostgresTuning performance for large data projects in big data or relational installationsMicro services architecture and API gatewaysSupporting clients: identifying and addressing needs, building relationships, driving solutions forwardSupporting business development including RFP/RFQ/RFI responsesKnowledge of National Security or Defense sectorsAdditional 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.This position is open to candidates virtually from Montana, New Mexico, Utah, Wyoming, Arizona, Hawaii or Eastern, Pacific, and Central time zones.Due to our contractual requirements and federal orders, including an Executive Order from the White House and an emergency regulation from the Centers for Medicare & Medicaid Services (CMS), the position for which you are applying requires that you provide proof of your vaccination status. If you are unable to receive the COVID-19 vaccine for medical reasons or because of a sincerely held religious belief, you may request an exemption from the vaccination requirement which shall be reviewed after the submission of requested documentation. If an accommodation is granted, the conditions may include weekly testing and masking. All Guidehouse employees also agree to follow any additional health and safety mitigation policies that may be required in the workplace.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