Job Description

Mô tả công việc Data Warehouse Construction and ManagementCollaborate closely with ERP, Software teams, and functional departments to define data flows and data semantics.Execute ETL processes, establish and manage connections with the data warehouse.Partner with the analytics team to design appropriate data sets for reporting.Adapt data set structures in response to evolving business needs and requirements.Document data structures and definitions, maintaining comprehensive and up-to-date records.Resolve issues related to the database promptly and effectively. Data Warehouse Performance EnhancementDevelop optimal data warehousing and data loading solutions in line with product requirements from the analytics and Machine Learning teams.Collaborate with the IT team to enhance the data warehouse environment, providing advice and proposing solutions to increase storage capacity, improve loading speed, and reduce costs.Monitor the cost and capacity of the data warehouse environment, tracking any issues and resolving them as quickly as possible to ensure the smooth operation of the reporting system and Machine Learning tools. Data Security and IntegrityEstablish and manage outgoing connections from the data warehouse, ensuring stability and security.Monitor for any issues that could compromise data accuracy, alert relevant parties and resolving issues promptly.Yêu cầu công việcBachelor’s degree in computer science, Engineering, or related field, or equivalent work experience.Proven experience as a Data Engineer, Software Developer, or similar.At least 2 years of experience working with large and complex data warehouse systems with hand-on data architecture experience.Proficient in designing and building data models using the Kimball methodology for various data marts (Sales, Finance, Marketing).Advanced skills in SQL and dbt for building, testing, and optimizing data transformation workflows.Hands-on experience with workflow orchestration tools like Airflow, Dagster, or n8n.Experience implementing data quality frameworks, including unit testing and data validation.Strong understanding of various data ingestion patterns (e.g., Incremental, Snapshot, CDC).Knowledge of Power BI data modeling and writing complex DAX queries.Strong organizational and project management skills.

Job Application Tips

  • Tailor your resume to highlight relevant experience for this position
  • Write a compelling cover letter that addresses the specific requirements
  • Research the company culture and values before applying
  • Prepare examples of your work that demonstrate your skills
  • Follow up on your application after a reasonable time period

You May Also Be Interested In