B&A is looking for a Date Warehousing Specialist 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 US Courts OSCAR program. We are looking for a Data Warehousing Specialist who will be responsible for designing, building, and maintaining data warehouses and data marts to support our organization's data needs. The ideal candidate will have a strong technical background,... more details
Date Warehousing Specialist:
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. Wed love for you to join our team!
Job Summary
B&A is looking for a Date Warehousing Specialist 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 US Courts OSCAR program. We are looking for a Data Warehousing Specialist who will be responsible for designing, building, and maintaining data warehouses and data marts to support our organization's data needs. The ideal candidate will have a strong technical background, hands-on experience with data warehousing technologies, and a deep understanding of data modeling and ETL processes. The Data Warehousing Specialist will work closely with cross-functional teams to ensure the availability, integrity, and accessibility of data assets for reporting, analysis, and business intelligence purposes.
Responsibilities
- Design, develop, and maintain data warehouse architectures, including dimensional modeling, schema design, and data integration processes.
- Implement and manage ETL (Extract, Transform, Load) processes to extract data from source systems, transform it into usable formats, and load it into the data warehouse.
- Collaborate with business stakeholders to understand data requirements and translate them into scalable and efficient data warehouse solutions.
- Optimize data warehouse performance for query processing, data loading, and data retrieval, ensuring high availability and scalability.
- Monitor and maintain data warehouse health, including data quality, data consistency, and system performance, and implement proactive solutions to address issues.
- Develop and maintain documentation for data warehouse processes, data models, and data lineage to support data governance and compliance requirements.
- Collaborate with data analysts, data scientists, and business intelligence developers to provide access to data and support data-driven decision-making.
- Stay updated with the latest trends, technologies, and best practices in data warehousing and related fields, and share knowledge with the team.
Education and Experience
- Bachelor's degree in computer science, Information Systems, or related field.
- 8 years of experience in data warehousing or related roles, with hands-on experience designing, building, and maintaining data warehouses and ETL processes.
Required Skills
- Strong understanding of data warehousing concepts and methodologies, including dimensional modeling, star schema, snowflake schema, and data integration techniques.
- Proficiency in SQL and experience with database management systems such as Oracle, SQL Server, or PostgreSQL.
- Experience with ETL tools such as Informatica, Talend, or Apache NiFi.
- Strong problem-solving abilities, with a focus on delivering scalable, high-performance data warehouse solutions to meet business requirements.
- Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.
- Ability to thrive in a fast-paced, dynamic environment and manage multiple priorities simultaneously.
- Commitment to quality, excellence, and continuous improvement, with a passion for learning and staying updated with the latest technologies and best practices in data warehousing.
Desired Skills
- Masters degree in computer science, Information Systems, or related field.
- Experience with cloud-based data warehousing platforms such as Amazon Redshift, Google BigQuery, or Snowflake.
- Knowledge of data governance principles and practices, including data quality management, metadata management, and data lineage.
- Experience with data visualization and reporting tools such as Tableau, Power BI, or Looker.
- Previous experience in [specific industry or domain].
- Certifications in relevant data warehousing technologies or platforms (e.g., AWS Certified Solutions Architect - Data Warehousing Specialty, Snowflake Certified SnowPro, etc.).
Security Clearance
- Eligible to obtain a public trust.
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 full time employees a 100% premium paid medical plan option, which includes coverage for medical, prescription, dental, vision, life insurance, AD&D, disability, Teladoc, and accident insurance. In addition to these benefits, B&A employees enjoy paid time off, tuition assistance, B&A sponsored trainings and certifications, commuter transit benefits (SmartBenefits) for DC Metro full-time employees and a free subscription to a virtual exercise platform (NEOU).
B&A has launched several programs to focus on employee engagement, wellness, and assistance.
These include:
- The B&A Cares program: on-staff registered counselor, 30/60/90-day wellness check ins, personal development, financial management, and stress management seminars, wellness challenges, and more
- A formal mentorship program
- Job shadowing and cross training opportunities
- Brand Ambassador program
- Lifeworks Employee Assistance Program (EAP): engagement through guided wellness and peer recognition. Access to various support resources to include counseling, legal guidance, financial planning, and more
- Monthly virtual events
- B&A Annual Wellness Challenge: #StepWithB&A, #WalkDuringLunchWithB&A, #VolunteeringWithB&A, and #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&As 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 employees I-9 Form to confirm work authorization.
