EDW Business Intelligence/Data Analytics Developer

For over twenty-seven years RCR Technology Corporation has delivered the highest quality services to our clients with an expansive portfolio of industry-relevant services, and deep technical capabilities around data management and application development.

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