Lead Systems Analyst

2 weeks ago


Chicago, United States w3r Consulting Full time
General Information:
  • Most of our projects are in the backend data warehouse environment. Data pipeline, data analysis / profiling and strong SQL skills are essential. Data modeling, ETL, data governance knowledge / experience is great. Along with several soft skills necessary to succeed in such as communication (verbal / written), vendor management, initiative, flexibility, etc.
  • A typical Business Analyst or front-end person is not what we are looking for. However, they can have some of those skillsets / experience.
  • A technical business analyst or data analyst, data engineer perhaps..
  • Definitely more technical but must be able to communicate with all levels and areas and translate business requirements into the functional and technical requirements.
Non-Negotiables:

1) Experience with databases and SQL (Prefer DB2); ETL exposure (preferably AbInitio); Reporting system exposure (preferably Cognos)
2) Data Modeling, Data analysis, data profiling and data manipulation skills.
3) Experience with implementing ETL systems and reporting systems / data warehouses and data marts
4) Experience in exploring and writing functional requirements with business/tech teams. Example documents: Functional Requirements Specifications (FRS), Requirements Traceability Matrix (RTM), Source to Targets (S2Ts), Data Exchange Documents (DEDs), and Data Models.
5) Good communication skills - written and spoken.

Required Basic Qualifications:
  • Bachelors Degree in Computer Science, Information Systems, Business Administration or equivalent work experience.
  • Minimum 7 years of IT work experience including application system design and implementation.
  • Experience with the following technology stack: Cognos, Tableau, XML, SQL, Ab-Initio, DB2, Oracle
  • Knowledge of multiple development methodologies.
  • Experience with the following: Data Warehousing, Business Intelligence, Data Marts, Data profiling, Data Quality analysis and Data Analytics.
  • Advanced SQL query and experience in a data analyst role with strong data analysis and analytical skills
  • Minimum 3 years of database modeling including one or more of the following: DB2, Oracle, SQL/Server or comparable
  • Effective at gathering and analyzing business requirements and current system behavior and collaborating to create system design specification documents including functional specifications, system use cases, mock-ups, and design models.
  • Demonstrated experience working within a complex team environment, working with multiple vendor teams, providing SME support across multiple programs
  • Experience with reference data management / governance and end to end data lineage
  • Proven ability to lead a team and collaborate with stakeholders
  • Strong collaboration, facilitation, and listening skillset
Preferred Basic Qualifications:
  • Masters Degree.
  • Strong technology project management skills.
  • Healthcare data experience.
  • Exceptional verbal and written communication
  • Customer Internal and External consulting experience
  • Knowledge about HEDIS, Care and Disease management programs, Stays, Groupers
  • Preferred experience with Ab Initio products like MDH, Query>It, data profiler
  • Exposure to job scheduling systems is a plus
  • IBM Watson Health Advantage Suite experience is a bonus
  • Contingent will be assigned to multiple projects within the FEP Program.
  • Contingent will be responsible for completing all the System Analysis & Design work and deliverables for all assigned projects.


  • Chicago, United States Valuation Reporting Analyst Full time

    Seeking a Valuations Systems Platform Analyst/Administrator for a direct hire opportunity in Chicago. Based in Chicago, Illinois, the Valuation Reporting Analyst will serve as a key member of our Client’s Global Business Enablement team, with the primary role of supporting the technology underlying their proprietary valuation model. The Valuation Reporting...


  • Chicago, United States Crescens Full time

    Job Title: Lead Mainframe Analyst Location: Chicago, IL Duration: Long term Type: C2HJob Description: Own the process to perform current state analysis of large IT mainframe systems. Work together with a team of analysts to perform thorough analysis and identify gaps and challenges. Clearly document the gaps and compare contrast with solutions. Required:...


  • Chicago, United States Crescens Full time

    Job Title: Lead Mainframe Analyst Location: Chicago, IL Duration: Long term Type: C2HJob Description: Own the process to perform current state analysis of large IT mainframe systems. Work together with a team of analysts to perform thorough analysis and identify gaps and challenges. Clearly document the gaps and compare contrast with solutions. Required:...


  • Chicago, United States AMS Staffing, Inc. Full time

    Job DescriptionJob DescriptionPlease send resume in WORD format should you be interested in the following Financial Systems Analyst position located in Chicago IL. This is a full-time, direct-hire position with a 90-105 + bonus + awesome benefits. If you are not interested, please pass along to your colleagues as we do pay referral fees.Title: Financial...


  • Chicago, United States AMS Staffing, Inc. Full time

    Job DescriptionJob DescriptionPlease send resume in WORD format should you be interested in the following Financial Systems Analyst position located in Chicago IL. This is a full-time, direct-hire position with a 90-105 + bonus + awesome benefits. If you are not interested, please pass along to your colleagues as we do pay referral fees.Title: Financial...

  • Lead HRIS Analyst

    6 days ago


    Chicago, United States HUB International Full time

    International. At HUB International, we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions t HRIS, HRIS Analyst, Technical Support, Analyst, Lead, Solutions, Insurance

  • System Analyst

    3 days ago


    Chicago, United States Mastech Digital Full time

    Job Role: Systems Analyst Job Location: Chicago, IL or Richardson, TX (Hybrid) Duration: 6 months Contract to Hire REQUIRED: Skills: Java, SQL, DB2, Health Insurance experience required Supports changes and enhancements from development through production; recommending and implementing system enhancements (e.g., screen appearance, report distribution and...

  • System Analyst

    2 weeks ago


    Chicago, United States Mastech Digital Full time

    Job Role: Systems AnalystJob Location: Chicago, IL or Richardson, TX (Hybrid)Duration: 6 months Contract to HireREQUIRED:Skills: Java, SQL, DB2, Health Insurance experience requiredSupports changes and enhancements from development through production; recommending and implementing system enhancements (e.g., screen appearance, report distribution and setup...

  • System Analyst

    3 weeks ago


    Chicago, United States Mastech Digital Full time

    Job Role: Systems AnalystJob Location: Chicago, IL or Richardson, TX (Hybrid)Duration: 6 months Contract to HireREQUIRED:Skills: Java, SQL, DB2, Health Insurance experience requiredSupports changes and enhancements from development through production; recommending and implementing system enhancements (e.g., screen appearance, report distribution and setup...

  • Lead HRIS Analyst

    5 days ago


    Chicago, United States HUB International Full time

    About HUB International At HUB International, we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees. As a global firm, we offer employees...

  • Lead HRIS Analyst

    2 days ago


    Chicago, United States HUB International Full time

    About HUB InternationalAt HUB International, we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees. As a global firm, we offer employees...

  • Lead HRIS Analyst

    7 days ago


    Chicago, United States HUB International Full time

    About HUB InternationalAt HUB International, we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees. As a global firm, we offer employees...


  • Chicago, United States Midas Consulting Full time

    Position : Healthcare Business System Analyst Location : Chicago, IL Remote Role Duration : 12+ Months Job Description Client is looking for some experience in source to target mappings/ and general knowledge in Medicare/CMS/Risk Adjustment/Medical Claims, DX/HCPCS codes etc. Data in the Healthcare space. Shy away from resumes where the person's...

  • Data Analyst Lead

    2 weeks ago


    Chicago, United States Diverse Lynx Full time

    Data Analyst Lead Chicago - IL Remote1. SQL scripting 2. Data analysis 3. SnowflakeJob summary Strong Business stakeholder management - must Strong Data Analysis skill - must Strong SQL Scripting and Excel knowledge -must Intermediate - Insurance Domain knowledge - must Snowflake - strong from data analysis standpoint RDMS/Database Design - basic -...


  • Chicago, United States RSM Solutions Full time

    Thank you for stopping by to take a look at the Systems Analyst role I posted on LinkedIN. If you have read my job descriptions before, you will know that I like to add some humor to these things. If you are new to my JD's, welcome to the party.Allow me to introduce myself. My name is Tom Welke. I am Partner & Vp at RSM Solutions Inc and I have been...


  • Chicago, United States RSM Solutions, Inc Full time

    Thank you for stopping by to take a look at the Systems Analyst role I posted on LinkedIN. If you have read my job descriptions before, you will know that I like to add some humor to these things. If you are new to my JD's, welcome to the party.Allow me to introduce myself. My name is Tom Welke. I am Partner & Vp at RSM Solutions Inc and I have been...


  • Chicago, United States RSM Solutions, Inc Full time

    Thank you for stopping by to take a look at the Systems Analyst role I posted on LinkedIN. If you have read my job descriptions before, you will know that I like to add some humor to these things. If you are new to my JD's, welcome to the party.Allow me to introduce myself. My name is Tom Welke. I am Partner & Vp at RSM Solutions Inc and I have been...


  • Chicago, United States RSM Solutions, Inc Full time

    Thank you for stopping by to take a look at the Systems Analyst role I posted on LinkedIN. If you have read my job descriptions before, you will know that I like to add some humor to these things. If you are new to my JD's, welcome to the party.Allow me to introduce myself. My name is Tom Welke. I am Partner & Vp at RSM Solutions Inc and I have been...


  • Chicago, United States RK Management Consultants, Inc. Full time

    One of my client’s based at Riverwoods, IL is looking for a “Business System Analyst” to add in their team. I would appreciate if you may check the details below and if interested, please apply today!Job Details:Job Title: Business System AnalystLocation: Riverwoods, IL 60015Duration: 6+ MonthsJob Description:The function of the IAM Delivery Team is to...


  • Chicago, United States RK Management Consultants, Inc. Full time

    One of my client’s based at Riverwoods, IL is looking for a “Business System Analyst” to add in their team. I would appreciate if you may check the details below and if interested, please apply today!Job Details:Job Title: Business System AnalystLocation: Riverwoods, IL 60015Duration: 6+ MonthsJob Description:The function of the IAM Delivery Team is to...