Business Analyst- Data Governance
Typical Day in Role:
• Working with the delivery teams and Data Office on identifying data sources, mapping data flows, outlining data and payload models, clarifying transformation logic and influence data model development.
• Responsible for translating customer requirements into an architecture and design that will ultimately constitute the blueprint for the solution. Key requirements will be on identifying the correct sources for technology data and working with Data Office teams to build standardized data models.
• Work with business users and subject matter experts to conduct needs analysis, gathering, validating, and refining business requirements.
• Manage complex data analyses in working with both structured and unstructured data, including collating disparate data sets from many sources.
• Profile and analyze source data to determine the best reporting structures to build.
• Standardize, normalize or de-normalize data sets. Automation, Scalability, and Documentation are front and foremost in your thought process.
• Helps with the process of profiling data and ETL logic for documenting end to end data flow and lineage from capture at source, to storage, to delivery and its business intent at each stage (i.e. capture, transformation, fragmentation, editing)
• Conduct dimensional modelling, metadata management, data wrangling, data cleaning and conforming, and warehouse querying.
• Work with other technology partners to brainstorm solutions to problems and support others in their goals.
• Facilitate technology discussions, solutioning process, decision making, and provide technology mentorship with multiple groups including technology teams and across managers, business stakeholders, and vendors
• Collaborate with internal and external technical resources to develop implementation strategies
• Collaborate with development teams to produce technical specifications and systems integration requirements
• Participate in development of Proof of Concepts (POC) and evaluations of new technologies to address business requirements
• Contribute to driving architecture strategy in alignment with our Enterprise Architecture practices
Candidate Requirements/Must Have Skills:
1) 8+ years of experience as a BSA
2) 3+ years’ of industry experience in Data Governance (Collibra, IBM, Talend, others)
3) 2+ years’ experience Data lineage, Data quality, Data modelling and warehousing experience (Collibra, IBM Infosphere)
4) 1+ years’ experience of combined experience with relational databases (Oracle, DB2, Redshift,
JSON, Hadoop and Hive data structures)
5) 3+ years’ experience working in an Agile team environment
Nice-To-Have Skills:
1) 1+ years’ experience with Data Architecture engagements (IBM Architect, ArchiMate)
2) Experience with reference and master data management (IBM RDM)
3) 5+ years of experience building data on premises and cloud warehouse solutions Hands-on experience in analyzing and managing performance, redundancy, and capacity of high volume critical online systems
4) Extensive experience in designing software architecture, SOA, microservices, API management, data modeling
Soft Skills Required:
• Good communication skills
• Presentation skills
• Ability to handle ambiguous situations
• Self-starter type, works with minimal hand holding
Education:
Bachelor’s degree in computer science, IT, or relevant technical field