Key Responsibilities

• Use modern development and modelling techniques and tools to implement BI Solutions that leverage data management components like data quality, metadata and reference data
• Engage with a wide range of technical stakeholders including data scientists, business analysts, data engineers, database administrators and solutions architects.
• Work with data analysts, data engineers and product owners to understand the dynamic nature that is required to support the solution that needs to be built.
• Load large, complex data sets to and make data available for a wide variety of stakeholders
• Source data from internal and external data sources, engaging with technical subject matter experts
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing models for greater scalability
• Designing and building reusable artefacts to improve speed of delivery and reliability of solutions.
• Identifying performance enhancements for BI and Integration solutions.
• Define and create solution level BI and data architecture models that are aligned with business blueprints, non-functional requirements, delivery constraints, data, application and technology standards
• Ensure BI and data security conforms to information security and information governance policies and standards
• Document architecture and solutions for data acquisition, data integration and data modelling

Responsible for developing data warehousing blueprints, evaluating hardware and software platforms and integrating systems. Manages the data warehouse environment which includes data design, database architecture, metadata and repository creation. Translates business needs into long-term architecture solutions. Defines, designs and builds dimensional databases. . Evaluates reusability of current data for additional analyses. Conducts data cleaning to rid the system of old, unused, or duplicate data. Reviews object and data models and the metadata repository to structure the data for better management and quicker access.

What will make you successful in this role?

Qualifications And Experience

• Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering or another quantitative field / National Diploma in an Information Technology related discipline preferred
• 8+ years Data Engineering experience with a solid background in SQL within a BI or Analytics environment is required
• Designing, building and maintaining a modern data platform, including data lakes, data warehouses, business friendly semantic layers required
• Extensive data warehousing and data modelling experience using Kimball required
• Deep technical knowledge and experience delivering data assets using SAP HANA (Calculation Views, Functions and Stored Procedure development) advantageous
• Exposure to integrating SAP HANA models with functional scripting languages (e.g. Python or R) advantageous.
• Exposure to modern data platform technologies that support cloud, big data, real-time data provisioning, advanced analytics and artificial intelligence implementations, including event streaming based data pipelines (e.g. HANA XSA, Cloudera Data Platform, HDFS, Hive, Impala) advantageous.
• Experience working with Orchestration tools such as (Control-M, Atomic, CA7)
• Exposure working with Data Management technologies (e.g. Informatica Data Quality (IDQ), Informatica Enterprise Data Catalog (EDC), Axon, EBX) advantageous
• Experience in agile development desired
• Experience in Financial Services advantageous

Competencies

• Decision Quality: Making good and timely decisions that keep the organization moving forward.
• Communicates Effectively: Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences.
• Ensures Accountability: Holding self and others accountable to meet commitments.
• Business Insight: Applying knowledge of business and the marketplace to advance the organization’s goals.
• Balances Stakeholders: Anticipating and balancing the needs of multiple stakeholders.
• Manages Ambiguity: Operating effectively, even when things are not certain or the way forward is not clear.
• Nimble Learning: Actively learning through experimentation when tackling new problems, using both successes and failures as learning fodder.
• Action Oriented: Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.

Attributes

• Assertive
• Honesty, integrity and respect
• Teamwork
• Can-do attitude
• Performance driven

Qualification And Experience

• Degree or Diploma and the required Certification with 8 to 10 years related experience.