Business System Analyst

ITCO Solutions, Inc. is seeking a Business System Analyst to support enterprise data management, Big Data platforms, and cloud-based data engineering solutions. The role translates business requirements into technical specifications and develops, supports, and optimizes data pipelines and integrations.

Responsibilities:

• Analyze, design, develop, and support enterprise data management solutions, Big Data platforms, ETL and ELT pipelines, and data integration processes
• Collaborate with business stakeholders, data architects, and engineering teams to gather requirements and translate business needs into functional and technical specifications
• Perform system analysis, impact assessments, gap analysis, data mapping, and source to target transformation analysis
• Develop and enhance large scale data processing solutions using Databricks, Apache Spark, PySpark, Python, Hadoop, HDFS, Hive, and Azure Data Factory
• 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, including activities, triggers, parameters, and dependencies
• Develop and optimize complex SQL queries, stored procedures, data transformations, and source to target mapping specifications
• Develop and maintain ETL workflows using SSIS and modern cloud based data integration technologies
• Create 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, Azure Data Factory, and Databricks Workflows
• Perform data profiling, validation, reconciliation, root cause analysis, and troubleshooting to ensure data accuracy, completeness, and integrity
• 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 throughout solution development, testing, and release activities
• Participate in Agile and Scrum ceremonies, including sprint planning, backlog refinement, daily stand ups, sprint reviews, and retrospectives
• Support production deployments, incident investigation, defect resolution, change management, and post deployment validation

Requirements:

• 8+ years of experience in Systems Analysis, Data Engineering, Big Data Development, ETL/ELT, or enterprise data integration
• Strong hands on experience with Python, PySpark, Apache Spark, SQL, Databricks, and Azure Data Factory
• 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 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, User Acceptance Testing, production deployments, and incident resolution
• Experience working in Agile and 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
• Knowledge of 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