EDW Business Intelligence/Data Analytics Developer

RCR Technology Group; United States; Remote; USD 95,000 - 130,000; Full time

Job summary

RCR Technology Corporation is seeking an EDW BI/Data Analytics Developer to design and implement advanced BI solutions across data strategy, dashboards, and data marts in Teradata. You will collaborate with DBAs, data modelers, and developers to deliver scalable analytics for health and human services programs.

The ideal candidate has 5+ years in Tableau and Power BI, strong SQL skills, and proven React experience, with excellent communication and mentoring abilities.

Qualifications

• 5+ years building Tableau and MS Power BI dashboards and analytics.
• Strong SQL development experience with Teradata/DB2/Oracle workloads.
• Minimum 4 years of React (React.js/ReactJS) development.
• Excellent communication, client-facing, collaboration, and mentoring skills.
• Bachelor’s or advanced degree in IT/CS/Analytics or related field.

Responsibilities

• Develop complex BI solutions and dashboards to inform opportunities and risks.
• Create and maintain web portals using React for data access.
• Improve health and human services program delivery with analytics and maps.
• Develop and maintain complex SQL queries to build data marts in Teradata.
• Participate in testing, requirements gathering, and project documentation.

Skills

Tableau

Power BI

SQL

React.js

Data visualization

Communication/Mentoring

Education

Bachelor's degree in IT/CS/Analytics

Advanced degree preferred

Tools

Teradata

DB2

Oracle

Job description

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.

Requirements

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 with State Medicaid / Medicare / Healthcare industry