PRIMARY DUTIES AND RESPONSIBILITIES

  • Assist with the development and ongoing reporting and analyses of operational reports for The Center for Information, Analytics and Insights (CIAI).
  • Aggregate disparate data sources through Microsoft Excel and Access, Business Intelligence applications and syntax to develop historical trends and metrics to predict future performance.
  • Facilitate SullivanCotter data governance processes and standards to ensure common data attributes are updated and maintained on defined schedules.
  • Assist in identifying and documenting business system features and enhancements and perform related testing activities.
  • Liaison with CIAI stakeholders to ensure clear understanding of business performance drivers and achievement to date.
  • Assist with defining the business case of new initiatives by drafting, managing feedback and finalizing business requirements.
  • Ensure various data and reporting solutions meet the needs of internal and external stakeholders.
  • Facilitate defined data governance processes and standards including but not limited to:
    • Document and manage standard common data attribute definitions across the firm.
    • Define and maintain the methodology for which data are audited and updated.
    • Utilize various external data sources and publications to ensure definitions and data are as robust as possible.
    • Review data for errors and anomalies to maintain data integrity.
    • Generate custom data sets utilizing this standard data.
    • Document and coordinate the flow of these data elements between various systems; enabling a single, centralized source of truth.
    • Define and develop a maintenance plan for which updated data for these elements is pulled from various sources according to specified timing.
    • Participate in ongoing meetings with various internal stakeholders.
  • Reporting and analysis of operational reports including but not limited to:
    • Build status reporting tools utilizing data from multiple relational databases.
    • Develop standard report templates to streamline the development of additional reports.
    • Automate the daily updating of status reports and troubleshoot when update errors occur.
    • Understand ongoing requests and translate them into custom status reports for team members and other stakeholders.
    • Define and implement ways to streamline the data intake process to minimize manual effort involved in keeping statuses of various data elements up-to-date.
  • Participate in system design, feature and function requirements and process definition.
  • Participate in other team activities as assigned, including but not limited to:
    • Assist stakeholders with troubleshooting of system processing and reporting issues as needed.
    • Maintain user confidence and protect confidential information.

    EDUCATION AND EXPERIENCE REQUIREMENTS

    • Bachelor’s degree.
    • Minimum of three years’ experience working with significant data management responsibilities or software and analytic tools.
    • Advanced understanding of data management and analytics. Knowledge of health care related data is a plus.
    • Advanced knowledge of Microsoft applications including Access, Word, Excel, Project and Outlook. Experience with Oracle business intelligence report writing and analytics is a significant plus.
    • Knowledge of relational database reporting tools, ODBC connections, SQL and syntax writing is required.
    • Proven experience aggregating multiple disparate datasets and automating reporting and analytics.
    • Advanced investigational skills, attention to detail, accuracy and ability to manage and prioritize multiple tasks.
    • Strong individual contributor, but equally as strong team player that focuses and supports group results.
    • Must be able to work independently, prioritize and make sound business decisions.
    • Must be available periodically on weekends or evenings to support user testing.

    BEHAVIORAL ATTRIBUTES

    • Communicate with others in a respectful, courteous manner while simultaneously building credibility and rapport.
    • Present clear and accurate information and updates to clients, colleagues and leaders; adapts presentations to fit audience.
    • Communicate effectively with IT programmers to investigate and resolve issues or to design and implement system improvements.
    • Anticipate, understand and address client needs by taking ownership of and initiating action on client requests and concerns.
    • Establish client confidence by developing and maintaining professional working relationships; utilize resources to accomplish goals and meet client and team needs.
    • Prepare accurate information based on client requests or needs.
    • Provide excellent client service in multiple assignments.
    • Utilize critical thinking skills to build upon current solutions to provide additional value to team members and clients.

    Applicants for employment must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States (i.e. H1-B visa, F-1 visa (OPT), TN visa or any other non-immigrant status).

SullivanCotter is an Equal Opportunity Employer.

Current Openings

Eau Claire, WI

  • There are no openings at this time.

Denver, CO

  • There are no openings at this time.

San Francisco, CA

  • There are no openings at this time.

Indianapolis

  • There are no openings at this time.
Fill Out a General Application
Share This: