Job Title : Senior BI & Analytics Engineer (OAC & Databricks)
Position Overview
We are seeking a highly skilled Senior BI & Analytics Engineer with 7+ years of experience to design, develop, and maintain our enterprise-level business intelligence infrastructure. In this role, you will bridge the gap between complex data ecosystems and strategic business decisions. You will be responsible for creating robust analytics applications, interactive dashboards, and scalable data models using Oracle Analytics Cloud (OAC) and Databricks, ensuring seamless data integration across our ERP systems and cloud platforms.
Key Responsibilities
- Dashboard & Application Development: Develop end-to-end analytics applications, pixel-perfect reports, and interactive dashboards utilizing OBIEE, OAS, OAC, and BI Publisher.
- Stakeholder Collaboration: Partner directly with business units and IT leadership to spearhead requirements gathering, manage User Acceptance Testing (UAT), and deploy highly functional OAC reporting canvases.
- Data Visualization: Design intuitive, business-centric visualizations within OAC, effectively converting raw, complex, and unstructured datasets into actionable strategic insights.
- Database Engineering: Build and optimize complex database logic, including advanced SQL queries, stored procedures, views, and custom functions to support a high-performing BI infrastructure.
- Cross-Platform Integration: Utilize Databricks (SQL, Python, and Notebooks) to generate, transform, and seamlessly blend external datasets with native Oracle Analytics products.
Role Requirements
Educational Qualification
- Bachelor’s Degree in Engineering / B.Tech in Computer Science, Information Technology, Data Science, Artificial Intelligence, or a closely related technical field.
Must-Have Technical Skills & Experience
- 7+ years of dedicated experience in BI reporting, analytics, and data modeling.
- Hands-on Expertise: Proven, deep technical experience with Oracle Analytics Cloud (OAC) and Databricks.
- Cloud & Infrastructure: Core understanding and hands-on exposure to any major Cloud platform (AWS, Azure, or GCP).
- RDBMS Mastery: Strong proficiency in Microsoft SQL Server or a similar relational database management system.
- Advanced Database Logic: Exceptional skills in writing complex queries, developing stored procedures, data modeling, and performing rigorous query performance tuning.
- ERP Analytics: Demonstrated experience building BI/Analytics systems layered over major enterprise ERP systems (e.g., Oracle, PeopleSoft, SAP, etc.).
Good-to-Have Skills
- Prior domain experience within the Medical Device and/or Pharmaceutical industry.
- Hands-on functional or technical familiarity with SAP environments
