Engineer 2 BI Developer

Job Description

Role Overview:You will be responsible for developing and maintaining advanced data visualizations in Oracle BI and managing back-end data processes using Snowflake and Python. Your role will involve working independently on both front-end (dashboard and report design) and back-end (data extraction, transformation, and loading) tasks to ensure reliable and insightful reporting. Familiarity with other BI tools like Power BI, Tableau, and Power Apps will be highly valued in this position.Key Responsibilities:- Design, build, and maintain interactive dashboards and reports in Oracle BI to present data insights clearly and effectively.- Perform data calculations and transformations in either front-end BI tools or back-end systems (Snowflake or Python) to ensure optimal performance and accuracy.- Create and manage ETL pipelines to extract data from the Oracle ERP system, transform it using Python, and load it into the Snowflake data warehouse.- 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 up-to-date data with minimal downtime.- Monitor and troubleshoot the data pipeline and Snowflake environment to ensure high data availability for Oracle BI, leveraging Snowflakes high uptime to minimize reporting downtime.- Utilize integrated data stored in Snowflake to create advanced visualizations and perform analytics in Oracle BI for deeper business insights.- Develop additional reports or dashboards in Power BI or Tableau, integrate them with Power Apps to build interactive business applications, ensuring consistency across different BI platforms.- Work with business stakeholders to gather requirements for new reports and dashboards, translating business needs into technical specifications and delivering intuitive BI solutions.- Handle projects end-to-end, from data sourcing and modeling to visualization and delivery, working independently and managing timelines effectively.Qualification Required:- Education: Bachelors degree in computer science, Information Systems, Data Analytics, or a related field (or equivalent work experience).- Experience: 3-5 years of proven experience 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.- Data Integration: Experience extracting data from enterprise systems (especially Oracle ERP) and transforming it for analysis. Ability to create ETL processes or scripts for data migration and integration.- Python Programming: Proficiency in Python for data processing and automation tasks, 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.- Analytical Mindset: Strong analytical and problem-solving skills with attention to detail and focus on data accuracy and quality.- Independent Work Ethic: Self-motivated and able to work independently across the full BI stack.- Communication: Excellent communication skills to collaborate with stakeholders and translate complex data findings into business-friendly insights.Additional Details:The company values experience with Microsoft Power BI, Tableau, or similar data visualization tools, familiarity with Microsoft Power Apps and the Power Platform, knowledge of data modeling techniques, exposure to cloud platforms related to data analytics, and an understanding of data security and governance practices. Role Overview:You will be responsible for developing and maintaining advanced data visualizations in Oracle BI and managing back-end data processes using Snowflake and Python. Your role will involve working independently on both front-end (dashboard and report design) and back-end (data extraction, transformation, and loading) tasks to ensure reliable and insightful reporting. Familiarity with other BI tools like Power BI, Tableau, and Power Apps will be highly valued in this position.Key Responsibilities:- Design, build, and maintain interactive dashboards and reports in Oracle BI to present data insights clearly and effectively.- Perform data calculations and transformations in either front-end BI tools or back-end systems (Snowflake or Python) to ensure optimal performance and accuracy.- Create and manage ETL pipelines to extract data from the Oracle ERP system, transform it using Python, and load it into the Snowflake data warehouse.- 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

Keyskills :
Oracle BISnowflakePythonPower BITableauSQLData IntegrationETLData WarehousingAutomation ToolsCommunicationPower AppsPython ProgrammingFrontend Skills