Data Engineer

  • Company: Bestway Consultancy Services
  • Location: Islamabad
  • Department: Information Technology
Position Purpose

This position is responsible for designing and building data models & ETL pipelines to make data available to stakeholders.

Job Description

  • Manage the configuration of a new SQL data platform to enable advanced analytics and reporting.
  • Collaborate closely with IT and the Data owners to establish data flows into the platform.
  • Deliver value-prioritised analytics projects on behalf of internal customers.
  • Manage ETL development and automation (e.g. setting up scheduled pipelines, identifying efficiencies throughout, championing version control)
  • Develop the ETL framework to create a standardised approach to managing data effectively.
  • Create data models & data flow diagrams to help business understand where data is stored.
  • Advise on future design approach & principles.
  • Design and document data catalogues/dictionary.
  • Develop robust ETL processes to provision and transform data.
  • Act as SME for the SQL Data Platform and its underlying technologies providing support to end users.
  • Develop solution options / proof of concepts to various data requirements.
  • Design and document flexible and practical data warehouse models to recommended industry standards.
  • Develop, embrace and embed best practice ways of working, continuously improving processes and ensuring new approaches are adopted by the team for improved efficiencies.
  • Good understanding of data privacy rules and data regulations.

Experience and Qualification

  • Bachelors / Masters in Computer sciences / Engineering / IT.
  • 4 to 6 years of relevant experience. 
  • Data integration development experience using SSIS, ETL frameworks.
  • In-depth SQL knowledge with experience interrogating data from large relational databases.
  • Experience working with cloud technologies would be beneficial.

Specific Requirements

  • A positive team player that is enthusiastic, energetic and creative.
  • Good communication skills with an ability to convey technical concepts to a non-technical audience.
  • Confident self-starter, with strong attention to detail.
  • Mentor and guide the wider team to transition to adopt a single aligned ETL framework.
  • Good Collaboration and Team Ethic skills.
  • Strong Stakeholder Management.
  • Good business acumen/ Customer Focus.