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.

To see more jobs that fit your career

Salary Estimator

Discover your current worth in the job market.