The BI Developer is primarily responsible for design, development, and testing of ETL and data warehouse solutions. This individual will work with the Business Analyst and the Data Analyst to understand and analyse requirements and develop BI solutions using Intelligence tools and underlying technologies.
• Utilize best practices to select and design the data warehouse architecture
• Design and develop both relational and dimensional data models
• Analyse data sources and target data models
• Develop scalable, reusable ETL jobs using the selected ETL tool for an engagement
• Create and maintain technical design documentation
• Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling
• Utilize Integration Services to construct enterprise level ETL procedures, ensuring data integrity and proper data transformations to load data into the target data structure (warehouse, data mart, etc.)
• Utilize Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Dimensions, and Cubes while adhering to enforced development methodologies.
• Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests. Convert existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products. Determine testing needed to assure the functionality and integrity of reporting solutions, create test plans, and evaluate testing results taking corrective action as necessary.
• Bachelor's degree preferably in Business Administration/Management or Information Technology/Computer Engineering related courses or equivalent
• Formal training or certification in DB, SQL or ETL toolsets is desirable
• Experience in a similar development and consulting roles in a fast paced, retail or hospitality environment is desirable
• Required competencies include but are not limited to the following: databases and user support, building data-marts and data warehouses from ground up
• Strong knowledge of database technologies and T-SQL scripting
• Microsoft SQL Server (Development & Admin)
• Proven knowledge in ETL tool (e.g. Microsoft SSIS, Wherescape RED) and in ETL tool suite design and construction
• Good understanding Star Schema BI Models and Microsoft SSAS
• Must have desirable skills:
- Data Modelling
- OLTP / OLAP / ODS
- Source Control
- JIRA and Confluence
- Software Development Lifecycle (SDLC)
• A working knowledge of SSAS to maintain and enhance developed cubes
• Excellent written and verbal communication skills
• Ability to communicate with the Business Analyst, Technical Analyst when it comes to converting the ETL into specific development activities
• Strong analytical and problem solving ability
• Strong attention to detail and accuracy
• Good working knowledge of membership management systems, and the fitness industry in general, is desirable
• Has an outstanding customer service skills and sales drive
• Must have an interest in health and fitness
• Self-motivated with confidence to approach customers/corporates and the ability to provide conflict resolutions
• Develops effective working relationships with a positive attitude and outlook
• Takes responsibility for their own actions with full honesty and integrity
• Willingness to undertake personal and professional development
• Willingness to attend corporate events outside of normal working hours
• Willingness to take on board Company’s Core Values
• Must be willing to work in Makati and/or BGC in an early morning shift (7:00AM – 4:00PM)
For interested applicants, send your resumes to firstname.lastname@example.org.
Philippines, Pasig, NCR - ncr...
Senior Pharmacy Benefits Analyst - NCR
Philippines, Taguig, NCR - fresher, ncr, pharmacy, taguig, analyst, sm,...
IP Data Analyst
Philippines, Makati, NCR - customs, patent, ip, ncr, administrative,...
Philippines, Manila, NCR - ncr, etl, datastage, data, migration, ibm, cloud,...
Cantonese Data Analyst in Taguig
Philippines, Taguig, NCR - data analyst, ncr, taguig, native, schedules,...
Warehouse Staff for Logistics Pasig Area
Philippines, Pasig, NCR - ncr, forklift, vocational...
Data Analyst Assistant Supervisor
Philippines, Mandaluyong, NCR - data analyst, ncr, analyst, data, publishing, bi,...