Data Warehouse Engineer (Remote worker opportunity)

in St Clair, IL

Data Warehouse Engineer (Remote worker opportunity) Job

Job Description Job Attributes+

  • Job ID


  • Job Location

    St Clair, IL 61801, US

  • Job Category

    Engineering & Technology

  • Job Type


  • Clearance Level


  • Career Level


  • Travel


Job Description

The successful candidate will be a part of the team that is responsible for Enterprise Data Warehouse. This position requires the candidate understands and applies technical standards, principles, theories, concepts, techniques and provides solutions to a variety of technical problems of moderate to high scope and complexity. The candidate develops deep knowledge and understanding of the data warehouse and data management assets available within our data platforms and act as the subject matter expert on the data and its utility for operational use. The candidate will regularly interact with the customers, data management teammates, and product development partners, your expertise in large volume data in data lakes, data warehouses, or data marts using structured, semi-structured, and unstructured formats - will deliver on the BAE’s Data and Analytics organization’s mission to enable data-driven decisions within any action. The candidate will follow established procedures, and contribute to the completion of milestones associated with specific projects and keep up-to-date with the technology shifts through training and development.

Required Education, Experience, & Skills

  • Bachelor’s Degree in Computer Science, Information Systems or similar
  • 6+ years of Data Warehousing and Data Modeling experience. 10+ years preferred.
  • Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques.
  • Strong experience working with ETL/ELT concepts of data integration, consolidation, enrichment, and aggregation in large volume data sets.
  • Expert in SQL and/or SQL-based languages and performance tuning of SQL queries.
  • Working knowledge of Data Pipelines, stream processing and highly scalable ‘big data’ data stores.
  • Experience with various data storage technologies - e.g. RDBMS (Oracle, SQL Server, etc.), columnar, tabular, document store, NoSQL
  • Experience with various ETL/ ETL tools – e.g. ODI, SSIS, Informatica Power Center, Talend, IICS, etc.
  • Experience with cloud-based data warehouses - e.g. Snowflake, BigQuery, Azure Synapse, RedShift, etc
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements.
  • Data validation skills to verify data integrity, understand discrepancies, and resolve them with the highest sense of urgency.
  • Demonstrated ability to share findings with non-technical or business stakeholders.
  • Familiarity with Analytical/Reporting Solutions like Tableau, Power BI is a plus
  • Virtual team collaboration tools such as WebEx, Zoom etc.
  • Excellent written, verbal communication and Interpersonal skills
  • Excellent problem solving skills

Soft Skills:

  • Work individually and in a matrix environment
  • Work creatively and analytically in a problem-solving environment
  • Communicate (written and oral) effectively and demonstrate professional interpersonal skills
  • Interact professionally with clients and vendors
  • Build positive working relationships with employees at all levels within the organization
  • Meet deadlines as necessary
  • Effectively work with minimal supervision
  • “Can-do” attitude, pro-active and resourceful

Preferred Education, Experience, & Skills

  • 10+ years experience preferred.
  • Knowledge of CI/CD pipeline.
  • Experience with scripting languages – e.g. PowerShell, Python, etc.

About BAE Systems, Inc.BAE Systems, Inc. is the U.S. subsidiary of BAE Systems plc, an international defense, aerospace and security company which delivers a full range of products and services for air, land and naval forces, as well as advanced electronics, security, information technology solutions and customer support services. Improving the future and protecting lives is an ambitious mission, but it’s what we do at BAE Systems. Working here means using your passion and ingenuity where it counts – defending national security with breakthrough technology, superior products, and intelligence solutions. As you develop the latest technology and defend national security, you will continually hone your skills on a team—making a big impact on a global scale. At BAE Systems, you’ll find a rewarding career that truly makes a difference. At BAE Systems, we celebrate the array of skills, experiences, and perspectives our employees bring to the table. For us, differences are a source of strength. We’re laser-focused on high performance, and we work hard every day to nurture an inclusive culture where all employees can innovate and thrive. Here, you will not only build your career, but you will also enjoy work-life balance, uncover new experiences, and collaborate with passionate colleagues.

Additional Information

Who We Are

You're used to protecting what matters most.

Throughout your career in the military, you've been dedicated to improving security, defending freedom and making the world a safer place. Now you can continue that commitment through cyber operations, intelligence analysis, and building combat vehicles and electronic systems. We’re proud to provide solutions and services that advance the strength and security of America and our allies – and we’re honored to offer an environment where veterans and reservists can continue doing mission-centered work. In all that we do, we are guided by our company values – trusted, innovative and bold – understanding that it’s not just what we do, but how we do it that underpins our success.
+ The Organization

Our team has the privilege and the responsibility of knowing that the work we do really matters. Our work is vital to the armed forces personnel and major corporations who rely on us to protect, equip and support them where it counts; to the security and prosperity of the nations we serve; to our skilled and talented people; to the local communities where we are based; and to the wider community who invest in, supply and engage with us. At BAE Systems, everyone can make a difference.

+ The Culture

We believe that a diverse workforce inspires creativity and drives innovation. We respect and value the huge variety of skills, abilities and perspectives that our people bring to our business. We celebrate our differences and aim to recruit and develop talent from all backgrounds, championing the strength that a truly inclusive and collaborative workplace gives to our company culture and performance.

+ The Work

Enjoy a flexible environment that values your work-life balance and helps you perform at your best.

+ The Opportunity

On the job training, leadership programs, collaboration with leading experts – excellence is built into your career development whether you are just starting out as an apprentice or are an experienced professional.

+ The People

We’re united by trust, camaraderie and a shared ambition to lead the world in our field. It helps that we’re nice people too.

+ The Reward

See your contribution, making real change as breakthrough technology and intelligence solutions reshape the landscape for our customers.

What We Offer

+ Warrior Integration Program (Est. 2008)

This program was created to assist in the employment, transition, education, and development of wounded warriors. Through mentoring, partnership, education, and leadership, we vow to serve our veterans in the same manner they served our country. WIP provides mission-centered work that gives wounded warriors the opportunity to contribute, providing a path for career progression.

+ Camo to Corporate (Est. 2013)

Camo to Corporate underpins all of our military recruiting and veteran efforts. We participate in annual career workshops and partner with VA employment reps to identify opportunities for vets at BAE Systems. We’re also proud members of Joining Forces, the Veteran Jobs Mission and Hiring our Heroes - initiatives focused on helping vets and their spouses find meaningful careers.

Perks & Benefits

  • Veterans Support Network
    Veterans Support Network +-

    The mission of the Veterans Support Network is to help connect former service members, active duty members, reservists and those who are supportive of the Armed Services.

  • Health & Wellness
    Health & Wellness +-

    We offer medical plans that take great care of you and your family’s health and well-being. These include medical plans, prescription drugs, dental and vision, along with incentive programs and health saving and spending accounts.

  • Time Away From Work
    Time Away From Work +-

    Paid Time Off (PTO) provides you with paid time away from work that you can use for vacation, personal time, personal illness, or to care for dependents. You can accumulate up to a maximum of 400 PTO hours.

  • Military Leave
    Military Leave +-

    Full-time and part-time employees who serve in the military reserves are eligible to take paid and unpaid leaves of absence to perform military duty.

  • Employee Assistance Program
    Employee Assistance Program +-

    The EAP offers confidential support to manage personal issues, such as stress, family issues, and substance abuse.

  • Employee Discount Programs
    Employee Discount Programs +-

    BAE Systems partners with Beneplace to offer exclusive discounts on a variety of products and services.

  • Tuition Reimbursement
    Tuition Reimbursement +-

    Lifelong employee learning is critical to both your personal growth and that of BAE Systems as a trusted, innovative, and bold organization. That’s why we offer a tuition reimbursement program, so you can pursue advanced education to help further your career.

  • Adoption Assistance
    Adoption Assistance +-

    You can be reimbursed up to $4,000 for qualified adoption expenses through the Adoption Assistance program.

  • Financial Wellness
    Financial Wellness +-

    Plan for today, save for tomorrow. Our programs support your goals at every stage of life. These programs include 401(k) savings plans, life and accident insurance, disability coverage, home, auto, and pet insurance and legal planning.

Our Partners

G.I Jobs Hiring Our Heroes Veterans Job Mission Joining Forces Soldier for Life American Association of People with Disabilities

Saved Jobs