Data Analyst

APN Consulting, Inc. is an IT staffing and services company providing technology solutions in data, cloud, AI/ML, and related areas. The Data Analyst will support client reporting through data extracts, aggregate reporting, SQL-based investigation, automated file deliveries, data validation, and analysis of sensitive healthcare application data.

Responsibilities:

• Pick up assigned Jira tickets spanning client data-extract delivery/troubleshooting and portfolio-level or custom aggregate reporting
• Write, troubleshoot, and optimize SQL queries against Redshift and MySQL to investigate data issues, build reports, and fulfill one-off and recurring data requests
• Build and maintain automated file deliveries using Jenkins, including writing and editing YAML configuration files
• Develop reporting logic, data validation, and analysis using Python and/or R
• Investigate data discrepancies reported by internal stakeholders or clients and communicate findings clearly
• Work within our healthcare application data environment — including telemedicine consult data and chronic-condition management program data — with the care and attention to accuracy that entails

Requirements:

• Strong SQL skills, with hands-on experience in Redshift and MySQL
• Ability to read and write YAML configuration files
• Familiarity with Jenkins or similar CI/automation tooling for building and maintaining automated data pipelines
• Proficiency in Python and/or R for data analysis and reporting
• Comfort working with large-scale, sensitive data in a production environment
• Prior experience with healthcare or health-tech application data specifically
• Familiarity with Control-M or similar job-scheduling tools
• Familiarity with Snowflake (limited use expected in this environment, but a plus)