Job Responsibilities
- Collaborate with business stakeholders to understand functional and reporting requirements, and translate them into efficient technical solutions
- Lead the design, development, and deployment of Cognos reports, dashboards, and data models.
- Act as a subject matter expert (SME) for Cognos Analytics, Oracle SQL, and data analytics best practices.
- Design and optimize complex Oracle SQL queries, PL/SQL procedures, and database views to support BI reporting.
- 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.
- Mentor junior developers and review deliverables for design and performance quality
- 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 a tech lead role, with hands-on technical delivery.
Job Qualification
- 8+ years of experience in BI and Data Analytics with proven expertise in: IBM Cognos , Oracle SQL / PL/SQL – complex query development, tuning, and performance troubleshooting.
- Advanced knowledge in Data Analytics and Business Intelligence concepts.
- Experience in relational database programming, particularly Oracle and advanced-level SQL and PL/SQL.
- Proven experience in performance tuning at the database, report, and visualization layers. SQL query optimization techniques are a must.
- Experience in Cognos Analytics development, Server Configuration and Administration, Packaging and Deployment, Model generation, Report Authoring, and the Cognos Framework Manager (Added Advantage).
- Strong Analytical and problem-solving skills.
- Familiarity with Agile and managed services delivery models with a good understanding of SDLC and ITIL processes
- Ability to work independently or lead a team effectively, meet project deliverables on time
- Excellent communication and customer management skills with an ability to bridge technical and business perspectives effectively.
- Leadership mindset with a focus on mentoring and continuous improvement.
- BE/BTech or ME/ MTech.
Similar Jobs
What We Do
Model N enables life sciences and high tech companies to drive growth and market share, minimizing revenue leakage throughout the revenue lifecycle. With deep industry expertise and solutions purpose-built for these industries, Model N delivers comprehensive visibility, insight and control over the complexities of commercial operations and compliance. Our integrated cloud solution is proven to automate pricing, incentive and contract decisions to scale business profitably and grow revenue. Model N is trusted across more than 120 countries by the world’s leading pharmaceutical, medical technology, semiconductor, and high tech companies, including Johnson & Johnson, AstraZeneca, Stryker, Seagate Technology, Broadcom and Microchip Technology. For more information, visit www.modeln.com.
.jpeg)





.png)