WebMD is seeking a Senior BI Developer to design, develop, and support enterprise BI solutions primarily using IBM Cognos Analytics and other BI platforms to translate business requirements into scalable reporting, dashboards and semantic models, security and administration of the platform.
Requirements
- Extensive knowledge of data analytics and Business Intelligence using tools such as Cognos, Tableau, PowerBI, SSRS.
- Strong SQL skills (complex joins, subqueries, window functions) and experience tuning SQL for performance.
- Experience with relational databases (SQL Server, Vertica, Postgres, etc)
- Familiarity with data warehousing concepts (star/snowflake schemas).
- Proven ability to troubleshoot reporting performance and system issues; knowledge of Cognos logging, caching, and query lifecycle.
- Familiar with ETL processes and working collaboratively with ETL/data engineering teams.
- Experience implementing security and access controls in Cognos.
Responsibilities
- Design, develop, test, and deploy Cognos reports (canned and ad-hoc), dashboards and self-service solutions using various studios in Cognos Analytics.
- Build and maintain Framework Manager models and package design to provide robust semantic layers for reporting and analytics.
- Develop complex SQL and stored procedures; work with data cubes and OLAP models where applicable.
- Optimize report performance and troubleshoot issues (query tuning, caching, data source optimization).
- Maintain and implement security models in Cognos (roles, groups, or data-level security).
- Work with data architects (SQL Server, SSIS, TM1, etc.) and source system owners to ensure data correctness, requirement-based enhancements, and new integrations.
- Lead requirements gathering sessions with business stakeholders, translate needs into technical specifications, and propose BI solutions.
Other
- Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
- Strong stakeholder management with the ability to guide business users on best practices and trade-offs.
- Detail-oriented and quality-first mindset with a focus on maintainability and reusability.
- Proactive, self-directed, and able to work independently or as part of a team.
- Excellent analytical, problem-solving, and communication skills; ability to engage technical and non-technical stakeholders.
