Lead Systems Analyst
Location: Chicago, IL
About the role
Lead Systems Analyst responsible for designing and implementing application systems, data warehousing, business intelligence, data modeling, ETL, data governance, and providing technical leadership.
Responsibilities
- Gather and analyze business requirements and current system behavior.
- Collaborate to create system design specification documents including functional specifications, system use cases, mock-ups, and design models.
- Provide technical, business, and administrative direction for personnel performing software development tasks, including review of work products for correctness, adherence to design concept and user standards, and progress per project schedules.
- Provide daily supervision and direction to support staff.
- Lead a team and collaborate with stakeholders across multiple programs.
- Work with multiple vendor teams, providing SME support.
- Experience with reference data management/governance and end-to-end data lineage.
- Design solutions utilizing Ab-Initio, DB2, SQL, Oracle, Cognos, Tableau, XML, ERwin (preferred).
- Create SA technical artifacts such as Functional Requirements Specifications (FRS), Requirements Traceability Matrix (RTM), Source to Targets (S2Ts), Data Exchange Documents (DEDs), and Data Models.
- Perform advanced SQL query and data analyst role with strong data analysis and analytical skills.
- Perform data warehousing, business intelligence, data marts, data profiling, data quality analysis, and data analytics.
- Apply multiple development methodologies.
Requirements
- Bachelor's 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 technology stack: Ab-Initio, DB2, SQL, Oracle, Cognos, Tableau, XML; ERwin preferred.
- Knowledge of multiple development methodologies.
- Experience in Data Warehousing, Business Intelligence, Data Marts, Data profiling, Data Quality analysis, Data Analytics.
- Experience creating SA technical artifacts: FRS, RTM, S2Ts, DEDs, Data Models.
- 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: 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.
- 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 Qualifications
- Master's Degree.
- Familiar with data governance, data lineage, data quality, and security.
- Knowledge of health care industry concepts (e.g., HEDIS, Claims, Enrollment, Care Mgmt, Disease Mgmt).
- Knowledge of Federal Employee Program.
Additional Details
Most 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 such as communication (verbal/written), 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 systems 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 functional and technical requirements. Should be a highly motivated individual contributor capable of working smartly and efficiently in getting deliverables delivered on time.