Senior Cognos Developer Ab Initio

Senior Cognos Developer with Ab Initio

Lead II - Software Engineering

Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human‑centered solutions for a better world.

UST is a mission‑driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live.

With us, you'll create a boundless impact that transforms your career—and the lives of people across the world.

Visit us at

UST is seeking a Senior Cognos Developer with Ab Initio expertise to help design, build, and optimize enterprise business intelligence and data integration solutions for one of the leading healthcare providers in the United States. This role is ideal for a seasoned BI professional who can lead Cognos development while also contributing to ETL solutioning, impact assessment, and integration using Ab Initio.

• Cognos Development & Optimization Report & Dashboard Development:
  Design, develop, and maintain complex Cognos reports, dashboards, and visualizations to meet diverse business needs.
• Data Modeling:
  Create, optimize, and maintain Framework Manager models supporting analytical and reporting solutions.
• Performance Tuning:
  Optimize Cognos reports, queries, and data models for performance, scalability, and reliability.
• Cognos Upgrades:
  Perform, validate, and troubleshoot Cognos version upgrades with minimal business disruption.
• Quality Assurance:
  Conduct thorough testing, validation, and peer reviews to ensure high-quality deliverables.
• Ab Initio / ETL Integration &
  
  Collaboration:
  
  Work closely with Ab Initio ETL teams to ensure seamless data integration into Cognos environments.

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

• Strong proficiency in Report Studio, Query Studio, Analysis Studio, and Framework Manager.
• SQL & Databases:
  Expertise in SQL with experience in DB2, Postgres, and data warehouse environments.
• Ab Initio
  
  Experience:
  
  Hands‑on experience with Ab Initio GDE, EME, MDH, and Control Center. Understanding of ETL design, data transformations, and job optimization.
• BI & Data Warehousing:
  Strong understanding of DW concepts, star/snowflake schemas, and ETL/ELT best practices.
• Tools Knowledge:
  Familiarity with Control‑M scheduler and other BI tools (Tableau, Power BI preferred).
• Healthcare Data:
  Experience with medical/prescription claims, provider data, and enrollment data is a strong plus.
• Ability to communicate technical concepts to non‑technical stakeholders.
• Proven ability to manage difficult stakeholders and navigate complex situations.
• Experience 7+ years of Cognos development experience.
• 3+ years working in Ab Initio or similar ETL environments.
• Experience handling PHI/PII and working within healthcare data ecosystems.
• Demonstrated experience leading BI improvements and fostering technical excellence.
• Bachelor's degree in Computer Science, Information Technology, or related field.
• Preferred:
  Master's degree in a related discipline.

Extensive experience performing and validating Cognos upgrades. Proactive in driving process and quality improvements across BI and ETL teams. Excel at solving complex technical challenges across reporting and ETL layers. Passionate about business intelligence, data quality, and continuous improvement.

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below.
Role

Location:

Remote

Compensation Range: $82,000 - $123,000

Full‑time, regular employees accrue a minimum of 10 days of paid vacation per year,…