Principal Consultant – SQL, Cognos & Looker at Model N

Hyderabad, Telangana, India

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level

Full TimeJob Type

UnknownVisa

Technology, Business IntelligenceIndustries

Requirements

8+ years of experience in BI and Data Analytics with proven expertise in IBM Cognos and Oracle SQL / PL/SQL – complex query development, tuning, and performance troubleshooting
Highly Desirable: Looker – LookML model development, explores, and dashboard optimization or any other data analytics and visualization tool
Advanced knowledge in Data Analytics and Business Intelligence concepts
Experience in relational database programming, particularly Oracle and advanced-level SQL and PL/SQL
Proven experience in performance tuning at the database, report, and visualization layers. SQL query optimization techniques are a must
Experience in Cognos Analytics development, Server Configuration and Administration, Packaging and Deployment, Model generation, Report Authoring, and the Cognos Framework Manager (Added Advantage)
Strong Analytical and problem-solving skills
Familiarity with Agile and managed services delivery models with a good understanding of SDLC and ITIL processes
Ability to work independently or lead a team effectively, meet project deliverables on time
Excellent communication and customer management skills with an ability to bridge technical and business perspectives effectively
Leadership mindset with a focus on mentoring and continuous improvement
BE/BTech or ME/MTech

Responsibilities

Collaborate with business stakeholders to understand functional and reporting requirements, and translate them into efficient technical solutions
Lead the design, development, and deployment of Cognos reports, dashboards, and data models
Act as a subject matter expert (SME) for Cognos Analytics, Oracle SQL, and data analytics best practices
Design and optimize complex Oracle SQL queries, PL/SQL procedures, and database views to support BI reporting
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
Mentor junior developers and review deliverables for design and performance quality
Recommend and help customers understand how Model N can be best changed, designed and/or configured technically to meet a customer's business requirement

Skills

Key technologies and capabilities for this role

SQLOracle SQLPL/SQLCognos AnalyticsCognos ReportsCognos DashboardsData ModelsBI ImplementationLookerDatabase ViewsCode ReviewsSource Control

Questions & Answers

Common questions about this position

What experience level is required for this Principal Consultant role?

The role requires 8+ years of experience in BI and Data Analytics with proven expertise in IBM Cognos and Oracle SQL/PL/SQL.

What are the key technical skills needed for this position?

Key skills include expertise in IBM Cognos Analytics, Oracle SQL and PL/SQL for complex query development and optimization, and highly desirable experience with Looker for LookML model development and dashboards.

Is remote work an option for this role?

This information is not specified in the job description.

What is the salary or compensation for this position?

This information is not specified in the job description.

What does a strong candidate for this role look like?

A strong candidate has 8+ years in BI/Data Analytics, expertise in Cognos and Oracle SQL/PL/SQL, customer focus, leadership to manage multiple projects, and experience mentoring juniors.

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