Overview Guidehouse 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: www.guidehouse.com. Responsibilities 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. Responsibilities: Developing detailed ETL source to target mappings materials and design documents to support a large and complex data integration and conversion effort Strong experience with SQL and stored procedures with Microsoft SQL Server, Microsoft SQL Server Integration services Strong data analysis expertise to validate source data for data quality issues Interact closely with business stakeholders and technical developers as well as team members Supporting 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. Qualifications Qualifications 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 'big 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 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. 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. Disclaimer 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 RecruitingAccommodation@guidehouse.com. 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