ETL Data Engineer

Job Number: R0205147ETL Data EngineerThe Opportunity:Ever-expanding technology like IoT, machine learning, and artificial intelligence means that there’s more structured and unstructured data available today than ever before. As a Data Engineer, you know that organizing big data can yield pivotal insights when it’s gathered from disparate sources. We need a Data Engineer like you to help our clients find answers in their big data to impact important missions—from fraud detection to cancer research to national intelligence.As an Extract, Transform, and Load (ETL) Engineer at Booz Allen, you’ll use your skills and experience to implement data engineering activities on some of the most mission-driven projects in the industry. You’ll develop and deploy the pipelines and platforms that organize and make disparate data meaningful. Here, you’ll work with a multi-disciplinary team of analysts, data engineers, developers, and data consumers in a fast-paced, agile environment. You’ll use technology and tools to identify problem areas and opportunities for improvement in a mission-critical data set. With your technical experience, mentoring, and opportunities to learn new tools and skills, we’ll focus on growing as a team to make the best solutions for our customers.With your motivation to establish processes and facilitate technological innovation, you’ll make a lasting impact in the lives of veterans, their families, and their advocates.Join us. The world can’t wait.You Have:  • 4+ years of experience developing and maintaining complex and high-performance Microsoft SQL Server database architectures and schemas• 4+ years of experience monitoring and tuning databases for high-performance and efficiency• 4+ years of experience in Microsoft SQL Server development, including SQL, T-SQL, stored procedures, functions, and views• 2+ years of experience creating and modifying extract, transform, and load (ETL) tools that load data from multiple sources into cloud-based data warehouses or data lakes• Experience with developing and maintaining documentation, including standards and best practices• Experience with analytical and problem-solving abilities• Knowledge of oral and written communication skills• Ability to multitask, prioritize, and manage time efficiently• Ability to obtain and maintain a Public Trust or Suitability/Fitness determination based on client requirements• Bachelor’s degreeNice If You Have:  • Experience with Electronic Data Interchange (EDI) mapping tools, such as BizTalk, WebMethods, Axway, or Edifecs• Experience with data modeling tools, such as Informatica, Talend, Apache Airflow and Hevo• Experience in integrating business rules and mappings using tools, such as Snowflake Data Cloud, Databricks, Azure Data Factory and Microsoft Fabric• Experience with backend application development, data integration, or REST API service• Experience with creating solutions in a collaborative, cross-functional team environment• Experience with advanced data modeling and warehousing concepts• Experience with data visualization tools, such as Power B, Tableau and Splunk• Experience with cloud service providers (CSPs), such as AWS and Azure, and their associated services and tools• Experience with Agile engineering practices• Experience in working with the Department of Veterans AffairsVetting:Applicants selected will be subject to a government investigation and may need to meet eligibility requirements of the U.S. government client.CompensationAt Booz Allen, we celebrate your contributions, provide you with opportunities and choices, and support your total well-being. Our offerings include health, life, disability, financial, and retirement benefits, as well as paid leave, professional development, tuition assistance, work-life programs, and dependent care. Our recognition awards program acknowledges employees for exceptional performance and superior demonstration of our values. Full-time and part-time employees working at least 20 hours a week on a regular basis are eligible to participate in Booz Allen’s benefit programs. Individuals that do not meet the threshold are only eligible for select offerings, not inclusive of health benefits. We encourage you to learn more about our total benefits by visiting the Resource page on our Careers site and reviewing Our Employee Benefits page.Salary at Booz Allen is determined by various factors, including but not limited to location, the individual’s particular combination of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements. The projected compensation range for this position is $60,400.00 to $137,000.00 (annualized USD). The estimate displayed represents the typical salary range for this position and is just one component of Booz Allen’s total compensation package for employees. This posting will close within 90 days from the Posting Date.Work ModelOur people-first culture prioritizes the benefits of flexibility and collaboration, whether that happens in person or remotely.• If this position is listed as remote or hybrid, you’ll periodically work from a Booz Allen or client site facility.• If this position is listed as onsite, you’ll work with colleagues and clients in person, as needed for the specific role.EEO CommitmentWe’re an equal employment opportunity/affirmative action employer that empowers our people to fearlessly drive change – no matter their race, color, ethnicity, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, ancestry, age, marital status, sexual orientation, gender identity and expression, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, local, or international law.