Description

• Understands, articulates, and applies principles of the defined strategy to routine business problems that involve a single function.

Data Transformation and Integration

• Extracts data from identified databases.

• Creates data pipelines and transforms data to a structure that is relevant to the problem by selecting appropriate techniques.

• Develops knowledge of current analytics trends. Data Source Identification

• Supports the understanding of the priority order of requirements and service level agreements.

• Helps identify the most suitable source for data that is fit for purpose.

• Performs initial data quality checks on extracted data. Data Modeling

• Analyses complex data elements, systems, data flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models.

• Develops the Logical Data Model and Physical Data Models including data warehouse and data mart designs.

• Defines relational tables, primary and foreign keys, and stored procedures to create a data model structure.

• Evaluates existing data models and physical databases for variances and discrepancies.

• Develops efficient data flows.

• Analyses data-related system integration challenges and proposes appropriate solutions. Code Development and Testing

• Writes code to develop the required solution and application features by determining the appropriate programming language and leveraging business, technical, and data requirements.

• Creates test cases to review and validate the proposed solution design.

• Creates proofs of concept.

• Tests the code using the appropriate testing approach.

• Deploys software to production servers.

• Contributes code documentation, maintains playbook, and provides timely progress updates. Problem Formulation

• Translates business problems within one's discipline to data-related or mathematical solutions.

• Identifies what methods (for example, analytics, big data analytics, automation) would provide a solution for the problem.

• Shares use cases and gives examples to demonstrate how the method would solve the business problem. Applied Business Acumen

• Provides recommendations to business stakeholders to solve complex business issues.

• Develops business cases for projects with a projected return on investment or cost savings.

• Translates business requirements into projects, activities, and tasks and aligns to overall business strategy.

• Serves as an interpreter and conduit to connect business needs with tangible solutions and results.

• Recommends new processes and ways of working. Data Governance

• Establishes, modifies, and documents data governance projects and recommendations.

• Implements data governance practices in partnership with business stakeholders and peers.

• Interprets company and regulatory policies on data.

• Educates others on data governance processes, practices, policies, and guidelines.

• Provides recommendations on needed updates or inputs into data governance policies, practices, or guidelines. Required Skills

• Data Strategy

•

 Data Transformation and Integration

• Data Pipeline Development

• Data Source Identification

• Data Quality Validation

• Conceptual, Logical, and Physical Data Modeling

• Data Warehouse and Data Mart Design

• Relational Database Design

• Stored Procedures

• Data Flow Design and Optimization

• System Integration Analysis

• Code Development

• Test Case Creation • Proof of Concept Development

• Software Testing • Production Deployment • Code Documentation

• Analytics • Big Data Analytics • Automation • Business Case Development • Business Requirements Translation • Data Governance • Regulatory and Company Policy Interpretation • Stakeholder Management • Process Improvement and Recommendations

Key Skills

Education

Bachelor's degree