Database Design: Create, implement, and maintain robust database designs that support financial reporting, analytics, and data integration.
Data Analysis: Analyze financial data sources to identify and document data requirements, relationships, and dependencies.
ETL Processes: Work with data engineers to design and optimize ETL processes, ensuring data is accurately transformed and loaded into the data warehouse.
Data Governance: Establish and enforce data modeling and database design standards, policies, and procedures to ensure data quality and consistency.
Collaboration: Collaborate with finance teams, business analysts, and IT to understand business needs and translate them into technical solutions.
Performance Tuning: Optimize database performance, troubleshoot issues, and implement solutions to enhance data retrieval times.
Documentation: Maintain comprehensive documentation of data models, database structures, and data flows.