Sr. Developer, Business Intelligence jobs in United States
cer-icon
Apply on Employer Site
company-logo

Medscape · 2 months ago

Sr. Developer, Business Intelligence

WebMD is a leading provider of health information services, seeking a Senior BI Developer with expertise in designing and supporting enterprise BI solutions. The role involves translating business requirements into scalable reporting and dashboards, optimizing report performance, and maintaining security models in Cognos.

BiotechnologyHealth CareMedicalPrimary and Urgent Care

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
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

Qualification

IBM Cognos AnalyticsSQLTableauPowerBIData warehousingETL processesStakeholder managementAnalytical skillsProblem-solving skillsCommunication skills

Required

2-4+ years of hands-on experience designing, developing, and supporting enterprise BI solutions primarily using IBM Cognos Analytics
Experience with other BI platforms (Tableau, PowerBI etc.)
Ability to translate business requirements into scalable reporting, dashboards and semantic models
Experience with security and administration of the platform
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)

Preferred

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

Benefits

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)

Company

Medscape

twittertwittertwitter
company-logo
Medscape provides integrated medical information and educational tools online for primary care physicians and health care professionals. It is a sub-organization of WebMD.

Funding

Current Stage
Public Company
Total Funding
$21M
2001-12-27Acquired
1999-09-27IPO
1999-03-18Series Unknown· $21M

Leadership Team

leader-logo
Christina Hoffman
SVP/ Chief Strategic Officer
linkedin
leader-logo
Amenah Jaffery
Director, Strategic Partnerships
linkedin
Company data provided by crunchbase