EDW BI Data Analytics Developer (36021)

Myticas Consulting Inc.; Illinois; Remote; USD 160,463,000 - 189,117,000; Full time

Job summary

Clover Consulting has a direct client in Springfield, IL seeking an EDW BI Data Analytics Developer for a 12+ months contract. Remote work available with occasional travel to Illinois.

The role requires expertise in Tableau and Power BI dashboards, strong SQL development, and React experience. You will collaborate with cross-functional teams to deliver data-driven insights for health and human services programs.

Qualifications

• 5+ years of Tableau and Power BI dashboard development and analytics.
• 5+ years SQL development across Teradata/DB2/Oracle.
• 4+ years React development (React.js/ReactJS).
• Excellent verbal and written communication; client-facing.
• Bachelor's or advanced degree in IT/CS/Math/Analytics.
• Strong organizational skills and ability to set priorities and deadlines.
• Adaptable and collaborative with team.

Responsibilities

• Develop BI solutions and dashboards to inform opportunities and risks.
• Create dashboards, scorecards, and data analyses for decision making.
• Develop and maintain a React-based web portal.
• Improve health and human services programs via advanced analytics and visualizations.
• Develop and maintain complex SQL queries and data marts in Teradata.
• Participate in project discussions to document technical solutions.
• Participate in unit, integration, and system testing.
• Communicate progress and coordinate with project team and stakeholders.
• Gather business requirements and prepare analyses to evaluate program effectiveness.
• Provide technical guidance and perform peer reviews.
• Support project planning and status reporting.
• Demonstrate deliverables to obtain buy-in for solutions.
• Collaborate with DBAs, data modelers, and admins on maintenance and upgrades.

Skills

Tableau dashboards

Power BI dashboards

SQL development

React development

Client-facing communication

Mentoring/ teamwork

Education

Bachelor's or Master's in IT/CS/Math/Analytics

Tools

React

Teradata

DB2

Oracle

SQL Server

Job description

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.

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