Engineer 2 BI Developer

Job Purpose

We are seeking a skilled Business Intelligence Developer with expertise in Oracle BI and Snowflake. The ideal candidate will build and maintain advanced data visualizations in Oracle BI, while also managing back-end data processes using Snowflake and Python. This role requires someone who can work independently across both front-end (dashboard and report design) and back-end (data extraction, transformation, and loading) tasks to ensure reliable, insightful reporting. Familiarity with other BI tools like Power BI, Tableau, and Power Apps is also highly valued, as these tools are part of our broader analytics environment.

Key Accountabilities

• Develop Visualizations: Design, build, and maintain interactive dashboards and reports in Oracle BI to present data insights clearly and effectively.
• Front-end & Back-end Calculations: Perform data calculations and transformations either in the front-end BI tools or in the back-end (within Snowflake or using Python), choosing the best approach for performance and accuracy.
• Data Pipeline Management: Create and manage ETL pipelines to extract data from the Oracle ERP system, transform it using Python to ensure the data is in the correct format, and load it into the Snowflake data warehouse.
• Automation & Scheduling: Set up automated processes (such as cron jobs) to refresh and sync data from Oracle ERP to Snowflake on a daily or hourly schedule, ensuring the data is up-to-date with minimal downtime.
• Data Quality & Reliability: Monitor and troubleshoot the data pipeline and Snowflake environment to ensure high data availability for Oracle BI, leveraging Snowflake's high uptime to minimize any reporting downtime.
• Advanced Analytics & Visualization: Utilize the integrated data (stored in Snowflake) to create advanced visualizations and perform analytics in Oracle BI, enabling deeper business insights.bleau, and integrate them with Power Apps to build interactive business applications, ensuring consistency across different BI platforms.

Key Accountabilities

• Cross-Tool Reporting: If needed, develop additional reports or dashboards in Microsoft Power BI or Tableau, and integrate them with Power Apps to build interactive business applications, ensuring consistency across different BI platforms.
• Collaboration & Requirements Gathering: Work with business stakeholders to gather requirements for new reports and dashboards, translating business needs into technical specifications and delivering intuitive BI solutions.
• Independent Project Execution: Handle projects end-to-end, from data sourcing and modeling to visualization and delivery, working independently and managing timelines effectively.

Education Qualification:

• Education: Bachelors degree in computer science, Information Systems, Data Analytics, or a related field (or equivalent work experience).

Technical Competence & Skills:

• Experience: Proven experience (e.g., 3-5 years) in business intelligence or data analytics roles, developing dashboards and data models.
• Oracle BI Expertise: Hands-on experience with Oracle Business Intelligence (OBIEE or Oracle Analytics) for creating reports and visualizations.
• Snowflake & SQL: Strong proficiency in Snowflake or similar cloud data warehouses, including writing efficient SQL queries and understanding data warehousing concepts (star/snowflake schemas).
• Data Integration: Experience extracting data from enterprise systems (especially Oracle ERP) and transforming it for analysis. Ability to create ETL processes or scripts to handle data migration and integration.
• Python Programming: Proficiency in Python for data processing and automation tasks (e.g., using libraries to clean/transform data, and interacting with databases or APIs).
• Automation Tools: Familiarity with scheduling and automation (cron jobs or similar schedulers) to automate data refresh cycles.
• Front-end Skills: Ability to design intuitive dashboards and perform calculations within BI tools (e.g., creating calculated fields or using DAX/formulas in relevant platforms).
• Analytical Mindset: Strong analytical and problem-solving skills, with attention to detail and a focus on data accuracy and quality.
• Independent Work Ethic: Self-motivated and able to work independently across the full BI stack, managing both back-end data tasks and front-end visualization work.
• Communication: Excellent communication skills to collaborate with stakeholders and translate complex data findings into business-friendly insights.

Preferred Qualifications

• Additional BI Tools: Experience with Microsoft Power BI, Tableau, or similar data visualization tools.
• Power Apps: Familiarity with Microsoft Power Apps and the Power Platform for building custom business applications or integrating BI insights into apps.
• Data Modeling: Knowledge of data modeling techniques and best practices for designing data schemas optimized for reporting performance.
• Cloud & Other Tech: Exposure to cloud platforms or services related to data analytics (e.g., AWS, Azure) and an understanding of data security and governance practices.

Relevant Experience:

• 3-5 years of experience relevant experience.