Rate:
Depends on Experience
Candidates local to Springfield, IL area preferred
Required Qualifications:
• Experience with healthcare claims• More than seven years of experience developing, implementing, and maintaining complex Tableau or MS Power BI dashboards, visualizations, and analytics• Proven strong development of high performing SQL with more than five years of experience developing complex SQL scripts (Teradata/DB2/Oracle Load Utilities) or stored procedures• At least three years of experience using x12/EDI data including 835, 277, and 837• At least five years developing complex business intelligence solutions• At least five years of data warehouse project experience• At least five years Teradata version 14+ experience, including SQL Assistant/Teradata Studio• Excellent verbal/written communication skills, end client-facing skills, team collaboration, and mentoring skills• Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology• Strong organization skills and ability to set priorities and schedule work deadlines• Adapting to and collaborating with the team and organizational culture
Primary Responsibilities:
• Develop and maintain complex SQL queries and scripts used to create data marts in Teradata.• Gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests.• Design, develop, implement, and maintain Business Intelligence reports using healthcare claims data.• Develop complex business intelligence solution and supporting data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks.• Develop complex dashboards, scorecards, reports, and data analysis using X12/EDI pre-adjudicated data including 835, 277, and 837 transitions.• Maintain effective communication and relationships with all individuals involved with the project.• Improve the delivery and management of health and human services programs by utilizing advanced analytics, including but not limited to advanced algorithms, data visualizations, and maps.• Participate in project discussions to document and recommend alternative technical solutions or requirements.• Participating in unit, integration, and system testing.• Perform peer-reviews and provide technical support/guidance to the project team.• Support the project manager and leadership in project planning and executing activities, including presentations, risks/issues, and status reporting.• Demonstrate deliverables to the team or the customers for approvals and gain buy-in to implement solutions or adapt to new products/services/programs.• Work with the DBAs, data modelers, and application/system admins to support maintaining the Teradata and application server hardware and software (including patches, fixes, and upgrades) and leading industry level standards or best practices.• Learn new technologies as needed to be able to perform job duties effectively.• Research and consult with resources and/or industry experts to ensure the effectiveness and efficiency of systems and applications.• Perform additional duties that are normally associated with this position, as assigned.
Preferred Qualifications:
• More than five years of experience analyzing and delivering complex analytics using Medicaid or Managed Care claims.• Experience with State Medicaid / Medicare / Healthcare industry• More than three years of Tableau Server Administrative experience• Experience in SAP Business Objects or SAS• Prior Experience in Tableau or BO version upgrades• Experience in Agile
