EDW BI Data Analytics Developer (36021)

Myticas Consulting; Illinois; Remote; USD 77,000 - 91,000; Full time

Job summary

Clover Consulting is seeking an EDW BI Data Analytics Developer for a 12+ month contract. The role is remote with possible travel to Illinois and involves building BI dashboards, data analyses, and a React-based portal.

You will work with SQL across Teradata/DB2/Oracle, develop data marts, and collaborate with DBAs and data modelers to support health and human services programs with advanced analytics.

Qualifications

• Five+ years building Tableau and Power BI dashboards, visualizations, and analytics.
• Five+ years developing complex SQL scripts (Teradata/DB2/Oracle) or stored procedures.
• At least four years of React development (React.js/ReactJS).

Responsibilities

• Develop BI solutions and dashboards to support data strategy.
• Create and maintain dashboards, scorecards, reports, and data analyses.
• Build web-based portal using React.
• Enhance program delivery with advanced analytics, visuals, and maps.
• Develop and maintain complex SQL for data marts in Teradata and ad hoc reports.

Skills

Tableau

Power BI

SQL

React

Communication

Team collaboration

Education

Bachelor's or Advanced Degree

Tools

Teradata

DB2

Oracle

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