Senior Consultant – SQL, Cognos & Looker at Model N

Hyderabad, Telangana, India

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Life Sciences, TechnologyIndustries

Requirements

5+ years’ experience in BI software development & delivery of enterprise software implementations using IBM Cognos, with at least 3 years of experience in a BI developer role
Advanced knowledge in Data Analytics and Business Intelligence concepts
Experience in relational database programming, particularly Oracle and advanced-level SQL and PL/SQL
Experience with logical database design and SQL query optimization techniques (desirable)
Experience in Cognos Analytics development, Server Configuration and Administration, Packaging and Deployment, Model generation, Report Authoring, and the Cognos Framework Manager (added advantage)
Experience with analytics tools such as Looker, including LookML development (highly desirable)
Proven ability in performance tuning: optimizing SQL queries and other tuning techniques
Experience in all aspects of BI software development life cycle; emphasis on applying formal methodologies and tools
Strong analytical and problem-solving skills
Ability to work independently and collaboratively within a team to deliver project milestones on schedule
Excellent communication and stakeholder management skills
Bachelor’s degree in computer science or related discipline

Responsibilities

Collaborate with global clients and internal stakeholders to gather technical requirements
Write, optimize, and troubleshoot complex Oracle SQL queries, stored procedures, and views to support reporting and analysis
Translate functional and business requirements into technical specifications and Cognos/SQL deliverables
Design, develop, and maintain Cognos reports
Work with delivery teams to ensure the successful implementation and transition of solutions
Full BI software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations support
Translate customer requirements into BI software design, development, plan, and implementation
Propose system design/enhancements based on customer problems and product requirements
Communicate with users, other technical teams, and management to collect requirements, describe software product features, and technical designs
Ensure system changes are tested properly
Collaborate with cross-functional teams to analyze data flows and improve reporting efficiency
Lead a small group of consultants to customize, implement, and deploy Model N BI applications

Skills

Key technologies and capabilities for this role

SQLOracle SQLCognosLookerstored proceduresBI reportingdata analysiscode reviewssource controlrequirements gathering

Questions & Answers

Common questions about this position

What experience level is required for this Senior Consultant role?

The role requires 5+ years of experience in BI software development and delivery of enterprise software implementations using IBM Cognos, with at least 3 years in a BI developer role.

What key technical skills are needed for this position?

Candidates need advanced knowledge in Data Analytics and Business Intelligence, expertise in Oracle SQL and PL/SQL including query optimization, and experience with Cognos Analytics development, Framework Manager, report authoring, server configuration, and deployment.

Is this a remote position or does it require office work?

This information is not specified in the job description.

What is the salary or compensation for this role?

This information is not specified in the job description.

What does the team structure look like for this role?

This is an individual contributor role with hands-on technical delivery, where the candidate will lead a small group of consultants as a key member of the Global Services team and Life Sciences Application Services.

Model N

Cloud-based revenue management solutions provider

About Model N

Model N offers cloud-based revenue management solutions tailored for the high-tech and life sciences industries, helping clients maximize revenue throughout the commercialization process. Their platform includes industry-specific tools like Revenue Cloud for Pharma and Medtech, which address complex pricing and compliance challenges. Clients subscribe to Model N's software-as-a-service (SaaS) model, ensuring continuous updates and support. The company's goal is to enable clients to efficiently bring life-changing products to market while navigating regulatory complexities.

San Mateo, CaliforniaHeadquarters

1999Year Founded

$36MTotal Funding

IPOCompany Stage

Enterprise Software, HealthcareIndustries

1,001-5,000Employees

Benefits

Health Insurance

Dental Insurance

Vision Insurance

Health Savings Account/Flexible Spending Account

Unlimited Paid Time Off

Flexible Work Hours

401(k) Company Match

Paid Vacation

Life Insurance

Pet Insurance

Employee Assistance Programs

Mental Health Support

Employee Stock Purchase Plan

Professional Development Budget

Risks

Vista acquisition may disrupt operations or affect company culture.

GenAI integration may face adoption challenges among existing clients.

Inflation Reduction Act could impact clients' revenue, affecting investment in Model N.

Differentiation

Model N specializes in revenue management for life sciences and high-tech industries.

Their solutions address complex pricing, compliance, and revenue challenges in targeted sectors.

Model N's SaaS model ensures continuous updates and support for its clients.

Upsides

Integration of GenAI enhances efficiency in revenue management processes.

New Medicare Part D rebate feature aids compliance with Inflation Reduction Act.

Vista Equity acquisition provides resources for market expansion and product enhancement.

Land your dream remote job 3x faster with AI

Try Jobo Free