Data Warehousing Engineer

Data Warehousing Engineer Job Description Template

Our company is looking for a Data Warehousing Engineer to join our team.

Responsibilities:

  • As a Data Warehouse Engineer in our team, you should have a proven ability to deliver high quality work on time and with minimal supervision;
  • Maintain and develop all logical and physical data models for enterprise data warehouse (EDW);
  • Design, develop, test, and support the data warehouse solution;
  • Adapt best practices and industry standards, ensuring top quality deliverable”s and playing an integral role in cross-functional system integration;
  • Data integration using enterprise development tool-sets (e.g. ETL, MDM, Quality, CDC, Data Masking, Quality);
  • Interact with end users/clients and translate business language into technical requirements;
  • Acts independently to expose and resolve problems;
  • Contributes to the long-term vision of the enterprise data warehouse (EDW) by delivering Agile solutions;
  • Participate in data warehouse health monitoring and performance optimisations as well as quality documentation.

Requirements:

  • Ability to handle/ingest very huge data sets (both real time data and batched data) in an efficient manner;
  • Experience with analytic and reporting tools (Tableau, Power BI, SSRS, SSAS);
  • Experience in AWS cloud stack (S3, Glue, Red-shift, Lake Formation);
  • Knowledge of Logistics and/or Transportation Domain is a plus;
  • Experience in various DevOps practices helping the client to deploy and scale the systems as per requirement;
  • Strong verbal and written communication skills with other developers and business client;
  • 2+ years experience working in software development & data warehouse development for enterprise analytics;
  • 2+ years of working with Python with major experience in Red-shift as must and exposure to other warehousing tools.