Data Analyst II

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 offers a hybrid schedule (in-office & remote/work from home) or an onsite schedule and flexible hours. Candidates will need to reside near Summerville, SC to ensure work site flexibility.**

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 Analyst (DA) II to join our team. The DA will play a key role in analyzing and interpreting complex data sets to support business decisions and strategic intiatives. You will be responsible for writing optimized SQL queries, developing automated reports and dashboards, and working closely with stakeholders across various teams to provide actionable insights. This role requires a deeper understanding of data structures, statistical analysis, and business intelligence tools to drive data-driven decision-making.

Essential Functions

Extract, clean, and analyze large datasets to identify trends and insights.

Write complex SQL queries, create views, and optimize database queries for performance.

Utilize APIs to pull, transform, and analyze external and internal data sources.

Develop and maintain dashboards and reports using Power BI or other visualization tools.

Collaborate with business teams to define key performance indicators and reporting requirements.

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.

Design scripts and tools to automatically extract large volumes of data from websites or other digital sources

Gather data from various sources, including databases, APIs, and third-party sources and ensure the upkeep of databases and data systems.

Assist in data governance efforts to ensure data integrity and consistency

Work with data engineers to improve data pipelines and ETL processes.

Assist in maintaining reporting dashboards to automate data sharing

Assist with development of new dashboards as needed and training to team members on how to use reporting and data tools effectively

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, IT or Statistics preferred, Computer Science, or any related field and three to five years of related professional experience
• Proficiency in SQL for querying and manipulating data.
• Experience working with relational databases and data warehouses.
• Basic understanding of scripting languages like Python for data analysis is a plus.
• Proficiency in data visualization
• Proficiency in Power BI, Tableau, or similar visualization tool.
• Proven work history as a data analyst
• Advanced proficiency in Excel
• 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.

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:
$115,000 to $125,000