Job closed
Job description / Role
The Business Intelligence(BI) Specialist’s role is to strategically design and implement BI software and systems, including integration with databases and Data Marts/Warehouses. This includes selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users.
The BI Specialist is also responsible for ensuring high levels of BI availability through support functions and in-depth testing.
• Help key stakeholders think clearly about what kind of analytical data and reports they need for better decision making
• Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders
• Direct, organize and lead projects in the implementation and use of new BI software tools and systems
• Lead the integration efforts for merging BI platforms with enterprise systems and applications
• Design, code, test, and document all new or modified BI systems, applications, and programs
• Develop the semantic layer, metadata, reports, and report definitions
• Develop graphs and portal interfaces
• Assist in the design of databases and Data Marts/Warehouses
• Analyze user requirements and, based on findings, design functional specifications for BI front-end applications
• Ensure that all projects are delivered as per the agreed SDLC lifecycle and project management methodologies from requirements capture and analyses through to business sign off and go-live
• Design and deliver end-user training and training materials; provide technical support
• Troubleshoot BI tools, systems, and software; performance-tune these applications
• Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments
• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system
• Evaluate and select ETL software and metadata management tools
• Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts
Requirements
• A Bachelor’s degree in Computer Science or equivalent
• 4 years of dedicated ETL development using ETL solutions
• 7 years overall experience in the Business Intelligence & Data Mart/Warehouse: requirements analysis, ETL, BI tools and analytics
• 7 years’ experience with online analytical processing (OLAP), statistical analysis, forecasting, and data mining
• A minimum of 3 years’ experience with Oracle OBIEE
Key attributes:
• Solid understanding of Data Warehouses, Data Marts, ODS, MDM methodologies and life cycle as well as ETL and PL/SQL
• Experience deploying and supporting large, complex /business intelligence solutions (full life cycle)
• Comprehensive Data Mart/Warehouse analysis and design experience, with full knowledge of Data Mart/Warehouse methodologies and data modeling
• Experience designing, documenting ETL
• Experience with Oracle, SQL, UNIX and Shell Scripting etc.
• Experience with data cleansing and data quality processes
• Ability to analyze and design data conversion and integration tools, processes and practices
• Strong ability to analyze user requirements and build front-end BI applications according to specifications
• Experience with data processing flowcharting techniques
• Extensive and substantial practical experience with data management and data interchange
About the Company
Cielo is the world's leading strategic Recruitment Process Outsourcing (RPO) partner, dedicated to ensuring our clients attract and hire better talent faster, all while providing a world-class candidate experience. Many RPO providers think more like outsourcers than recruiters, but we immerse ourselves in your industry, brand and values, and are accountable for driving real business results. Or, as we like to say, WE BECOME YOU.