Systems Analyst III-Underwriting Platform at Blue Cross Blue Shield of Michigan in Detroit, Michigan

Job Description:

The Underwriting Platform team within IT is looking for a Systems Analyst III to join our team. Our department is responsible for maintaining the applications that support the underwriting platform including rating systems, agent commissions and benefit systems. 

The Systems Analyst III is essential in collaborating with extended IT areas, vendors and business partners on corporate initiatives that impact the enterprise.  This position will also serve as the subject matter expert in the business and systems that we support.

Departmental Preferences:

• Prior data analysis experience using SQL


• Strong functional knowledge in systems analysis and development  


• Working experience in conducting design sessions, preparation of business process models, business use cases and business requirement documents


• Working experience in collaborating with business areas and architecture to lead solution design in alignment with Platform strategy


• Solid work experience collaborating with team members, management, and stakeholders to ensure initiatives are completed to standards


• 5 years of IT experience with Informatica, Databricks and SQL


• 3 years of development and maintenance experience in ETL, data warehouse technologies, PowerCenter related tools


• 5 years of experience in Oracle, DB2 and/or TOAD


• Experience with SAP/Callidus applications like Incentive Management, True Producer and other Callidus applications is a plus for supporting BCBSM agent compensation system


• Strong understanding of business goals and standards for customer service

Plan, develop, test and implement IT system solutions that improve business efficiency and productivity as well as support business strategies and goals.  Identify and communicate business needs and translate business requirements into technical system and functional specifications.  Support one or more highly complex or critical business processes/systems and may require design or integration of technical solutions that may cross multiple functions of the business. Project team member for projects large in scope and high complexity; may be enterprise-wide.

• 
  Participate in business short-term and long-term planning sessions to ensure understanding of business goals, direction and business requirements; provide input from an IT systems perspective.
  


• 
  Develop costs estimates for the planning of new systems/enhancements for assigned systems. Serve as a liaison between business areas and the IT organization and vendors in coordination with project managers to provide technical solutions that address user needs.
  


• 
  Translate business requirements into technical requirements. 
  


• 
  Make recommendations for modifications or technical solution to increase effectiveness and efficiency. 
  


• 
  Formulate and define system scope and objective based on user needs and understanding of business processes.
  


• 
  Develop, write, and communicate systems design, functional system specifications and functional architecture analysis. 
  


• 
  Ensure completeness of technical requirements and functional architecture analysis for the design and implementation of system business solutions. 
  


• 
  Identify gaps or issues.
  


• 
  Provide technical guidance on the business impact and opportunities, as needed.  Understand and analyze customer’s systems and capabilities to determine strengths and weaknesses and provide system improvements/ modifications.
  


• 
  Review test plans and monitor testing process to ensure that business results are adequately tested with minimal risk.
  


• 
  Develop user and/or system test cases and validate test results during testing as needed.  Analyze testing results to ensure the solution meets the needs of the business. 
  


• 
  Facilitate issue resolution.
  


• 
  Document system modifications. 
  


• 
  Develop system manuals, system training materials and system enhancement communication. Investigate problems and develop recommendation for resolution. 
  


• 
  Gather data to support recommendations to address problems with appropriate contingency plans. 
  


• 
  Provide technical expertise to resolve issues.
  


• 
  Work closely with developers and end users to ensure technical compatibility and user satisfaction.
  


• 
  Conduct feasibility studies and draft proposals for evaluation by appropriate users and managers. 
  


• 
  May develop business cases. 
  


• 
  Provide input into expenditures based on the size, scope, and cost of hardware and software components.
  


• 
  Stay abreast of new and emerging technologies. 
  


• 
  Participate in the evaluation, selection and application of new and emerging tools and techniques as needed. 
  


• 
  Analyze technology trends to determine impact to the achievement of business goals. 
  


• 
  Identify issues and make recommendations based on impact of new/emerging technology or modifications to existing systems.
  


• 
  Provide input for the development of Service Level Agreements (SLAs) and/or selection of vendors. 
  


• 
  Evaluate performance against SLAs and recommend changes for improvement. 
  


• 
  Develop forecasts for services required from vendors. 
  


• 
  Evaluate vendor performance against SLAs. 
  


• 
  Ensure SLAs are achieved.
  


• 
  Direct team members and foster a team environment. 
  


• 
  Coach and mentor less experienced team members. 
  


• 
  Provide performance feedback, as needed as needed.
  


• 
  Other duties may be assigned.
  

EDUCATION AND/OR EXPERIENCE

• Bachelor's degree in related field preferred.


• Five (5) years of relevant system solution development, testing and implementation work experience required.

OTHER SKILLS AND ABILITIES

• Excellent analytical, technical, interpersonal and communication skills.


• In-depth knowledge of business operations, systems requirements and IT processes.


• Ability to work independently, or within a team environment.


• Other related skills and/or abilities may be required to perform this job.

All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, gender identity, protected veteran status or status as an individual with a disability.