Senior System Analyst -USC & Green Card Only

Other Jobs To Apply

No other job posts for this day.

Job ID: J1026-1472
Job Title: Senior System Analyst
Job Category: Business Analysis (functional and technical)
Job Type: CTH
Location: Remote FROM - Illinois, Kentucky, Michigan, Wisconsin, Indiana, Louisiana
Openings: 3

Position Description

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

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.


Company Description

Beacon Staffing Alternatives, Inc. is a women-owned, strategic staffing organization that specializes in administrative staffing, IT staffing and logistics support. Headquartered in Central Maryland, Beacon Staffing utilizes state-of-the-art portals enabling employees and job seekers 24-7 online access to resources.

Beacon Staffing promises quality, integrity and reliability. Our personal knowledge and experience in the local community, combined with a contemporary approach to staffing management, makes Beacon Staffing a trusted guide with proven results.

We have maintained professional relationships with some clients for more than two decades. And, we welcome new employers regularly. We are proud to be the area’s most reputable, well-connected and accomplished temporary staffing company.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...