BI Engineer

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.

We are seeking a BI Engineer to design, develop, and support scalable reporting and analytics solutions for state healthcare and human services programs. This role partners with business and technical stakeholders to translate reporting needs into intuitive IBM Cognos reports and Tableau dashboards, while ensuring data accuracy, performance, usability, and alignment with program objectives.

As part of the report development team, you will create and enhance IBM Cognos reports and Tableau dashboards that turn complex Medicaid data into actionable insights. You will contribute across the development lifecycle—including solution design, data modeling, coding, testing, performance tuning, documentation, deployment, and production support—while collaborating with stakeholders to deliver reliable, user-focused BI solutions.

Primary Responsibilities

• • Serve as a BI Developer and technical subject matter expert for IBM Cognos Analytics and Tableau reporting solutions.
  • Provide Cognos administration support and serve as a backup to the current Cognos administrator as needed, including user access, security, deployments, scheduling, monitoring, troubleshooting, and environment support.
  • Maintain, support, and enhance existing Cognos reports, packages, dashboards, and Tableau workbooks and data sources.
  • Design and build new Cognos reports and Tableau dashboards based on approved business requirements and reporting standards.
  • Partner with business stakeholders to gather requirements, create report and dashboard mockups, and refine solutions through iterative feedback.
  • Collaborate with the data team to understand source data, define reporting datasets, resolve data issues, and ensure solutions align with the enterprise data model.
  • Develop complex reports and visualizations, including prompts, drill-throughs, calculations, sub reports, graphical components, and well-formatted outputs.
  • Recommend enhancements that improve usability, performance, data quality, and the business value of existing and new reporting objects.
  • Create intuitive dashboards and reports that communicate clear, actionable insights to business users.
  • Validate report results against source and warehouse data to ensure accuracy, completeness, and consistency throughout development and maintenance.
• Participate in Agile delivery activities, including writing user stories and acceptance criteria, daily stand-ups, sprint planning, reviews, and retrospectives.
• • Work within the project team under the direction of project management and technical leads to deliver reliable reporting solutions and production support.

Required Qualifications

• Bachelor’s degree in computer science, Information Systems, Mathematics, or a related field, or equivalent relevant experience.

• 5+ years of experience developing, maintaining, and supporting enterprise business intelligence reports, dashboards, and related reporting objects.

• 3+ years of experience analyzing data warehouses and interpreting data flow diagrams, conceptual models, physical models, and reporting data structures.

• 3+ years of hands-on experience developing and supporting reports, packages, prompts, schedules, and dashboards in IBM Cognos Analytics.

• 2+ years of hands-on experience developing and supporting Tableau dashboards, workbooks, calculations, filters, and published data sources.

• 3+ years of experience writing and optimizing SQL for report development, data validation, troubleshooting, and performance tuning.

• 1+ year of experience supporting Cognos administration activities such as security, user access, deployments, scheduling, monitoring, and troubleshooting.

Preferred Qualifications:

• Knowledge of healthcare or Medicaid data, including claims, eligibility, provider, and encounter reporting.

• Experience developing BI solutions using cloud data platforms and services, particularly Microsoft Azure and Snowflake.

• Experience with Cognos Framework Manager, package design, security administration, deployments, scheduling, and environment monitoring.

• Experience with Tableau Server or Tableau Cloud publishing, permissions, refresh schedules, performance optimization, and production support.