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

SQL

Oracle SQL

Cognos

Looker

stored procedures

BI reporting

data analysis

code reviews

source control

requirements gathering

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