Senior ETL / BI Application Engineer

Conduent • Gates, NY

4h • Onsite

About The Position

This is not a developer role, though collaboration with developers may occur.

This position will be a member of a broader ETL/BI team, so experience
administering Cognos and Tableau with Medicaid Enterprise Data Warehouse,
Pharmacy Benefits or Medicaid Management Information System operating
environments is required, with hands on experience with Business Objects and /
or Informatica a significant plus.

Requirements

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or related field, or equivalent experience.
• Strong understanding of Tableau security, permissions, licensing, and performance tuning.
• 5+ years of experience administering IBM Cognos Analytics (or Cognos BI).
• Strong knowledge of Cognos/Tableau architecture, security, and deployment.
• 5 years of experience administering Tableau.
• ForgeRock integration/SSO technology.
• Proficiency in SQL and understanding of relational data models.
• Experience supporting large enterprise data warehouses.
• Familiarity with Linux and/or Windows server environments.
• Experience with job scheduling, monitoring, and performance tuning.
• Experience supporting Medicaid, MMIS, or healthcare data environments.
• Understanding of claims, eligibility, provider, and financial data domains.
• Familiarity with HIPAA, CMS, and state Medicaid reporting requirements.
• Strong troubleshooting and analytical skills.
• Ability to communicate technical issues to non-technical stakeholders.
• Attention to detail and strong documentation habits.
• Ability to work in regulated, audit-driven environments.
• Comfortable supporting mission-critical reporting systems.

Nice To Haves

• Experience with Medicaid Enterprise Data Warehouse or MITA-aligned systems.
• Exposure to T-MSIS reporting and CMS federal submissions.
• Knowledge of DataStage, Informatica, or other ETL tools.
• Experience with cloud environments (AWS, Azure, or GCP).
• ITIL or relevant technical certifications.
• Tableau certification (e.g., Tableau Server Certified Associate or Professional)
• Familiarity with CMS reporting, Medicaid data domains, or program integrity analytics.
• Experience with monitoring tools and automation/scripting (PowerShell, Python, or similar)

Responsibilities

• Cognos Platform Administration
• Install, configure, upgrade, and patch Tableau Servers and IBM Cognos Analytics (including gateways, application servers, and content manager components) in accordance with change management processes.
• Manage Cognos/Tableau environments across Development, Test, UAT, and Production.
• Monitor system health, job schedules, and report execution performance.
• Manage users, roles, and security permissions.
• Monitor report performance and optimize query processing.
• Perform deployment and migration across DEV QA, PRO environments.
• Apply patches, fix packs, and version upgrades.
• Troubleshoot and resolve platform issues, outages, and performance bottlenecks.
• Security & Access Control
• Configure security using ForgeRock integration.
• Manage roles, groups, object-level permissions, and data-level security.
• Ensure HIPAA-compliant access to PHI and PII.
• Support audit requests related to user access and report usage.
• Data Integration & EDW Support
• Configure and maintain connections to Medicaid EDW data sources
• Coordinate with ETL and data engineering teams to align refresh schedules and data availability.
• Support certified data sources and shared semantic layers.
• Report Operations & Scheduling
• Administer report schedules, bursting, distribution, and subscriptions.
• Support high-volume batch reporting (e.g., MMIS, claims, provider, eligibility, financial reports).
• Coordinate report promotions and content migrations between environments.
• Performance & Optimization
• Tune configurations for large datasets and complex queries.
• Collaborate with EDW DBAs and ETL teams to optimize queries, indexes, and data models.
• Identify and resolve long-running or failed reports.
• Change & Release Management
• Support report and platform releases following ITIL or SDLC processes.
• Promote content using Cognos deployment packages.
• Maintain rollback procedures and disaster recovery readiness.
• Compliance & Federal Reporting Support
• Support CMS-required reports (e.g., T-MSIS, MBES/CBES, financial and program integrity reporting).
• Ensure reporting availability and timeliness for federal and state audits.
• Document configurations, processes, and operational procedures.
• Collaboration & Support
• Work with report developers, business analysts, and data modelers.
• Provide Tier 2/Tier 3 support for Cognos-related incidents and service requests.
• Assist end users with access issues and basic report execution troubleshooting.
• Create and maintain platform documentation, runbooks, and standard operating procedures.
• Participate in release planning, environment coordination, and cross-team meetings

Benefits

• Career Growth Opportunities: We help you thrive, so together, we can grow. We provide opportunities to advance your career with a vast portfolio of businesses and a global footprint.
• Great Work Environment: We are proud of our award-winning culture and the recognition we’ve received for our diversity efforts.
• health insurance coverage, voluntary dental and vision programs, life and disability insurance, a retirement savings plan, paid holidays, and paid time off (PTO) or vacation or sick time.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level