Business System Analyst
itco solutionsEvanston (IL)
Business System Analyst
Posted yesterday
itco solutionsEvanston (IL)
SENIORITY
Lead
About the role
Business System Analyst
Location: 100% Remote
Eligible States: Illinois, Kentucky, Michigan, Wisconsin, Indiana, and Louisiana
Experience: 8+ Years
Contract to Hire: H1b sponsorship after 3-6 months
Position Overview:
We are seeking an experienced Business System Analyst with strong technical expertise in enterprise data management, Big Data platforms, and cloud based data engineering solutions. This is an exciting opportunity to join a close knit team with access to global resources and exposure to a wide range of industries, technologies, and enterprise data environments. The ideal candidate will combine strong analytical and technical skills with the ability to translate complex business requirements into scalable data solutions. Our team values collaboration, innovation, professional growth, and an inclusive environment where individuals are empowered to make an impact.
Key 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.
Required Qualifications:
- 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.
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.
- 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.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.