Senior Consultant – SQL, Informatica & Data Visualization

Model N is seeking an experienced and innovative senior technical consultant to join our Global Services team. The right candidate must be exceptionally strong and experienced as a technical consultant. As a key member of the technical team, you will be responsible for software development and customization with operational oversight and the ability to respond appropriately to both project and operational issues to our global clients’ needs. You will work closely with cross-functional teams—including delivery, product, engineering, and support — to ensure solutions align with business goals and technical standards. As a member of the Application Services (AS), the ideal candidate will collaborate closely with business stakeholders, product teams, and project teams to ensure delivery of high-quality, accurate, and insightful reports and dashboards that enable data-driven decisions. In addition to proven expertise in the implementation of enterprise-class Analytic software packages (based on ETL tools like Informatica & SQL), the successful candidate must possess strong customer focus and be able to take ownership implementation and operation of multiple projects or work streams simultaneously.

Job 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.


• This is an individual contributor role, with hands-on technical delivery.

Job Qualification

• 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.

About Model N

Model N is transforming how Life Sciences companies manage revenue, commercialization, and compliance.

For more than 25 years, Model N has been the leader in end-to-end commercialization, revenue optimization, and compliance for pharmaceutical and medical technology companies.

Our intelligent, cloud-based platform combines technology, data, analytics, AI, and industry expertise to help leading Life Sciences organizations optimize revenue, navigate complex regulations, improve decision-making, and bring life-changing products to market faster.

Today, 150+ leading companies across the globe trust Model N to optimize growth and transform critical commercial processes. Our solutions manage approximately $1.3 trillion in gross revenue, helping customers reduce complexity, strengthen compliance, and unlock new opportunities for growth.

At Model N, we are building the next generation of Life Sciences revenue management—where technology, data, AI, and human expertise come together to create meaningful business impact.

Join us to build technology that powers innovation in Life Sciences and makes a difference at global scale.

For more information, visit www.modeln.com.