Data Analyst

ITCO Solutions, Inc.; Canton (MA); Hybrid; USD 110,000 - 140,000; Full time

Job summary

ITCO Solutions, Inc. seeks a Senior Data Analyst to support complex data, analytics, and information management initiatives in the healthcare payer domain. You will partner with business leaders, technical teams, and vendors to translate needs into scalable analytic solutions and improve data quality.

The role requires independent design and execution of analyses, documentation, testing support, and resolution of data and production issues across departments.

Qualifications

• Bachelor's degree in information systems, computer science, or related field.
• 7+ years of data analysis in a healthcare payer environment.
• Experience migrating provider data between enterprise systems in payor settings.
• Advanced SQL, PL/SQL, and Oracle; complex queries and analyses.
• 5+ years ETL and data engineering experience.
• 5+ years working with Teradata.
• 7+ years in functional analysis, gap analysis, and requirements.
• Experience writing technical specs, use cases, test cases, and plans.

Responsibilities

• Collaborates with internal business and external vendors on analytic assignments.
• Creates a technology roadmap with business leadership across departments.
• Documents requirements, rules, data standards, and specs for solutions.
• Develops design recommendations aligned with architectural standards and privacy rules.
• Facilitates design reviews with governing committees.
• Plans and implements complex solution designs, including reports and analyses.
• Develops and trains IT and business staff on test strategies and plans.
• Maintains core reference data content via master data management tools.
• Initiates data remediation projects to address prioritized issues.
• Monitors production of information management solutions for error-free performance.
• Performs root-cause analyses and documents modifications.
• Develops analytic use cases and QA rigor with peer reviews.
• Creates documentation and methodologies for analyses and deliverables.
• Meets timelines and escalates risks when needed.
• Builds strong business relationships and collaborates with stakeholders.

Skills

Advanced SQL

PL/SQL

Oracle

ETL

Data engineering

Teradata

SAS

Stakeholder mgmt

Healthcare payer domain

Education

Bachelor's degree in Information Systems, CS, Healthcare Informatics, or related field

Tools

Teradata Studio

SQL Developer

Job description

Position Title: Data Analyst

Location: Canton, MA client site (Hybrid)

Canton, MA is preferred, but remote will be accepted.

Position Description

As a Senior Data Analyst supporting complex data, analytics, and information management initiatives within the healthcare payer domain. In this role, you will partner with business leaders, technical teams, and external vendors to translate business needs into scalable analytical solutions, strengthen data quality, and deliver actionable insights. You will independently design and execute analyses, develop technical and functional documentation, support solution testing, and help resolve complex data and production issues.

Your future duties and responsibilities

• Collaborates with internal business and external vendor constituents to conduct analytic assignments in support of requested business solution(s).
• Creates a technology roadmap in support of a business strategy with business leadership across multiple departments.
• Ensures that appropriate requirements, associated business rules and data standards, and technical specifications for requested solutions are documented.
• Develops design recommendations commensurate of requested solution, ensuring recommendations comply with corporate architectural standards and federal and state regulations and/or mandates pertaining to the privacy and security of the company's core data assets.
• Facilitates review of design with governing committees.
• Plans, develops, and implements solution designs of significant scope and complexity.
• Solutions may include application or extract program code, production reports and analytic finding reports. Independently develops solutions of considerable scope and complexity.
• Develops and trains IT and business personnel on test strategies, plans, and scripts and executes test procedures to ensure compliance of developed solution with documented specifications. Reports test results to project stakeholders.
• Collaborates to maintain core reference domain content via master data management tools. Monitors core dataset quality thresholds to identify dataset content issues that require resolution.
• Initiates and manages constituent specific data remediation projects to resolve prioritized issues.
• Monitors production processes of previously implemented information management solutions to proactively achieve error free performance standards.
• Performs analysis to establish root cause(s) of identified issues through implementation and documentation of necessary modifications.
• Perform out of the box thinking, collaborate with others, and make a difference every day!
• Independently develop SAS and/or SQL queries, Excel pivot tables, and other analytic tools to explore and summarize results
• Conduct other analyses as needed to support the identification of gaps, variation, and other key performance indicators of reimbursement trends
• Demonstrate problem solving aptitude through critique of analytic methodologies and studies
• Demonstrate strong business problem comprehension, by developing analytic use cases (Who? What? Why?) that accurately capture business needs
• Apply a high level of QA rigor, proactively leveraging peer review and external validation sources
• Develop documentation and methodologies for analyses and deliverables
• Meets assigned timelines and escalates risks/barriers as needed
• Establish strong business relationships, and interface with stakeholders collaboratively

Required qualifications to be successful in this role

• Bachelor's degree in Information Systems, Computer Science, Healthcare Informatics, or a related field
• 7+ years of data analysis experience within a healthcare payer environment
• Experience with provider data migration between enterprise system in a healthcare payor setting
• Advanced SQL, PL/SQL, and Oracle skills, including experience developing complex queries and analytical solutions
• 5+ years of hands on ETL and data engineering experience
• 5+ years of experience working with Teradata
• 7+ years of experience performing functional analysis, gap analysis, and business requirements definition
• Experience developing technical specifications, analytical use cases, test cases, and test plans
• Strong quality assurance, problem solving, documentation, and stakeholder collaboration skills