BI Developer

CSpring•Springfield, IL

About The Position

CSpring is a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics for public- and private-sector clients. The BI Developer works with clients to turn enterprise data visions into defined, sequenced, and communicated plans of record. The role develops complex business intelligence solutions, dashboards, reports, analyses, and data marts, while supporting data strategy and health and human services program delivery through advanced analytics. It also includes maintaining a React-based web portal, contributing to project planning and testing, and collaborating with clients and technical teams to deliver and gain approval for solutions.

Requirements

More than five years of experience developing, implementing, and maintaining complex Tableau and Microsoft Power BI dashboards, visualizations, and analytics.
More than five years of experience developing complex SQL scripts or stored procedures, with proven ability to develop high-performing SQL; technologies include Teradata, DB2, and Oracle Load Utilities.
At least four years of experience in complex development using React, including React.js or ReactJS.
Excellent verbal and written communication, client-facing, team collaboration, and mentoring skills.
Bachelor’s or advanced degree in a related field, such as Information Technology, Computer Science, Mathematics, Statistics, Analytics, or Business Technology.

Nice To Haves

More than two years of experience analyzing and delivering complex analytics using Medicaid claims and enrollment data.
At least two years of data warehouse project experience.
More than two years of Tableau Server administration experience.
Experience with SAP BusinessObjects.
Experience developing with Base SAS, SAS Analytics, or SAS Enterprise Guide.
Experience in the State Medicaid, Medicare, or healthcare industry.

Responsibilities

Develop complex business intelligence solutions and support data strategy, using subject matter expertise to identify and inform opportunities and risks.
Develop complex dashboards, scorecards, reports, and data analyses.
Create and maintain a web-based portal using React.
Use advanced analytics, including algorithms, data visualizations, and maps, to improve health and human services program delivery and management.
Develop and maintain complex SQL queries and scripts to create Teradata data marts, and run ad hoc complex SQL queries and reports using claims, beneficiary, and provider data.
Participate in project discussions to document and recommend alternative technical solutions or requirements.
Participate in unit, integration, and system testing.
Maintain effective communication and relationships with everyone involved in the project.
Gather business requirements and prepare analyses from internal and external sources to evaluate and demonstrate program effectiveness and efficiency in support of projects and change requests.
Perform peer reviews and provide technical support and guidance to the project team.
Support the project manager and leadership with project planning and execution, including presentations, risk and issue management, and status reporting.
Demonstrate deliverables to teams or customers, obtain approvals and buy-in, and support implementation or adaptation of solutions, products, services, or programs.
Work with DBAs, data modelers, and application or system administrators to support Teradata and application server hardware and software maintenance, including patches, fixes, and upgrades, and promote industry standards and best practices.