Senior Consultant – SQL, Informatica & Data Visualization at Model N

Hyderabad, Telangana, India

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Technology, AnalyticsIndustries

Requirements

Bachelor’s degree in computer science or related discipline
5+ years’ experience in Analytics software development & delivery of enterprise Analytics software implementations using Informatica, with at least 3 years of experience in an analytics developer role
Proven capability to interpret complex business requirements—both functional and technical—and convert them into well-structured data models and meaningful visualization designs
Advanced knowledge in Data Warehouse concepts
Advanced knowledge in Data Analytics and Data Visualization concepts
Hands-on experience with relational databases, particularly Oracle, including advanced SQL and PL/SQL programming
Proficiency in developing Informatica mappings, sessions, and workflows, with experience in monitoring ETL processes and resolving errors/failures
Experience with analytics tools such as Looker is highly desirable, including LookML development
Proven ability in performance tuning: optimizing SQL queries, Informatica workflows, and analytical solutions
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

Responsibilities

Design, develop, and maintain ETL workflows using Informatica PowerCenter to extract, transform, and load data from multiple sources
Ensure data quality, integrity, and performance through validation and optimization techniques
Develop and enhance data visualization dashboards using tools such as Looker
Participate or drive data reconciliation activities
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 Analytics 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
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

SQLInformatica PowerCenterETLLookerData VisualizationData QualityData Reconciliation

Questions & Answers

Common questions about this position

What experience is required for this Senior Consultant role?

Candidates need a Bachelor’s degree in computer science or related discipline, 5+ years in Analytics software development and delivery using Informatica, and at least 3 years in an analytics developer role.

What key technical skills are needed for this position?

The role requires expertise in designing and developing ETL workflows using Informatica PowerCenter, SQL, data quality validation, and data visualization using tools like Looker.

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 makes a strong candidate for this Senior Consultant position?

A strong candidate has proven capability to interpret complex business requirements into data models and visualizations, strong customer focus, ability to handle multiple projects, and experience across the full BI software development life cycle.

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