Vacancy Name
Data Engineer

Vacancy No
VN733

Employee Type
Full-time

Location City
Summerville

Education Level
Bachelor's Degree

Experience Level
5 years

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.

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

Benefits
ATI has been named "Best Places to Work in SC" from 2017 - 2025.

This is a full-time opportunity with benefits
ATI provides Medical, Dental and Vision Plan options
Flexible Spending Accounts, including health and dependent care accounts
403B Retirement Savings plan with a very competitive company contribution
Personal time-off (pre-loaded & accrued) plus 12 paid holiday-days
Life Insurance paid by ATI
Paid Parental Leave
Short-Term & Long-Term Disability Coverage paid by ATI
Employee Assistance Program
Tuition Reimbursement Program
Flexible work schedules

ATI's standard business hours are Monday-Friday, between 8 AM - 5 PM.