Data Engineer

Data EngineerPittsburgh, Pennsylvania, United StatesApply Company Description Air is the leader in Enterprise Readiness. Our mission is to establish readiness as a real-time condition that is continuously achieved. Today, a dangerous Readiness Gap exists between what the front line needs and what is delivered. Our AI-native platform, Air Enterprise Readiness, aligns development, production, delivery, and sustainment into one coordinated execution system for government agencies and industrial suppliers. By revealing true capacity, exposing real constraints, coordinating resources, and executing at the speed of operational demands, the front line gets what it needs to succeed.   Job Description We are seeking an exceptional and experienced data engineer who shares our passion and obsession with quality.  You'll be a core member of our product and engineering team dedicated to helping our clients replace time-consuming, manual processes to reach informed real-time decisions about government markets, competitors, and agency relationships. We need a skilled and dedicated data nerd to join our team to lead us in uncovering truth and meaning in data.  You must be a hands-on engineer with a strong understanding of both data management and governance standards.  You must also have strong interpersonal skills to work cross-functionally across internal teams as well as directly with end users and AIr platform SMEs.   In order to do this job well, you must be a curious and eager problem solver with a hunger for delivering high-quality data solutions.  You have a passion for great work and nothing less than your best will do. You share our intolerance of mediocrity. You’re uber-smart, challenged by figuring things out and producing simple solutions to complex problems. Knowing there are always multiple answers to a problem, you know how to engage in a constructive dialogue to find the best path forward. You’re scrappy. We like scrappy.   This role is a full-time position located out of our office in Pittsburgh, PA.  This role may require up to 10% travel Scope of Responsibilities Define and lead Air's data lifecycle strategy across data acquisition, data ingestion, data cleansing, normalization and linkage.  Ensure key entities within datasets are identified, resolved and linked to existing entities within the current master data repository. Apply various techniques to produce solutions to large-scale optimization problems, including data pre-processing, indexing, blocking, field and record comparison and classification. Improve data sharing, increase data repurposing and improve cost efficiency associated with data management efforts.  Build best practices that help with chain of custody of data so it can be easily traced back to the source for accuracy and consistency. Work across functional teams to understand advanced statistical, machine learning, and text processing models and incorporate them into Air's existing data engineering infrastructure. Perform exploratory data analyses, generate and test working hypotheses, prepare and analyze historical data and identify patterns. Work directly with users as well as SMEs to establish, create and populate optimal data architectures and structures, as well as articulate techniques and results using non-technical language. Qualifications U.S. Citizenship is required Bachelor's degree in Computer Science, Mathematics or a related technical field  Required Skills:  3-5 years experience with programmatically transforming data  Experience with RDBMS Advanced SQL programming skills Proficient usage of common data formats such as CSV, XML, and JSON Requires strong analytical ability and attention to detail Ability to work independently with little supervision A burning desire to tackle hard problems and create sustainable solutions Desired Skills:  Current possession of a U.S. security clearance, or the ability to obtain one with our sponsorship Experience in or exposure to the nuances of...