Financial Data Analyst

TechDigital Group; Reston (VA); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading organization in healthcare analytics seeks a skilled Data Analyst in Reston, Virginia. This position involves strategic ERP implementation, data migration, and ensuring data integrity across systems. The ideal candidate will have 3-6 years of experience in Data Analysis, proficiency in SQL, and familiarity with Cloud services. Join a team that values innovation and quality while working with cutting-edge technologies like AWS Glue and S3.

Qualifications

• 3 to 6 years designing, developing, and optimizing SQL queries to manipulate large datasets.
• 3 to 6 years of experience in Data Analysis or related roles.
• 1 to 2 years experience in Python for scripting, automation, and advanced data analysis.
• 1+ years of Cloud experience.

Responsibilities

• Collaborate with finance and accounting teams to understand data requirements.
• Ensure accurate migration and integration of data.
• Act as a liaison between technical teams and business stakeholders.
• Test and validate data migration using SQL.
• Design and develop ETL scripts for data prep and analysis.

Skills

SQL queries

Data Analysis

Python scripting

Cloud computing

Data validation

ETL development

Tools

AWS Glue

AWS S3

Amazon Redshift

SQL

Job description

American College of Radiology (ACR) is a progressive membership organization representing nearly
40,000 medical specialists in radiological care. As a member of our team, you will join a world leader in patient-centered care advocacy, policy and clinical research, quality and safety. Our culture encourages
innovation, diversity, integrity and leadership. A nonprofit 501(c)(3), ACR (the American College of
Radiology) has over 500 purpose-driven employees in the Greater Washington, DC and Philadelphia
region.
If you share our core values of: Leadership • Integrity • Quality • Innovation, we want you on our team!

We are seeking a highly skilled and motivated Data Analyst to join our team. This role is focused on
strategic ERP implementation, data migration, and integration validation. You will work closely with
finance and accounting teams and other stakeholders to ensure accurate data movement and integrity
across systems. Experience with ERP platforms such as NetSuite and data migration/integration projects
is highly desirable.

Major technologies involved include S3, AWS Glue, Step Functions, Lambda Functions, Amazon Athena,
Redshift and RDS.

Skills and Responsibilities

• Collaborate with finance and accounting teams to understand data requirements and ensure
  accurate migration and integration.
• Collaborate with business units for data file generation in specific formats and perform data
  validation after files are uploaded into a system.
• Act as a liaison between technical teams and business stakeholders, ensuring clear
  communication and alignment on project goals.
• Test or assist with testing fidelity of data migration from one system to another using SQL and
  related tools.
• Design & Develop complex ETL Scripts in Glue or SQL for data prep & analysis.
• Collaborate with product managers and other engineers to implement and document complex
  and evolving requirements.
• Research and implement innovative solutions to solve challenges related to ETL, data cleanup,
  and analysis.
• Ability to debug complex data issues without frequent guidance from senior team members.
• Developing techniques to work with both tabular and hierarchical data.
• Strong attention to detail, good work ethic, ability to work on multiple workstreams
  simultaneously, and good communication skills.

Required Skills

• 3 to 6 years designing, developing, and optimizing SQL queries to extract and manipulate large datasets from relational databases.
• 3 to 6 years of experience working in Data Analysis or related roles.
• 1 to 2 years experience in Python for scripting, automation, and advanced data analysis.
• 1+ years of Cloud experience required.