Data Analyst
CGI is a global IT and business consulting services firm that partners with organizations to solve complex challenges and deliver measurable outcomes. Our collaborative culture brings together diverse expertise, industry insight, and technology capabilities to create lasting value for clients and communities. Join CGI as a Senior Data Analyst supporting complex data, analytics, and information management initiatives within the healthcare payer domain.
About the role
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. This position is located in our Canton, MA office; however, a hybrid working model is acceptable.
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 with requested solutions, 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.
- Independently develops SAS and/or SQL queries, Excel pivot tables, and other analytic tools to explore and summarize results.
- Conducts analyses to support the identification of gaps, variation, and other key performance indicators of reimbursement trends.
- Demonstrates problem-solving aptitude through critique of analytic methodologies and studies.
- Demonstrates strong business problem comprehension by developing analytic use cases (Who? What? Why?) that accurately capture business needs.
- Applies a high level of QA rigor, proactively leveraging peer review and external validation sources.
- Develops documentation and methodologies for analyses and deliverables.
- Meets assigned timelines and escalates risks/barriers as needed.
- Establishes strong business relationships and interfaces with stakeholders collaboratively.
Requirements
- 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.
- 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.
Pay
A reasonable estimate of the current range for this role in the U.S. is $87,600.00 – $153,300.00.
Benefits
- Competitive compensation.
- Comprehensive insurance options.
- Matching contributions through the 401(k) plan and the share purchase plan.
- Paid time off for vacation, holidays, and sick time.
- Paid parental leave.
- Learning opportunities and tuition assistance.
- Wellness and well-being programs.