← Back to jobsJob ID col-cmwf7fnl40bv789hqiqv8f1rf

CGIPosted 7 days ago

Senior Technical Business Systems Analyst - Healthcare Payor Specialized

Full-time
Remote
10+ years
$82K – $143K/yr
Posted 7 days ago

CGI is hiring a Senior Technical Business Systems Analyst to analyze, design, develop, and support enterprise data management solutions and data integration platforms. The role translates business needs into functional and technical specifications and supports data pipelines, platform performance, testing, and production operations, with a focus on healthcare payor data.

Posted
7 days ago
Source
cgi.njoyn.com
Sector
Consulting

Opens the employer's application page in a new tab

Responsibilities

  • Analyze, design, develop, and support enterprise data management solutions, Big Data platforms, ETL/ELT pipelines, and data integration processes
  • Collaborate with business stakeholders, data architects, and engineering teams to gather, analyze, and translate business requirements into functional and technical specifications
  • Perform system analysis, impact assessments, gap analysis, data mapping, and source to target transformation analysis across enterprise data platforms
  • Design, develop, and enhance large scale data processing solutions using Databricks, Apache Spark, PySpark, Python, Hadoop/HDFS, Hive, and Azure Data Factory (ADF)
  • Analyze and support Databricks notebooks, Spark jobs, Delta Lake tables, and Lakehouse data processing workflows
  • Design and maintain data ingestion, transformation, and integration pipelines using Azure Data Factory (ADF), including activities, triggers, parameters, and dependencies
  • Develop and optimize complex SQL queries, stored procedures, data transformations, and source to target mapping specifications
  • Analyze, develop, and maintain ETL workflows using SSIS and modern cloud based data integration technologies
  • Develop and maintain reusable Python, PySpark, and Unix/Linux Shell Scripts for data processing, automation, validation, and operational support
  • Analyze data integration requirements across relational databases, APIs, files, cloud storage, and enterprise applications
  • Support batch processing, job scheduling, dependency management, and workflow orchestration using Control M, ADF, and Databricks Workflows
  • Perform data profiling, validation, reconciliation, root cause analysis, and troubleshooting to ensure data accuracy, completeness, and integrity
  • Analyze and optimize Spark jobs, Databricks workloads, SQL queries, and data pipelines for performance, scalability, and reliability
  • Prepare functional specifications, technical design documents, data mapping documents, process flows, and system integration documentation
  • Collaborate with developers, QA teams, Product Owners, Scrum Masters, and architects to support solution development, system testing, integration testing, and release activities
  • Participate in Agile/Scrum ceremonies, including sprint planning, backlog refinement, daily stand ups, reviews, and retrospectives
  • Support production deployments, incident investigation, defect resolution, change management, and post deployment validation to maintain enterprise data platform stability

Qualifications

  • 10+ years of experience in Systems Analysis, Data Engineering, Big Data Development, ETL/ELT, or enterprise data integration, including experience analyzing complex data management solutions
  • U.S. healthcare payor, Medicare/Medicaid experience, including claims, member enrollment, eligibility, provider, and healthcare data management
  • Understanding of Python, PySpark, Apache Spark, SQL, Databricks, and Azure Data Factory (ADF) code
  • Experience handling API request and response using Postman and JSON
  • Experience analyzing, designing, developing, and supporting enterprise scale data processing applications and ETL/ELT pipelines
  • Strong experience gathering business and technical requirements, performing system impact analysis, documenting functional specifications, and developing source to target data mappings
  • Hands on experience with Azure Data Factory (ADF) for data ingestion, transformation, integration, and workflow orchestration
  • Experience with Hadoop ecosystem technologies, including Hadoop/HDFS and Hive
  • Strong SQL skills, including complex queries, stored procedures, data transformations, reconciliation, and performance optimization
  • Experience developing, analyzing, and supporting ETL workflows using SSIS
  • Experience with Unix/Linux Shell Scripting and enterprise job scheduling tools such as Control M
  • Strong understanding of Delta Lake, Databricks Workflows, Lakehouse architecture, data warehousing, data modeling, and enterprise data integration
  • Experience with data profiling, data validation, source to target reconciliation, data quality, troubleshooting, and root cause analysis
  • Experience preparing business requirements, functional specifications, technical documentation, data flow diagrams, and system integration specifications
  • Experience supporting application development, integration testing, UAT, production deployments, and incident resolution
  • Experience working in Agile/Scrum environments with strong analytical, problem solving, stakeholder communication, and cross functional collaboration skills

Preferred

  • Experience with Azure cloud services, including ADLS Gen2, Azure Synapse Analytics, and Azure DevOps
  • Experience with AWS services, including S3, Glue, EMR, Lambda, and Redshift
  • Knowledge of Kafka, Airflow, Java/Scala, Git, Jenkins, and CI/CD pipelines
  • Experience with Power BI, SSRS, Tableau, or other enterprise reporting and analytics tools
  • Experience with data governance, metadata management, data lineage, data quality frameworks, and enterprise data management practices
  • Prior experience supporting large scale enterprise data platforms in healthcare, insurance, or other regulated industries
  • Healthcare industry experience
  • Insurance industry experience
  • Regulated industry experience

Required skills

Apache SparkAzure Data FactoryDatabricksDelta LakeHadoop/HDFSHealthcare Payor DataHivePySparkPythonSQLSSISUnix/Linux Shell Scripting

Full job description

CGI is hiring a Senior Technical Business Systems Analyst to analyze, design, develop, and support enterprise data management solutions and data integration platforms. The role translates business needs into functional and technical specifications and supports data pipelines, platform performance, testing, and production operations, with a focus on healthcare payor data.

Responsibilities

  • Analyze, design, develop, and support enterprise data management solutions, Big Data platforms, ETL/ELT pipelines, and data integration processes
  • Collaborate with business stakeholders, data architects, and engineering teams to gather, analyze, and translate business requirements into functional and technical specifications
  • Perform system analysis, impact assessments, gap analysis, data mapping, and source to target transformation analysis across enterprise data platforms
  • Design, develop, and enhance large scale data processing solutions using Databricks, Apache Spark, PySpark, Python, Hadoop/HDFS, Hive, and Azure Data Factory (ADF)
  • Analyze and support Databricks notebooks, Spark jobs, Delta Lake tables, and Lakehouse data processing workflows
  • Design and maintain data ingestion, transformation, and integration pipelines using Azure Data Factory (ADF), including activities, triggers, parameters, and dependencies
  • Develop and optimize complex SQL queries, stored procedures, data transformations, and source to target mapping specifications
  • Analyze, develop, and maintain ETL workflows using SSIS and modern cloud based data integration technologies
  • Develop and maintain reusable Python, PySpark, and Unix/Linux Shell Scripts for data processing, automation, validation, and operational support
  • Analyze data integration requirements across relational databases, APIs, files, cloud storage, and enterprise applications
  • Support batch processing, job scheduling, dependency management, and workflow orchestration using Control M, ADF, and Databricks Workflows
  • Perform data profiling, validation, reconciliation, root cause analysis, and troubleshooting to ensure data accuracy, completeness, and integrity
  • Analyze and optimize Spark jobs, Databricks workloads, SQL queries, and data pipelines for performance, scalability, and reliability
  • Prepare functional specifications, technical design documents, data mapping documents, process flows, and system integration documentation
  • Collaborate with developers, QA teams, Product Owners, Scrum Masters, and architects to support solution development, system testing, integration testing, and release activities
  • Participate in Agile/Scrum ceremonies, including sprint planning, backlog refinement, daily stand ups, reviews, and retrospectives
  • Support production deployments, incident investigation, defect resolution, change management, and post deployment validation to maintain enterprise data platform stability

Preferred

  • Experience with Azure cloud services, including ADLS Gen2, Azure Synapse Analytics, and Azure DevOps
  • Experience with AWS services, including S3, Glue, EMR, Lambda, and Redshift
  • Knowledge of Kafka, Airflow, Java/Scala, Git, Jenkins, and CI/CD pipelines
  • Experience with Power BI, SSRS, Tableau, or other enterprise reporting and analytics tools
  • Experience with data governance, metadata management, data lineage, data quality frameworks, and enterprise data management practices
  • Prior experience supporting large scale enterprise data platforms in healthcare, insurance, or other regulated industries
  • Azure cloud services
  • ADLS Gen2
  • Azure Synapse Analytics
  • Azure DevOps
  • AWS services
  • Amazon S3
  • AWS Glue
  • Amazon EMR
  • AWS Lambda
  • Amazon Redshift
  • Kafka
  • Apache Airflow
  • Java
  • Scala
  • Git
  • Jenkins
  • CI/CD pipelines
  • Power BI
  • SSRS
  • Tableau
  • Enterprise reporting tools
  • Analytics tools
  • Data governance
  • Metadata management
  • Data lineage
  • Data quality frameworks
  • Enterprise data management
  • Enterprise data platforms
  • Healthcare industry experience
  • Insurance industry experience
  • Regulated industry experience

Benefits

  • Competitive compensation including profit participation program
  • Comprehensive medical, dental, and vision benefits
  • Basic life and accidental death & dismemberment insurance
  • Matching contributions through 401(k) plan, and CGI share purchase plan
  • Flexibility and paid accrued vacation leave, ranging from 10 to 20 days per year, based on job level, years of relevant prior experience, and years of service
  • 10 paid holidays per year
  • At least 80 consecutive hours of paid sick/safe leave (except where applicable state/local law requires more)
  • Paid parental leave, ranging from 20 to 70 consecutive business days based on circumstances of leave and applicable laws
  • Bereavement leave, ranging from 1 to 7 days per year based on relationship.
  • Paid jury duty leave, up to time summoned
  • Learning opportunities and tuition assistance
  • Wellness and Well being programs
  • Hybrid work model offering flexibility to balance professional and personal priorities.
  • Remote work in the United States

Company

  • IT and business consulting services firm
  • Montréal, Quebec, CAN
  • https://www.cgi.com/
  • Founded in 1976
  • 10001+ employees

Qualifications

  • 10+ years of experience in Systems Analysis, Data Engineering, Big Data Development, ETL/ELT, or enterprise data integration, including experience analyzing complex data management solutions
  • U.S. healthcare payor, Medicare/Medicaid experience, including claims, member enrollment, eligibility, provider, and healthcare data management
  • Understanding of Python, PySpark, Apache Spark, SQL, Databricks, and Azure Data Factory (ADF) code
  • Experience handling API request and response using Postman and JSON
  • Experience analyzing, designing, developing, and supporting enterprise scale data processing applications and ETL/ELT pipelines
  • Strong experience gathering business and technical requirements, performing system impact analysis, documenting functional specifications, and developing source to target data mappings
  • Hands on experience with Azure Data Factory (ADF) for data ingestion, transformation, integration, and workflow orchestration
  • Experience with Hadoop ecosystem technologies, including Hadoop/HDFS and Hive
  • Strong SQL skills, including complex queries, stored procedures, data transformations, reconciliation, and performance optimization
  • Experience developing, analyzing, and supporting ETL workflows using SSIS
  • Experience with Unix/Linux Shell Scripting and enterprise job scheduling tools such as Control M
  • Strong understanding of Delta Lake, Databricks Workflows, Lakehouse architecture, data warehousing, data modeling, and enterprise data integration
  • Experience with data profiling, data validation, source to target reconciliation, data quality, troubleshooting, and root cause analysis
  • Experience preparing business requirements, functional specifications, technical documentation, data flow diagrams, and system integration specifications
  • Experience supporting application development, integration testing, UAT, production deployments, and incident resolution
  • Experience working in Agile/Scrum environments with strong analytical, problem solving, stakeholder communication, and cross functional collaboration skills
  • Experience with Azure cloud services, including ADLS Gen2, Azure Synapse Analytics, and Azure DevOps
  • Experience with AWS services, including S3, Glue, EMR, Lambda, and Redshift
  • Knowledge of Kafka, Airflow, Java/Scala, Git, Jenkins, and CI/CD pipelines
  • Experience with Power BI, SSRS, Tableau, or other enterprise reporting and analytics tools
  • Experience with data governance, metadata management, data lineage, data quality frameworks, and enterprise data management practices
  • Prior experience supporting large scale enterprise data platforms in healthcare, insurance, or other regulated industries
  • 10+ years of experience in Systems Analysis, Data Engineering, Big Data Development, ETL/ELT, or enterprise data integration, including experience analyzing complex data management solutions.

Required skills

  • Apache Spark, Azure Data Factory, Databricks, Delta Lake, Hadoop/HDFS, Healthcare Payor Data, Hive, PySpark, Python, SQL, SSIS, Unix/Linux Shell Scripting

Experience

  • 10+ years

Job details

Employment type

Full-time

Seniority level

10+ years

Sector · Sub-sector

Consulting · IT Consulting

Date posted

Nov 13, 2026

Work mode

Remote

Job source

cgi.njoyn.com

Company

CGI

Consulting

IT and business consulting services firm

See all 13 jobs from CGI →
  • United States
  • Consulting
  • 10001+ employees
  • Founded 1976
  • cgi.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Business Analyst jobs

Precision Technologies

4d ago

Senior Business Analyst – Banking Payments & Digital Assets

Full-timeRemoteUnited StatesCompetitive

Lead business requirements gathering, analysis, and documentation for banking and payment transformation initiatives Analyze paymen

Why similarSame role

Dice

4d ago

Retirement Service Subject Matter Expert (SME) - Business Analyst Experience

Full-timeRemoteUnited StatesCompetitive

Systems Engineering Services is recruiting for an unnamed client that is integrating an acquired company’s data and systems into its IT ecosystem.

Why similarSame role

Vtechys

4d ago

Technical Business/Data Analyst

Full-timeOn-siteNew York, NYCompetitive

The hiring company is not identified. The Technical Business/Data Analyst bridges business stakeholders and technology teams, translating business needs into implementable solutions and supporting successful delivery of business capabilities.

Why similarSame roleSQL

Get new Business Analyst jobs by email

Create job alert

Senior Technical Business Systems Analyst - Healthcare Payor Specialized

CGI · $82K – $143K/yr

Apply on company site