Sr. Business Systems Analyst

Typical Day in the Role

Day to Day responsibilities:

ETL Development & Maintenance:

• Design, develop, and manage complex SSIS packages to automate ETL processes.
• Monitor daily/weekly ETL jobs, troubleshoot failures, and ensure timely data processing.
• Implement advanced data load strategies such as incremental load, change data capture (CDC), and error handling.

• Data Extraction and Transformation:
• Extract large volumes of data from claims, enrollment, encounter, and payment systems.
• Clean, transform, and prepare raw data to ensure data quality and consistency.
• Integrate data from multiple sources, ensuring seamless data flow into downstream systems.
• Claims and Encounter Analytics:
• Analyze encounter and claims data to identify operational inefficiencies and compliance gaps.
• Monitor provider performance by tracking key metrics such as utilization, reject rates, timeliness, and quality of care.
• Work with cross-functional teams to improve encounter submissions and reduce data rejections.
• Power BI Reporting & Visualization:
• Develop interactive Power BI dashboards that provide actionable insights for leadership and stakeholders.
• Create optimized data models and DAX queries to support self-service analytics and improve data visualization.
• Ensure reports align with business and regulatory requirements, ensuring data consistency and accuracy.
• Collaboration & Process Improvement:
• Partner with IT, business, and provider engagement teams to enhance data pipelines and reporting effectiveness.
• Identify gaps in care, submission quality, and operational processes through data analysis.
• Recommend and implement improvements to streamline ETL processes and reporting frameworks.
• Performance expectations: Ensure 100% successful execution of SSIS packages with minimal errors or delays. Meet SLAs for data extraction, transformation, and loading without impacting downstream processes. Maintain high data quality standards by ensuring encounter data meets state and federal compliance guidelines. Deliver accurate and timely reports/dashboards that align with business requirements. Provide actionable insights that drive strategic decision-making.
• Team meets twice a week, contractor will have additional meetings as needed
• Opportunity to convert to Full Time, opportunity to get trained on data technologies (snowflake, CICD pipelines). Tight knit team that values team collaboration.

Candidate Requirements

• Required: Bachelor in math, statistics, information systems, computer science, or related field Preferred: Masters in math, statistics, information systems, computer science, or related field.
• Years of experience required: Minimum 5 years' overall relevant experience, must have SSIS or IICS and Advanced SQL experience and required hard skills listed in section below.
• Disqualifiers: if the resume does not have SSIS or Informatica IICS and advanced SQL I will not consider them
• Additional qualities to look for: Risk adjustment and healthcare knowledge are big plus. Experience with Python to enhance ETL functionality and automate repetitive tasks. Knowledge of scheduling tools (e.g., SQL Agent or Control-M) to manage ETL workflows effectively. Expertise in healthcare models such as claims, encounters, and payments. Hands on Knowledge of regulatory compliance standards (e.g, CMS, DHCS) and healthcare data formats (e.g, EDI 837/835).

• 1 Hands on ETL development experience using SSIS to build, optimize and maintain complex ETL pipelines.
• 2 Strong proficiency in SQL Server, Teradata, stored procedures, and query performance tuning to handle large data sets efficiently.
• 3 2+ years experience developing interactive dashboards and visualizations using Power BI with expertise in DAX and Power Query.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.


It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.



Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.



Qualified applicants in the unincorporated areas of Los Angeles County with criminal histories will be considered for employment in accordance with the Los Angeles County's Fair Chance Ordinance for Employers.



We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.