What are the responsibilities and job description for the Data Warehouse Engineer position at Ztek Consulting?
Job Title : Datawarehouse Engineer
Location : Hamilton, NJ
Type of hire : Contract
Job Description :
- Have very good experience with ETL frameworks and tools on Cloud platforms using Azure Data Factory with SQL or Python.
- Very good experience in understanding data life cycle and data software development, data engineering with SQL in a Data Warehouse environment, building data pipelines and complex data transformations as well using Relational & NoSQL databases, open data formats, and programming languages such as Python or C#, etc.
- Ability to use one or more of the following tools for data hunting, testing, analytics, and metrics such as SQL IDE’s, and analytics tools such as Power BI or similar tool.
- Implemented Surrogate key by using Key Management functionality for newly inserted rows in Data warehouse which made data availability more convenient.
- Very good understanding and implementation experience with dimensions and fact table designs.
- Participated in the identification of key performance indicators and methods for data warehouse to assist with operational and strategic planning.
- Installed, developed, and maintained a variety of applications to support business intelligence products, data warehouses and reporting systems.
- Designed and implemented daily data migration between central data warehouse server and application / reporting database server and analyst database server.
- Experience in Microsoft Fabric platform or certification preferred.
