Data Engineer

ATI builds and manages collaborations that conducts research and development of new technologies to solve our nation's most pressing challenges. Our collaborations are custom-built teams of organizations from industry and academia that develop novel technologies for the federal government. Traditionally, these processes are complicated and burdensome.That's where ATI comes in. We simplify and streamline processes to make it all work. When you work at ATI, you become a part of something larger than yourself. Our collective work - no matter what department or division you work in - ultimately enables the warfighter, saves lives, and diversifies the industrial base.At our core, ATI is a service organization. We are in service to others; it's what we do, and it's who we are.

**This position is FULLY remote within the continentalU.S.**

Apply at ATI.ORG; we only accept applications submitted through our applicant tracking system.

Position Description:

We are seeking an analytical and detail-oriented Data Engineer to join our team. The Data Engineer will play a key role in designing, building, and maintaining robust data infrastructure and pipelines that empower analytics, business intelligence, and strategic decision-making across the organization. This role requires a deep understanding of data architecture, ETL "Extract, Transform, Load" development, and integration of multiple data sources.

Essential Functions

Lead the end-to-end design and development of a data warehouse with external vendor support, including data modeling, ETL pipelines, and integrations from multiple data sources (APIs, databases, etc.)

Collaborate on the development of a forward-looking data strategy, promoting innovation in data infrastructure and analytics.

Partner with multiple internal stakeholders to understand business challenges & identify opportunities for data driven solutions

Design, develop, and manage scalable data pipelines and ETL processes to support analytics, reporting, and data science initiatives.

Develop and optimize SQL queries, stored procedures, and database objects to ensure high performance and data consistency.

Build and maintain data integrations from diverse sources including APIs, databases, and flat files, ensuring reliability and data quality.

Support the development of dashboards and BI tools by ensuring the availability of accurate, well-structured data.

Design and implement data validation, monitoring, and alerting systems to proactively identify and resolve data quality issues.

Perform exploratory data analysis and statistical analysis to support business decisions.

Create and maintain processes to generate accurate and timely reports that help stakeholders understand and act on key data insights.

Develop tools and frameworks to support automated extraction of large volumes of data from websites or other digital sources

Assist in data governance efforts to ensure data integrity and consistency.

Contribute to internal documentation and provide training to team members on data systems, tools, and best practices.

Work collaboratively with cross-functional team to test and validate new reporting/modeling features

Effectively display data for decision making.

Additional Responsibilities

Performs other duties as assigned.

Qualifications

• Bachelor's degree in Data Science, Analytics, Computer Science, Information Systems, or a related technical field; Master's degree or relevant certifications (e.g., AWS, Azure, Google Cloud) are a plus.
• 5+ years of professional experience in data engineering or a related field, with a strong track record of building scalable data solutions.
• Expert-level proficiency in SQL for data extraction, transformation, and performance tuning.
• Hands-on experience with relational databases (e.g., PostgreSQL, SQL Server, MySQL) and building or maintaining enterprise data warehouses.
• Familiarity with modern data pipeline tools and orchestration frameworks (e.g., Apache Airflow, dbt, Talend).
• Proficiency in scripting languages like Python for data analysis is a plus.
• Experience working with cloud-based data platforms (e.g., MS Azure) is highly desirable.
• Proficient in data modeling, normalization, and schema design best practices.
• Proficiency in Power BI, Tableau, or similar visualization tool.
• Proven work history as a Data Engineer.
• Advanced proficiency in Excel.
• Preferred previous experience with government and/or DoD entities.
• Adept at managing change and fostering innovation in a complex organizational landscape.
• Strong analytical and problem-solving skills with the ability to interpret complex data sets and derive actionable insights.
• Strong attention to detail and ability to work collaboratively in a cross-functional setting.
• This position will need the ability to access US only data systems - US Citizenship is required.
• This position is subject to a background check that includes a review of criminal records. In reviewing an applicant's criminal history, the company will consider prior criminal convictions that have a relationship to the job duties and responsibilities of the position. The company considers the nature of the crime, the time that has elapsed since the crime and the job duties for the position at issue in making an individualized determination. Individuals may be excluded when the company determines, based on the above factors, that hiring, transferring or promoting the applicant would pose an unreasonable risk to the business, its employees or its customers and vendors.
• If you are a qualified candidate, we encourage you to apply even if you have a prior criminal conviction(s). Convictions will not automatically disqualify the candidate, However, conviction(s) will be considered and balanced against the age of the candidate at the time of the offense, time elapsed since the offense, type of offense, potential impacts of such on the work environment, sensitivity of the position(s) available/sought, and similar independent factors relevant to the employment requirements at ATI.

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Regular physical activity to include walking, bending, stooping, reaching, standing and prolonged sitting.

Ability to speak, read, hear, and write, with or without reasonable accommodation.

Ability to use phone and computer systems, copier, fax, and other office equipment.

Must be able to occasionally move/lift up to 25 pounds with or without reasonable accommodation.

Work Environment

This position is located in an air-conditioned, environmentally controlled atmosphere. Noise level in the work environment is usually moderate and the distraction level in the work environment is often heavy.

ATI is an Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individual with Disabilities.

ATI complies with the Pay Transparency Nondiscrimination provision mandated by Executive Order 13665.

Apply at ATI.ORG; we only accept applications submitted through our applicant tracking system. If you require accommodations to complete this application, please contact Human Resources at (843) 760-4350or email hr@ati.org.

Anticipated salary is in range commensurate with education and experience:
$105,000 - $115,000