Description:
Responsibilities
- Building facts tables and working with the data warehouse team to collect information
- Developing the schema for the reports and working with the business analyst to build these reports
- Document procedures and processes
- Perform research and analysis to understand reporting needs and impediments and offer solutions to address needs or resolve impediments
- Incorporate design thinking and agile based concepts into practice
- Perform research and analysis to understand reporting needs and impediments and offer solutions to address needs or resolve impediments Incorporating design thinking and agile based concepts into practice
- Assist in the design, technical recommendations and building of data and system architecture, using Framework Manager, PL/SQL and Cognos Analytics
- Data architecture and modeling for Business Intelligence deliverables (dashboards/active reports etc) for data warehouse solutions
- Provide technical expertise in the use and optimization of data modeling techniques to team members.
- Provide technical assistance, guidance and direction in terms of data analysis and modeling to team members.
- Provide assistance to project team and business users relating to data issues and data analysis concepts.
- Participate in the development of data modeling and metadata policies and procedures.
- Participate in data analysis as a result of new/updated requirements.
- Apply approved changes to logical data models.
- Comply with corporate data architectures, strategies and frameworks, including enterprise data warehouse activities.
- Analyze and evaluate alternative data architecture solutions to meet business problems/requirements to be incorporated into the corporate data architecture.
Job Qualifications and Skill Sets
- Software used: IBM Cognos, Oracle SQL
- Experience in customer facing roles and success leading deep technical architecture and design discussions with senior executives.
- 5+ years of experience with deep understanding of databases and analytics, including relational databases, data warehousing, big data, business intelligence and analytics.
- 5+ years of success in consultative/complex deployment projects.
- Must be willing to learn as this is a fast paced environment