Job Responsibilities:
Responsible for eliciting, understanding, interpreting and representing business requirements for data, information delivery and analytics, data integration, metadata, data quality, security, and performance
Responsible for understanding source systems, data flows and their data models
Responsible for analyzing data to validate business domains and requirements
Develop source to target mappings for data lineage (STTM)
Responsible for data profiling and ensuring data quality requirements are accurate and complete
Validates that data integration, data movement, and warehouse meets requirements and service-level agreements
Works with architects to translate requirements into technical specifications
Act as the conduit between the customer and technical teams to ensure requirements are understood
Act in an advisory capacity in data model reviews, architecture approach and solution design to ensure high quality deliverables
Provide technical guidance and mentoring to business and data analysts
Executes and promotes data management strategy
Partners with management and business units on innovative ways to successfully utilize data and related tools to advance business objectives
Responsible for active involvement with Quality Assurance teams in defining the QA strategy, test plans and use cases to validate data
Responsible for communicating planned and unplanned activities to appropriate parties as needed
Coordinates prototype reviews
Technology/Application Requirements:
7+ years’ experience working as a BI analyst or data analyst leveraging BI tools in a centralized data warehouse environment
5-7+ years hands-on experience working with SQL and a strong understanding of different data structures (flat files and DBMS)
3+ years’ experience with data modelling concepts and techniques
Experience working with Cognos v.8.x or higher or similar BI tool is a plus
Experience working with Teradata Data Warehouse or other DBMS is a plus