Senior Data Engineer

Senior Data Engineer

At B&A, we foster and embrace a distinct set of values that we live by and instill in all aspects of our organization: dedication, commitment, partnership, trust, and recognition.
We have incorporated these values into successful delivery for our customers since 1988.
B&A believes in ensuring its employees feel deeply connected to B&A, recognizing successes and hard work, and providing continuous opportunities to learn and grow.
Our people are entrepreneurial thinkers that combine mindset, vision, and experience to drive value - not only to us as an organization, but to the clients we support.
We promote a collaborative culture with our clients, and with each other, as one team working towards a common vision.
We'd love for you to join our team!

Job Summary

B&A is looking for a Senior Data Engineer to join a contract with a federal government client in support of an important mission.
In this role, you will have the opportunity to work with a great team while supporting the United States Customs and Border Protection.
The Senior Data Engineer will work with our data warehousing team to transform transactional data into datasets that are consumable by a variety of consumers, for reporting and analytics.
The successful candidate will be flexible and forward-leaning, able to learn new tools and skills, and able to learn new data domains as the data warehouse grows.

Responsibilities Design, build, and maintain scalable and reliable data pipelines to support data integration, processing, and analysis. Collaborate with data scientists, analysts, and other stakeholders to understand data needs and deliver high-quality data solutions. Implement best practices for data management, including data governance, data quality, and data security. Optimize and tune data processes for performance and cost-efficiency. Develop and maintain ETL processes to ingest and transform data from various sources. Create and manage data models, schemas, and databases to support data storage and retrieval. Monitor and troubleshoot data pipelines to ensure data accuracy and availability. Mentor and provide guidance to junior data engineers and other team members. Stay up to date with the latest technologies and industry trends in data engineering. Education and Experience Bachelor's degree plus at least 7 years in a data engineering role including ETL development, database development, data integration, data mining, big data. Required Skills Strong experience developing and maintaining complex SQL for ETL and reporting Strong experience with large complex data systems Experience performing database administration tasks (manage scheduled jobs, cluster configurations) Experience performing software administration tasks (deploy applications, manage scheduled tasks) Ability to learn new tools quickly as needed to provide new ideas for solving problems Ability and desire to work with other program staff and customers to reach design decisions within given constraints Excellent diplomacy and communication skills with both clients and technical staff Desired Skills Proficiency in Python and Scala Experience using Spark and Hive Experience with Qlik or other data visualization administration Experience completing Databricks development and/or administrative tasks Familiarity with some of these tools: DB2, Oracle, SAP, Postgres, Elastic Search, Glacier, Cassandra, DynamoDB, Hadoop, Splunk, SAP HANA, Databricks Experience working with federal government clients Security Clearance Active DHS or CBP Public Trust required More About B&A: Notable Clients
B&A has grown to be a company that is trusted by our clients for exceptional service, innovative solutions, and inspired employees.
Our service extends through federal, state, and local Government, the private sector, and higher education.
Some of our notable clients include Department of Homeland Security, U.S. Customs and Border Protection, U.S. Senate, U.S. Courts, U.S. Census Bureau, U.S. Navy, and more.

Diversity, Equity, and Inclusion

B&A affirms its long-standing commitment to maintain a diverse workforce reflective of the communities in which it operates, strives to maintain a business culture that recognizes the contributions and interests of diverse cultural and social groups, and seeks to maximize employee efforts by understanding individual differences and perspectives.

Benefits and Programs
B&A is proud to offer three robust individual and family medical plans to full time employees, including a Health Savings Account (HSA) option as well as dental, vision, life & AD&D, disability, Teladoc, accident, and critical illness insurance.
In addition to these benefits, B&A employees enjoy paid time off, B&A sponsored trainings and certifications, pet insurance benefits, commuter transit benefits and a free subscription to a virtual exercise platform (NEOU).
B&A's 401(k) plan is available to all employees and includes a company matching contribution.

B&A has launched several programs to focus on employee engagement, wellness, and assistance.
These include:
The B&A Cares program: 30/60/90-day wellness check ins, personal development, financial management, and stress management seminars, and more A formal mentorship program Job shadowing and cross training opportunities Brand Ambassador program Employee Assistance Program (EAP) - Access to various support resources to include counseling, legal guidance, financial planning, and more Monthly teambuilding events B&A Annual Wellness Challenges: #StepWithB&A, #WalkDuringLunchWithB&A, #VolunteeringWithB&A, #ExerciseDuringLunchWithB&A, and more

At B&A, we place significant importance on improving the communities and lives of citizens across the nation through our involvement, technology expertise, and employees.
B&A puts an emphasis on charitable efforts in the Northern Virginia area, including Capital Area Food Bank pantry drives, book donations, Hope for Henry Foundation events, and many more.
In recognition of all these efforts, B&A has been named a Companies as Responsive Employers (CARE) award recipient by Northern Virginia Family Services and nominated by the Northern Virginia Chamber of Commerce for Outstanding Corporate Citizenship Award.

EEO

B&A provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.
B&A complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.
This policy covers conduct occurring at B&A's offices, and other workplaces (including client sites) and all other locations where B&A is providing services, and to all work-related activities.

EEO is the Law

Affirmative Action Plan

As a federal government contractor and based on Executive Orders and applicable laws and regulations, B&A develops and maintains annual written Affirmative Action Plans and endeavors to hire and advance qualified minorities, females, individuals with disabilities, and protected veterans.

B&A participates in e-Verify.
We provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) with information from each new employee's I-9 Form to confirm work authorization.