Data Engineer - Data Integration & Warehousing

Role : Data EngineerShifts : UK Shift TimingsExperience Range : 7+ yearsJob Requirements :- Excellent understanding of data structures with 5+ years of experience in enterprise-wide data platforms design and implementation.- Strong knowledge of common design patterns used in Data Integrations and Warehousing.- Proficient knowledge and experience in developing solutions based on 3NF conformed as well as consumption data models.- Experience in partnering with architects, engineers in data environments that are complex, enterprise wide, multi-tenant, and host large volumes of data.- Strong hands-on SQL experience across various technology stacks, such as SQL Server, Oracle, Snowflake, using the following languages/tools : T-SQL, PL/SQL, SnowSQL, Visual ETL and especially Python, Spark, Bash and/or Shell scripting in a AWS Cloud environment- Intimate familiarity with various file formats, such as but not to limited to: parquet and JSON.Essential Job Functions : - Build reusable data pipelines and platforms that can ingest and parse raw data from different authoritative data sources and deliver standardized data to the downstream consumers at Client.- Develop clean, safe, testable, and cost-efficient solutions, with an eye towards the Client strategic future; Build efficient and reliable pipelines, platforms with underlying raw, cleansed, conformed and consumption data models that can quickly scale and respond to business needs as well as future growth.- Work with product manager to translate business requirements into scalable solutions, prioritize workload and deliver quality, flexible and functional products on a timely manner that can continue to be enhanced without significant material investment.- Understand the system you are building, anticipate shortcomings and be able to resolve or compromise as deemed appropriate, based on guidance from Client leadership. (ref:hirist.tech)