IT Business Intelligence Architect

Key Skills

Apache Hadoop, C Programming, C++, Data science techniques, Java Programming, Machine learning techniques, MapReduce, Python Programming, PyTorch, R Programming, Scala Programming, SQL, TensorFlow

Job Description

The BI Architect’s role is to design and build data-centric solutions that provide actionable business insights and deepen analytic capabilities in the Coca-Cola System and in the Asia Pacific region. The BI Architect will be responsible for taking requirements and analysis of business processes and developing applications himself/herself or with help of vendors. This will include ETL/ELT coding, database & architecture design in cloud environment and implementation, and working closely with Data Scientists and Data Visualization developers on solution design.

The role will report into the project manager/ team lead in the Singapore regional development centre

The BI team will be part the Coca Cola company’s regional development centre (RDC) and will serve the entire Asia Pacific group. The mission of the RDC is to leverage the power of data & analytics to identify opportunities to drive growth of the company and enable timely and quality decision making decision making.

Key Results :

• BI/Analytics solutions that meet criteria for business value, cost, time-to-deliver, and reusability
• Enable increasing levels of self-service by business users
• Compliance with industry best practice software and technical architecture standards
• Solution integration and architecture across the System Data Lake platform

Responsibilities:

• Work with subject matter experts and Data/ Business Analysts to understand business data and related processes.
• Using Agile and Dev/Ops methods, build platform architecture using a variety of sources (on-premise such as SQL Server, AAS, cloud IaaS/ PaaS* such as Azure and Oracle). PaaS Azure is used most often.
• Integrate data from a variety of business subject areas: finance, franchise sales, POS, IoT, marketing etc.
• Implement rules & automate data cleansing, mapping, transformation, logging, and exception handling.
• Design, build, and deploy databases and data stores
• Participate in cross-functional teams to promote technology strategies, analyze and test products, perform proofs-of-concept, and pilot new technologies and/or methods.
• Establish and document standards, guidelines, and best practices for teams utilizing the solutions.
• Review vendor solution designs to ensure technology appropriateness, standards compliance, and platform capacity alignment.
• Represent the BI team in strategy reviews, leadership briefings, and cross-organization events.

Job Requirements - The following is a listing of minimum indicated requirements for this job.

Education

• Bachelor’s degree in Computer Science, Management Information Systems, Data Science, or related field.

Related Work Experience :

• 6+ years of experience analyzing data as part of BI/Analytics solution initiatives.
• Experience developing solutions using Microsoft Azure tech stack
• Experience in Analysis Services development preferred

Qualifications :

• Good written and verbal communication skills
• Ability to work with geographically diverse teams via collaborative technologies.
• Expert level skill in SQL, Python and DAX for data processing
• Expert skill in of one, or more, of the following data integration/ETL/ELT tools: Azure Data Factory, Data Bricks, Azure Analysis Services
• Working knowledge of data profiling and data modeling.
• Working knowledge or experience in Dev/Ops and/or GitHub
• Microsoft certificates related to Data / Database is a plus

Core Competencies - The following is a list of top Core Competencies needed for the job.

• Drives Innovative Business Improvements: Develops new insights into solutions that result in organizational improvements; promotes a work environment that fosters creative thinking, innovation and rational risk-taking.
• Balances Immediate and Long-Term Priorities: Seeks to meet critical objectives while considering the impact of those decisions and activities on the ability to achieve long-term goals.
• Delivers Results: Focuses on the critical few objectives that add the most value and channels own and others' energy to consistently deliver results that meet or exceed expectations.
• Imports and Exports Good Ideas: Relentlessly seeks, shares and adopts ideas and best practices in and outside the Company and embraces change introduced by others.
• Develops and Inspires Others: Builds and maintains relationships that motivate, guide, and/or reinforce the performance of others toward goal accomplishments. Develops self and others to improve performance in current role and to prepare for future roles; seeks and provides feedback and coaching to enhance performance.
• Lives the Values: Demonstrates the values of The Coca-Cola Company through words, actions, and by example; fosters an environment that reflects the values of the company.