EDW BI Data Analytics Developer (36021)

Myticas Consulting Inc.; 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 in remote mode with possible travel to Illinois. The role focuses on building BI dashboards, data analyses, and a React-based web portal.

Strong SQL skills and experience with Teradata/DB2/Oracle are required. The candidate will enhance health and human services analytics through advanced visualizations, maps, and data-driven insights, while collaborating with DBAs and data modelers.

Qualifications

• Five+ years of experience building Tableau and MS Power BI dashboards and analytics.
• Five+ years of SQL scripting experience (Teradata/DB2/Oracle) or stored procedures.
• At least four years of React (React.js/ReactJS) development.
• Excellent verbal and written communication, client-facing, teamwork and mentoring.
• Bachelor's or advanced degree in IT/CS/Analytics or related field.
• Strong organization skills and ability to prioritize work deadlines.

Responsibilities

• Develop BI solutions and data strategy to inform opportunities/risks.
• Create dashboards, scorecards, reports and data analysis.
• Build a web portal using React.
• Improve health and human services analytics with advanced visuals and maps.
• Maintain complex SQL queries to create data marts in Teradata and run ad hoc SQL/reports.
• Participate in project discussions and document technical requirements.
• Conduct unit and integration testing and support test efforts.
• Communicate with project team and stakeholders effectively.
• Gather business requirements and analyze data to measure program effectiveness.
• Provide peer reviews and technical guidance to team.

Skills

Tableau dashboards

Power BI dashboards

SQL development

React development

Communication

Education

Bachelor's degree or higher in IT/CS/Analytics

Tools

Teradata

DB2

Oracle

SAP Business Objects

SAS

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