The Senior Consultant will lead BI software development and implementation, collaborate with stakeholders, and optimize SQL queries, focusing on customer needs and project milestones.
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 Life Sciences Application Services, the candidate will lead a small group of consultants to customize, implement, and deploy Model N BI applications. In addition to proven expertise in the implementation of enterprise-class BI software packages (based on BI tools like IBM Cognos & 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
- 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.
- This is an individual contributor role, with hands-on technical delivery.
Job Qualification
- 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 is 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 is highly desirable, including LookML development
- 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
About Model N
Model N is the leader in revenue optimization and compliance for pharmaceutical, medtech and high-tech innovators. For more than 25 years, we have helped customers maximize revenue, streamline operations, and maintain compliance through cloud-based software, value-add services, and data-driven insights. With a focus on innovation and customer success, Model N empowers life sciences and high-tech manufacturers to bring life-changing products to the world more efficiently and profitably. Model N is trusted by over 150 of the world’s leading companies across more than 120 countries. For more information, visit www.modeln.com.
Top Skills
Business Intelligence
Cognos
Data Analytics
Looker
Oracle
Pl/Sql
SQL
Model N Hyderabad, Telangana, IND Office
Unit No. 1001, 10th Floor, Building No. 12D, Mindspace Sez, Hitech City, , Hyderabad, Telangana , India, 500032
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The Sr. Software Engineer will create file format parsers, collaborate on machine learning features, and maintain software systems. Responsibilities include testing, optimization, and documentation.
Top Skills:
AWSAzureBitbucketC++GCPGitJenkinsJIRAPythonRust
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The Engineering Manager will lead the Linux sensor development team, manage engineers, drive technical strategy, and ensure high code quality for cybersecurity features.
Top Skills:
CC++EbpfKubernetesLinuxUnix
Information Technology • Consulting
Manage the planning, development, and launch of websites on WordPress, ensuring client objectives are met. Collaborate with various teams for project success.
Top Skills:
CSSHTMLJavaScriptPHPWordpress
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
