Position Description:

Make an impact like never before.

We're growing rapidly and are looking for a Business System Analyst.

This remote can be worked remotely from Illinois, Kentucky, Michigan, Wisconsin, Indiana, Louisiana.

We're a close knit team that has access to global resources. You'll have the opportunity to explore a wide range of industries, technologies, and geographies, all while enjoying the personal touch that our local operating approach offers.

Growth at CGI is driven by your goals, so if you're looking for an inclusive place where you're empowered to chart your own path, then we'd love to meet you.

Your future duties and 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.

Required qualifications to be successful in this role:

• 8+ years of experience in Systems Analysis, Data Engineering, Big Data Development, ETL/ELT, or enterprise data integration, including experience analyzing complex data management solutions.

• Strong hands on experience with Python, PySpark, Apache Spark, SQL, Databricks, and Azure Data Factory (ADF).

• 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.

Desired qualifications:

• 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.

Other Information: CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $79,600.00 - $156,700.00.

CGI's benefits are offered to eligible professionals on their first day of employment to include:

• 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

For more detailed information about our benefits offerings visit Benefits | CGI Careers

Please note that the benefits listed above are subject to change based on the specific terms and conditions of the contract being supported.

CGI anticipates accepting applications for this position through 2026 11 27. #LI-AH9 #Remote

Skills:

• Big Data,Analytics&Operations

• Business Analysis

• Databricks

• ETL

• Python

• SQL

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our team—one of the largest IT and business consulting services firms in the world.

Qualified applicants will receive consideration for employment without regard to their race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, pregnancy, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity, and gender expression, familial status or responsibilities, reproductive health decisions, political affiliation, genetic information, height, weight, or any other legally protected status or characteristics to the extent required by applicable federal, state, and/or local laws where we do business.

CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S., please email the CGI U.S. Employment Compliance mailbox at US_Employment_Compliance@cgi.com. You will need to reference the Position ID of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a Position ID will not be returned.

We make it easy to translate military experience and skills! Click here to be directed to our site that is dedicated to veterans and transitioning service members.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary dependent upon specific assignment and/or level of US government security clearance held. Dependent upon role and/or federal government security clearance requirements, and in accordance with applicable laws, some background investigations may include a credit check. CGI will consider for employment qualified applicants with arrests and conviction records in accordance with all local regulations and ordinances.

CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI’s legal duty to furnish information.