Job Description
Analyzing the Organization's Data Needs:
- Identify data sources, understand the information needs of end users, and convert them into technical requirements for data warehouse design.
Designing Data Models:
- Design analytical data models (such as star and snowflake models) to structure data in multidimensional formats and optimize access to it.
Implementing ETL Processes:
- Design and develop ETL processes to transfer data from various sources, cleanse, normalize, and load into the data warehouse.
- Support and maintain the data warehouse:
- Monitor data health, update tables, and ensure stable and fast system performance.
Performance Tuning:
- Review and improve the efficiency of database queries and structures to increase data retrieval speed.
- Investigate database problems.
Technical Documentation:
- Prepare and maintain documentation related to data structures, data flow maps, ETL processes, and design standards.
Data Quality and Integrity Assurance:
- Implement data quality controls, review discrepancies, and develop solutions to maintain the accuracy and integrity of stored data.
Cross-Functional Collaboration:
- Communicate with data analytics, business intelligence, developers, and project managers to align technical and business goals.
BI and Analytics Project Support:
- Provide appropriate data structures for reporting, predictive analytics, and other data-driven applications.
Use Modern Tools and Technologies:
- Implement new technologies in the data warehouse, such as Cloud Data Warehouse, Metadata Management Tools, and modern ETL tools.
