RQ08279 - Specialized IT Consultant - Senior

Responsibilities Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organizations I&IT systems. The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT. Provides subject matter expertise in their field and highly expert technical assistance. General Skills Acts as the technical advisor/expert on all aspects of a specific deliverable Provide the quality assurance/quality control of specific deliverables Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations Develops processes and procedures for implementing deliverables Prepares reports and presentations including options, recommendations, implementation plans, etc. Works with clients to define the scope of a project and to determine requirements Defines software, hardware and network requirements Analyzes I&IT requirements giving independent and objective advice on the use of I&IT Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems Familiar with change-management principles and methodology Knowledge and understanding of Information Management principles, concepts, policies and practices Additional Responsibilities This role will focus on data architecture, data warehousing, data lakes, and analytics. The individual will be designing, developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in Databricks for data warehousing, data lakes, and analytics. The individual will work closely with data architects and business teams to ensure the efficient transformation and movement of data to meet business needs, including handling Change Data Capture (CDC) and streaming data. · Review business requirements, familiarize with and understand business rules and transactional data model · Define conceptual, logical model and physical model mapping from data source to curated model and data mart. · Analyze requirements and recommend changes to the physical model. · Develop scripts for the physical model, create database and/or delta lake file structure. · Access Oracle DB environments, set necessary tools for developing solution. · Implement data design methodologies, historical and dimensional models · Perform data profiling, assess data accuracy, design and document data quality and master data management rules · Functionality Review, Data Load review, Performance Review, Data Consistency checks. · Help troubleshooting data mart design issues · Review performance of ETL with developers and suggest improvements · Participate in end-to-end integrated testing for Full Load and Incremental Load and advise…