Senior Data Warehouse Engineer

Key Responsibilities

  • Designs, Develops, and Implements data models to visualize and create a big picture of the data needs of business use cases. Working with team members to develop, test and implement the exchange of data, on-going operations (including quality and automation), and work continuously to improve the build and development platform
  • Develops functional technical specifications and implements best practices to gather, store, and transform data to meet the needs of the functional specifications of the business use cases. Performs, tests, validates data flows and prepares ETL processes according to business requirements by incorporating business requirements into the design specifications.
  • Guides BI system operations for overall compliance with quality control standards and reporting to ensure system is running within the defined processing windows. Moreover, communicating to them the schema required for their reports with respect to product frontend.
  • Provides support to adhoc queries and interacts with data exchange partners (internally and externally). Performs other duties as assigned.
  • Maintains effective awareness of production activities per standards and provides support to all existing applications and owners.

Experience Requirement

  • Bachelor’s or Master’s Degree in Computer Science or related discipline.
  • 4 – 7 Years of related experience.

Desired Skill Set

  • Core concepts of Data warehousing (Specifically about Kimball’s Methodology of Data Warehousing).
  • Experience in creating and implementing Data Models, robust Data Architecture with industry standards.
  • Extensive ETL/ELT experience, preferably using Talend Studio and MS Fabric
  • Expert knowledge with RDBMS based databases including MySQL, PostgreSQL
  • Ability to write ad hoc SQL queries & optimize them using various methods.
  • Experience with Python is required.
  • Experience required in Apache Airflow or any other data orchestration tool.
  • Knowledge of Big Data Framework such as Databricks, Hadoop Ecosystem and Azure Data Engineering Ecosystem
  • Good to have experience in PowerBI.
  • Knowledge of new tools in the market specifically for Data Engineering

Required Behavioral Traits

  • Dependable, Enthusiastic, Motivated, Team Player
  • Ability to work independently and in time sensitive environments.
  • Good communication and interpersonal skills
  • Highly organized and detail oriented.
  • Excellent problem solving.
  • Ability to stay calm and perform well under stressful conditions.
  • Promote positive tone and high standards of quality within the group or department and serve as a model to other team members.
  • Ability to learn new tools quickly.

Send us your resume at [email protected] mentioning the position in subject line.