BI Engineer — Indianapolis, IN

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.