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

SQL

Informatica PowerCenter

ETL

Looker

Data Visualization

Data Quality

Data Reconciliation

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