Sr. Business Systems Analysts

Design, develop, and enhance large scale data processing solutions using Databricks, Apache Spark, PySpark, Python, Hadoop/HDFS, Hive, and Azure Data Factory (ADF). Strong understanding of Delta Lake, Databricks Workflows, Lakehouse architecture, data warehousing, data modeling, and enterprise data integration.

A leading Consulting Firm is seeking a Senior Business Systems Analyst - Healthcare Payor Specialized, for a 6+ month contract to hire role. Position Description Location preference is Chicago, IL, Richardson, TX, Lafayette, LA, and Nashville, TN. This role can be worked remotely in the United States. 1. Impactful Work . You'll be at the forefront of delivering strategic consulting solutions that shape business outcomes for leading organizations. . Opportunity to work on diverse, high impact projects that challenge your thinking and expand your expertise. 2. Growth & Development . Clear career progression with access to leadership mentoring and professional development programs. . Exposure to cutting edge technologies and methodologies that keep you ahead in the consulting space. 3. Collaborative Team Environment . Join a team of seasoned professionals who value knowledge sharing, innovation, and collaboration. . A culture that encourages open communication, mutual respect, and continuous learning. 4. Flexible & Supportive Work Environment . Hybrid work model offering flexibility to balance professional and personal priorities. . Strong emphasis on work life balance and employee well being. 5. Inclusive Culture . Diversity and inclusion are core values-your voice matters here. . Opportunities to participate in employee resource groups and community initiatives. 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 . 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. . 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. . 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. Desired 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.