ETL Engineer

ETL Engineer

The Opportunity: 

Ever-expanding technology 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 an experienced data engineer like you to help our clients find answers in their big data to impact important missions

Here, you will work with multiple platforms, architectures, and diverse technologies gathering requirements and design and develop ETL processes to transform information from multiple sources. You'll design, implement, and manage databases and data delivery systems and transform them into insights, analysis, and reporting. You'll maintain responsibility for the design, development, implementation, and maintenance of ETL workflows and scripts. You'll work with structured and unstructured data, ETL, data wrangling, data ingest, and data access. You'll leverage knowledge of data modeling, ETL, SQL scripting, and analytical expertise.

Work with us to use big data for good. 

Join us. The world can’t wait. 

You Have:   

• 4+ years of experience in stream processing pipelines with Apache NiFi

• 1+ year of experience with JSON and parsing

• Experience building and maintaining data flows in NiFi

• Experience with ETL development and processes, including creating high-level ETL plans consisting of Source to Target mappings

• Experience creating, managing, and troubleshooting complex operational data flows

• Experience using Apache NiFi canvas to process and distribute data

• Experience with data flow processes and tools

• Experience with SQL, including writing complex SQL scripts, Oracle, and Server

• TS/SCI clearance with a polygraph

• Bachelor's degree in CS

Nice If You Have:   

• Experience with data security and compliance procedures and policies

• Experience with Data Marts and Data Warehouses

• Experience with Dimensional Modeling and Relational Databases

• Experience with Data Modeling concepts

• Experience with Java, Python, Perl, or Bash

• Experience with Source code management and integration

• Experience with the Atlassian Tool Suite, including JIRA or Confluence or GitHub

• Knowledge of overall IC agency processes and policies

• Ability to design ETL processes, including keeping business rules in mind for data quality purposes

• Ability to execute projects and tasks with minimal guidance and supervision

Clearance:   

Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; TS/SCI clearance with polygraph is required.

Create Your Career: 

Grow With Us 

Your growth matters to us—that’s why we offer a variety of ways for you to develop your career. With professional and leadership development opportunities like upskilling programs, tuition reimbursement, mentoring, and firm-sponsored networking, you can chart a unique and fulfilling career path on your own terms.  

A Place Where You Belong 

Diverse perspectives cultivate collective ingenuity. Booz Allen’s culture of respect, equity, and opportunity means that, here, you are free to bring your whole self to work. With an array of business resource groups and other opportunities for connection, you’ll build your community in no time. 

Support Your Well-Being 

Our comprehensive benefits package includes wellness programs with HSA contributions, paid holidays, paid parental leave, a generous 401(k) match, and more. With these benefits, plus the option for flexible schedules and remote and hybrid locations, we’ll support you as you pursue a balanced, fulfilling life—at work and at home.  

Your Candidate Journey 

At Booz Allen, we know our people are what propel us forward, and we value relationships most of all. Here, we’ve compiled a list of resources so you’ll know what to expect as we forge a connection with you during your journey as a candidate with us.  

Compensation

At 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.

Work Model
Our 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 Commitment

We’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.