As a Data Engineer, you will be expected to work independently, collect requirements, perform data mapping to warehouse, hands on prototyping, ad hoc process of data files and transform them into structured data that can be ingested on a production basis. The ideal candidate will have a strong background in data engineering, including experience with SQL Server, ETL processes, data modeling, and cloud platforms.
Responsibilities:
- Work with Business Teams to come up with Data Governance Policies.
- Implement processes to process Data Access Request.
- Ensure security and reliability of the data in the warehouse.
- Formulate processes for disaster recovery.
- Work with data SME’s and data architects to create end user friendly data models to support data warehouse setup.
- Possesses excellent knowledge of Relational Database Management Systems (DBMS) and data warehouse front-end tools.
- Be proficient in creating and maintaining database objects and stored procedures.
- Come up with strategies to reduce Data Warehouse cloud costs.
- Contributing team member to the design and support of data architecture, database design and integration, transformations, and load processes.
Job Requirements:
- Bachelor’s or master’s degree in computer science, engineering, or a related field.
- 3+ years in Snowflake data warehouse administration – consuming, wrangling, validating, developing pipelines for data.
- 3+ years of experience working with SQL.
- Familiarity with the basic principles of distributed computing and data modeling.
- Excellent problem-solving and analytical skills, with the ability to troubleshoot complex data issues and optimize data processes.
- Experience with object-oriented design and coding and testing patterns, including experience with engineering software platforms and data infrastructures.
- Working experience with Dimensional Modeling.
- Working with another SQL database like PostGres and SQLServer is a plus.
- Strong written and verbal communication skills.
- Be open to receiving constructive feedback.
Ability to work in a fast-paced, rapidly growing company and handle a wide variety of challenges, deadlines, and a diverse array of contacts.
PostgreSQL OOP data-modeling SQL cloud-platforms ETL Data Engineering Microsoft SQL Server snowflake-cloud-data-platform stored-procedures