IT Strat & Transf Asst Analyst

Overview Responsible for designing and delivering modern, modular, and scalable data platforms for databases and data warehouses. Develops, implements, and maintains data warehouses to integrate data from various sources and systems within the organization. Creates strategies for data acquisition, archive recovery, and database implementation. Manages data migrations and conversions while troubleshooting data processing issues. Builds data pipelines to ingest, transform, and harmonize internal and external data into business-ready formats to support digital products. Overview Performs tasks and contributes to processes/project components for the Data Engineering and Platforms area under moderate supervision, ensuring work is aligned to organizational standards, escalating problems and roadblocks as they occur. Responsible for designing and delivering modern, modular, and scalable data platforms for databases and data warehouses. Responsibilities This job works under moderate supervision to accomplish key tasks for the Data Engineering and Platforms area, following best practices and techniques in order to meet organizational standards of excellence. Collaborates on data integration projects with team members, ensuring that all relevant data sources are considered and that integration efforts align with organizational standards. Assists in the execution of data migrations and conversions, following established protocols to ensure that data integrity is maintained throughout the process. Organizes data entry and validation tasks to ensure that incoming data is accurately captured and stored in the data warehouse, maintaining high standards of data quality. Provides support in the maintenance of data warehouse components by executing routine checks and updates, ensuring data integrity and accessibility for business intelligence purposes. Analyzes data quality reports to identify discrepancies and trends, assisting in the development of strategies to enhance data governance and processing efficiency. Applies deep understanding of area processes to employ area best practices and methods that align with the overall functional and business strategy, supporting team members on solutions, execution and delivery. Qualifications Python (Programming Language) – Python (Programming Language) is a programming language utilized in web development, data analysis, artificial intelligence, machine learning, and scripting. Methodical – Methodical is defined as the ability to work in a systematic manner or based upon established plan or procedure that has been tried and tested. Managerial Aptitude – Managerial aptitude refers to the ability to organise, oversee and manage a particular team of employees, project or sector within an organization. Learnability – Learnability is the ability to learn and upgrade one's skills in order to adapt to the constantly changing demands of a workplace. SnowFlake – SnowFlake is a cloud-based data warehousing platform that offers a fully managed, scalable, and secure solution for storing, analyzing, and handling both structured and semi-structured data, while seamlessly integrating with various business intelligence and data visualization tools. Strategic Thinking – Strategic thinking is the ability to see beyond short-term needs and is concerned with establishing the long-term direction of a business for gaining an edge in business. Leadership – Leadership is the ability to lead initiatives, motivate teams and be driven to continuously work towards a common organizational goal. Improvisation – Improvisation refers to the process of planning and executing impromptu solutions that improves the capabilities of the end result. Data Engineering – Data Engineering is the practise of developing and constructing large-scale data collection, storage, and analysis systems. Collaboration – Collaboration is the process of two or more individuals, teams, entities, or organizations working together to accomplish a task or achieve a common goal. Extract Transform Load (ETL) – Extract, Transform, Load (ETL) which is the general method of copying data from one or more sources into a destination system that represents the data differently than the source(s) or in a different sense than the source in computing Data Pipelines – Data Pipeline is a set of tools and processes used to automate the movement and transformation of data between a source system and a target repository. Amazon Web Services (AWS) – Amazon Web Services (AWS) offers metered pay-as-you-go cloud computing solutions and APIs to people, businesses, and governments. Professional Ethics – Professional ethics is a set of standards, principles and values that govern the do's and don'ts of an individual's behaviour in a corporate or business environment. Microsoft Azure – Microsoft Azure is a cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services through Microsoft-managed data centers. Analytical Thinking – Analytical thinking is the ability to study a problem and dissect it logically to find a practical solution to the problem. Structured Query Language (SQL) – Structured Query Language (SQL) which is a programming language that is used to communicate with and manipulate databases. Data Modeling – Data Modeling is the act of generating a visual representation of an information system in order to communicate linkages between data elements and structures. Organizing – Organizing is the ability to make arrangements systematically, coordinate activities efficiently or the process of dividing work into sections and departments. Legal Disclaimer This job description describes the general responsibilities of the role; Individual responsibilities are subject to change based on business need and manager discretion.