Business Intelligence Engineer

Roles and responsibilities

The Business Intelligence (BI) Engineer is responsible for the end-to-end design, development, and maintenance of BI solutions, including data warehousing, integration layers, and dashboard development using enterprise BI tools. The role requires close collaboration with various departments to translate raw data into structured, meaningful insights for optimized decision-making processes. The position demands a strong technical understanding of data architecture and business intelligence frameworks.

• Design, implement, and maintain the data warehouse architecture to ensure data integrity scalability and efficiency.
• Create and maintain data models to support reporting and analytics initiatives.
• Optimize ETL processes for data extraction, transformation, and loading, ensuring data integrity and accuracy. Ensure data from multiple sources is aggregated, cleansed, and stored accurately in data warehouses.
• Develop and maintain a variety of reports and dashboards using business intelligence tools (OBIE, Power BI).
• Implement and enforce data governance policies and procedures to ensure data quality and security.
• Use current change control standards and SDLC to successfully implement solutions.
• Collaborate with cross-functional teams to integrate Oracle applications with other enterprise tools and applications.
• Take ownership and resolve service requests within SLA timelines.
• Lead the planning and implementation of application and technology updates and upgrades.
• Ensure data integrity and security across Oracle platforms.
• Document technical processes and develop user guides for new applications.
• Develop and manage BI tools, dashboards, and reporting systems using tools such OBIE/OAC, Power BI, or other relevant platforms.
• Conduct data analysis to identify trends, patterns, and insights that can drive business decisions. Collaborate with business users to gather requirements and translate them into technical specifications.
• Optimize SQL queries, BI tools, and data pipelines to enhance performance and ensure efficient data retrieval.
• Document BI systems and processes to ensure transparency and facilitate maintenance and knowledge transfer.
  

Required Qualification

• Bachelor's or Master's degree in computer science, Information Systems, Data Science or a related field.
• Minimum of 8 years of experience with Oracle BI applications, Power BI
• Experience in creating data warehouse (e.g., star schema)
• Experience with data modeling tools
• Familiarity with big data technologies (e.g., Hadoop, Spark) is a plus
• Experience with cloud-based data warehousing solutions (e.g., AWS Redshift, Google Big Query, Snowflake) is a plus.
• Experience with scripting languages (e.g., Python, R) is a plus.
• Strong communication and collaboration abilities. Strong analytical, troubleshooting, performance tuning, and debugging skills.
• Understanding of data governance, data quality, and security practices
• Experience in Waterfall and Agile Methodology

Desired candidate profile

• Experience with data modeling tools
• Familiarity with big data technologies (e.g., Hadoop, Spark) is a plus
• Experience with cloud-based data warehousing solutions (e.g., AWS Redshift, Google Big Query, Snowflake) is a plus.
• Experience with scripting languages (e.g., Python, R) is a plus.
• Strong communication and collaboration abilities. Strong analytical, troubleshooting, performance tuning, and debugging skills.
• Understanding of data governance, data quality, and security practices
• Experience in Waterfall and Agile Methodology
  

Required Professional Skills

• Oracle Database: SQL, PL/SQL, Java
• Application Development: Reports, BI publisher, Application APIs, Oracle Forms
• Application Technology: Oracle Alerts, Oracle Business Events, Workflow, Web ADI, OAF, APEX is a plus.
• Integration Technologies: Informatica, Data Warehouse Administration Console (DAC), Oracle Data integrator (ODI) Oracle Integration Cloud (OIC), Integration SOA Gateway, Rest APIs, familiar with XML, XSLT, and JSON data formats.
• Cloud: Oracle Cloud Infrastructure and cloud migration strategies.
• Reporting and analytics with Oracle BI, Power BI