Sr. Developer, Business Intelligence

WebMD is the most recognized and trusted brand of health information and the leading provider of health information services, serving consumers, physicians, healthcare professionals, employers and health plans through our public and private online portals and WebMD the Magazine. The WebMD Health Network includes WebMD, Medscape, MedicineNet, eMedicine, RxList, theheart.org and Medscape Education. Our consumer portals and mobile health applications provide engaging, relevant and credible health and wellness information, personalized health assessment tools and access to online communities.

WebMD is an Equal Opportunity/Affirmative Action employer and does not discriminate on the basis of race, ancestry, color, religion, sex, gender, age, marital status, sexual orientation, gender identity, national origin, medical condition, disability, veterans status, or any other basis protected by law.

• 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.
• Create and maintain documentation: design documents, technical specifications, runbooks, and end-user guides.
• Implement change control and issue tracking; participate in release management and deployments across environments.
• Aid power users for self-service reporting.
• Promote development best practices and standards.
• Support production environments, respond to incidents, and participate in on-call rotations as needed.
• Stay current with Cognos product updates, new BI trends and tooling, and recommend improvements or migrations.
• 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.

• 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.
• Excellent analytical, problem-solving, and communication skills; ability to engage technical and non-technical stakeholders.
• Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
• Familiarity with platforms such as IBM Planning Analytics/TM1, Microsoft Dynamics GP, Microsoft Dynamics 365, Adobe Workfront, Salesforce. Cloud platforms like Azure, Cognos in cloud.

Compensation: $85,000.00 - $90,000.00

Bonus Eligible:
This position is also eligible for a discretionary company bonus, based upon business results.

Benefits:
Employees in this position are eligible to participate in the company sponsored benefit programs, including the following within the first 12 months of employment:

• Health Insurance (medical, dental, and vision coverage)
• Paid Time Off (including vacation, sick leave, and flexible holiday days)
• 401(k) Retirement Plan with employer matching
• Life and Disability Insurance
• Employee Assistance Program (EAP)
• Commuter and/or Transit Benefits (if applicable)

Eligibility for specific benefits may vary based on job classification, schedule (e.g., full-time vs. part-time), work location and length of employment.