Requirements Gathering: Collect and maintain a set of business reporting requirements.
BI Report Implementation: Implement BI reports based on the collected requirements.
BI Tools Setup and Maintenance: Set up and maintain BI tools, infrastructure, and integration with company data sources.
Data Warehouse Architecture: Work on data warehouse architecture, propose data schema, and optimize data flow for reporting performance and enhancement.
BI Reporting Tools: Utilize BI reporting tools such as Tableau, Power BI, and Pentaho for report development.
Data Modeling: Design data modeling and data schemas (normalized, flat, star, snowflake, etc.).
Database Operations: Understand database operations and optimize for Oracle DB.
Query Optimization: Understand data and query optimization, profiling, and performance monitoring techniques.
ETL Processes: Design and implement ETL processes for data integration.
Database Performance: Monitor, tune, and analyze database performance.
Documentation: Create and maintain business requirements and technical documentation.
Version Control: Ensure all data warehouse architecture codes are maintained in a version control system.
Collaboration: Collaborate with business application technical teams to understand OLTP transactions data structure.
Business Operations: Collaborate with business operations teams to understand BI needs and training requirements.
Training: Conduct training sessions with business teams on leveraging BI analytics
pArtistic Milliners/p