Domain Consultant

Provide technical leadership across a broad range of data analysis functions including data modeling structured query language (SQL) data quality data profiling extracttransformload (ETL) metadata enrichment and management data provenance and lineage report design and other specialized data management functions. Works independently as a senior lead and may manage and direct activities related to analysis design and support of technical data management solutions on various projects ranging in larger projects.

KEY ACCOUNTABILITIES
CUSTOMER

• Elicit analyze and understand business and data requirements to develop complete business solutions including data models (entity relationship diagrams dimensional data models) ETL and business rules data lifecycle management governance lineage metadata and reporting elements.
  
• Apply automation and innovation on new data platforms and ongoing on any new development projects / initiatives aligned to business or organizational strategies
  
• Design and implement reporting platforms including modeling ETL BI framework and be able to deliver complete BI solution that meets business requirements
  
• Design and implement complex ETL frameworks to provide a solution that meets business requirements
  
• Collaborate and build effective working relationships with colleagues across technology and the business to achieve business and IT objectives
  
• Work closely with various technology/project teams to understand the business meaning of data and provide analysis and requirements to ensure the data design is fully understood and the development initiatives are in line with the intended design and standards
  

• Coordinate with other technology work teams such as ITS Architecture TRMIS etc. to ensure project success
  
• Deliver Business or Enterprise Data deliverables for the various related platforms/servers/applications/systems and ensure adherence to Enterprise frameworks
  
• Provide the data analysis and requirements within the enterprise platform (e.g. Hadoop)
  
• Implement processes aligned to data management standards and ensure data quality and data requirements are embedded in and adhered to within the system development deliverables
  
• Develop and maintain knowledge of data available from upstream sources and data within various platforms
  
• Collaborate with business and technology partners to elicit information/data requirement and articulate those requirements in a manner that can be easily understood by team members
  
• May be responsible for the Information Excellence data deliverables including contribution to the overall project business and data requirements documents
  
• Perform data profiling using TD tooling and ad hoc system query languages to validate data analysis
  
• Provide support to the development and testing teams to resolve data issues
  
• Support the user community by helping users interpret the data
  
• Implement maintain and enhance Data Governance Data Quality and related policies in alignment with TDs Enterprise standards and frameworks in collaboration with the Data Managers/Stewards/Owners
  
• Ensure requirements are captured regarding privacy and security of data data governance and access controls
  
• Comply with welldefined enterprise technology delivery practices and standards and project management disciplines
  

EMPLOYEE / TEAM

• Work effectively as a team supporting other members of the team in resolving critical service issues
  
• Prioritize and manage own workload in order to deliver quality results and meet timelines
  
• Support a positive work environment that promotes service to the business quality innovation and teamwork and ensure timely communication of issues/ points of interest.
  
• Participate in knowledge transfer within the team and business units
  
• Continuously enhance knowledge / expertise in own area and keep current with leadingedge technologies trends
  
• Identify and recommend opportunities to enhance productivity effectiveness and operational efficiency of the business unit and/or team
  

BREADTH & DEPTH

• Subject Matter Expert on technical environment/ tools for own area
  
• Subject Matter Expert on business processes and procedures as well as broader organizational issues and technology
  
• Advanced knowledge of business/ organization Bank standards infrastructure architecture and technology in related areas from a design/ support/ solutions perspective
  
• Primary subject matter expert in multiple areas and consults with clients/or project teams with respect to all aspects of research analysis design hardware/ software support and/or development of technical solutions
  
• Works autonomously as a senior/lead on a diverse range of tasks and is relied upon to coach/ educate others
  
• Manages and directs activities related to analysis design and support of technical data management solutions on larger projects
  
• Assignments are highly complex and multifaceted
  
• Acts as a key resource in the exchange of technical information for project teams the business and/or outside vendors
  
• Generally reports to a Senior Manager or Executive
  

Requirements

EXPERIENCE & EDUCATION

Must Haves:

• 810 years of BSA experience in data analytics/data warehouse/data integration through agile environment.
  
• Strong communication interpersonal collaborate
  
• on and negotiation skills to work seamlessly in an agile crossfunctional team with clients vendor(s) and other stakeholders.
  
• Creative innovative and can think outside the box to visualize solutions that meet business needs.
  
• Strong experience in data analysis profiling cleanup data wrangling and validation. Handson experience building data quality checks and writing complex SQL queries.
  
• Experience working in large scale Enterprise Data Lake ingestion and extraction projects.
  
• Experience working with Jira Confluence Bitbucket.
  
• Experience with Data Lake Azure Data Factory DataBricks python Synapse/SQL Server Analytics Zone Azure Scheduler Tableau Power BI.
  
• Demonstrable experience with conceptual logical and physical data modeling techniques.
  
• Strong analytical organizational and technical skills to analyze model and interpret data.
  
• Knowledge with Solutions Development Life Cycle (SDLC) and structured methodologies including agile waterfall and iterative.
  
• Work Experience in investigating analyzing estimating system applications in a large integrated solution environment.
  
• Proven experience with all stages of automated system implementation in complex solutions with online and batch processing of transactions.
  

Nice to Haves:

• Solid knowledge of metadata management principles metadata modeling and writing metadata definitions.
  
• Good understanding of data Security Classifications Risk Assessment (TRMIS) guidelines.
  
• Proven experience with sprint facilitation interpretation of business needs to technical requirements facilitation of project meetings for reviews.
  
• Able to prioritize requirements change requests for Business and work with Project team/Scrum Master in determining how best to address them.
  
• Experience with supporting legacy applications such as Mainframe other onprem applications and Migration of legacy solutions using COTS products.
  
• Experience in current state analysis through reverse engineering identify source & downstream systems.
  
• Experience in conducting feasibility analysis project scoping and providing project work estimates.
  
• Experience with requirements development involving requirements elicitation analysis specification and validation.
  
• Experience with documenting user stories planning and managing product backlog planning and managing sprints and implementing in an iterative manner.
  
• Handon experience in capturing Data Lineage and Data Mapping between Source and Target systems.
  
• Demonstrated experience in the facilitation of project meetings for reviews.
  
• Experience in reporting progress of assignment(s) on a regular basis to Project Management and raise any issues / concerns and propose mitigation strategies.
  
• Experience with Production Support to investigate issues and propose solutions to fix them.
  
• Able to resolve issues in a timely manner provide options and recommendations.
  
• AZ900/DP900 certifications preferred.