BI Developer

AB2 Consulting, Inc.; Illinois; Presencial; USD 120.000 - 160.000; Jornada completa

Descripción de la vacante

AB2 Consulting, Inc. is seeking an experienced EDW BI/Data Analytics Developer to design and implement advanced analytics solutions using Tableau, Power BI, and SQL across Teradata environments.

You will build dashboards, data marts, and data visualizations while collaborating with DBAs, data modelers, and admins to maintain Teradata systems. The role emphasizes hands-on development with React-based web portals, documentation, testing, and providing guidance to project teams to deliver

Formación

• 5+ years building Tableau and Power BI dashboards and analytics.
• 5+ years SQL scripting for Teradata/DB2/Oracle.
• 4+ years React development (React.js/ReactJS).
• Excellent communication, client-facing and team mentoring.
• Bachelor's or advanced degree in IT/CS/Analytics.
• Strong organization and prioritization.

Responsabilidades

• Develop BI solutions and dashboards to inform opportunities/risks.
• Create web portals using React.
• Improve health program delivery through advanced analytics and visualizations.
• Write and maintain complex SQL queries and data marts.
• Participate in testing and project planning.
• Gather business requirements and prepare analyses.
• Collaborate with DBAs, data modelers, and admins.
• Provide technical guidance and peer reviews.
• Present deliverables for approvals and buy-in.

Conocimientos

Tableau & Power BI dashboards

SQL scripting

React development

Communication & mentoring

Organization & prioritization

Educación

Bachelor's or Advanced Degree in IT/CS/Analytics

Herramientas

Tableau

Power BI

React

SQL (Teradata/DB2/Oracle)

SAP Business Objects

Base SAS / SAS Analytics / SAS Enterprise Guide

Descripción del empleo

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