What are the responsibilities and job description for the Sr. Developer, Business Intelligence position at WebMD and Careers?
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.
We are seeking a Senior BI Developer with 2-4 years of hands-on experience designing, developing, and supporting enterprise BI solutions primarily using IBM Cognos Analytics and desirably other BI platforms (Tableau, PowerBI etc). The ideal candidate will translate business requirements into scalable reporting, dashboards and semantic models, security and administration of the platform.
Key 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.
Desired Skillset:
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.
This position is also eligible for a discretionary company bonus, based upon business results.
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)
Salary : $85,000 - $90,000