Financial Data Analyst

Data AnalystAmerican 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.2 to 4 years of experience working with Finance and Accounting business partners or similar environments is highly preferred but not required.A degree in Computer Science, Accounting, Finance or an equivalent major.Experience working with various database systems: SQL Server/PostgreSQL/Redshift/Athena etc.Enjoys collaborating with other engineers on architecture and sharing designs with the team.Experience with design, development, and maintenance of automated test cases for ETL pipelines using tools such as Validatar, QuerySurge, or ICEDQ is preferred.