EDW BI Data Analytics Developer
- Location: Springfied, Illinois
- Type: Contract
- Job #36021
Clover Consulting has a direct client in Springfield, IL in need of an EDW BI Data Analytics Developer for a 12+ months contract. Job details are below. Qualified candidates please provide resume. Thank you!
Role: EDW BI Data Analytics Developer
Location: Remote – occasional travel to Illinois possible
Term: 12+ months contract, extensions possible
Rate: $56 W2 – $66 C2C
Primary Responsibilities of the EDW Business Intelligence/Data Analytics Developer:
- Developing complex business intelligence solutions and supporting data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks
- Developing complex dashboards, scorecards, reports, and data analysis
- Creating and maintaining a web-based portal using React
- 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
- Developing and maintaining complex SQL queries and scripts to create data marts in Teradata and running ad hoc complex SQL/reports using claims, beneficiary, and provider data
- Participating in project discussions to document and recommend alternative technical solutions or requirements
- Participating in unit, integration, and system testing
- Maintaining effective communication and relationships with all individuals involved with the project
- Gathering business requirements and preparing analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency in supporting projects and change requests
- Performing peer reviews and providing technical support/guidance to the project team
- Supporting the project manager and leadership in project planning and executing activities, including presentations, risks/issues, and status reporting
- Demonstrating deliverables to the team or the customers for approvals and gaining buy-in to implement solutions or adapt to new products/services/programs
- Working 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.
Required Qualifications:
- More than five years of experience developing, implementing, and maintaining complex Tableau and 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 four years of experience of complex development using React (React.js or ReactJS)
- 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
Preferred Qualifications:
- 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 Administrative experience
- Experience in SAP Business Objects
- Experience developing using Base SAS, SAS Analytics, SAS Enterprise Guide
- Experience with State Medicaid / Medicare / Healthcare industry