The corporate activities are growing rapidly, and the company is seeking a Data Engineer to join their Information Technology team to accomplish tasks and projects instrumental to the company's success.
Requirements
- Knowledge of developing dimensional data models and awareness of the advantages and limitations of Star Schema and Snowflake schema designs;
- Solid ETL development, reporting knowledge based off intricate understanding of business process and measures;
- Knowledge of Snowflake cloud data warehouse, Fivetran data integration and dbt transformations is preferred;
- Knowledge of Python is preferred;
- Knowledge of REST API;
- Basic knowledge of SQL Server databases is required;
- Knowledge of C-Sharp, Azure development is a bonus;
Responsibilities
- Utilize skills in development areas including data warehousing, business intelligence, and databases (Snowflake, ANSI SQL, SQL Server, T-SQL);
- Support programming/software development using Extract, Transform, and Load (ETL) and Extract, Load and Transform (ELT) tools, (dbt, Azure Data Factory, SSIS);
- Design, develop, enhance and support business intelligence systems primarily using Microsoft Power BI;
- Collect, analyze and document user requirements;
- Participate in software validation process through development, review, and/or execution of test plan/cases/scripts;
- Create software applications by following software development lifecycle process, which includes requirements gathering, design, development, testing, release, and maintenance;
- Provide end-user support including setup, installation, and maintenance for applications
Other
- 3+ years of experience in Data Engineering;
- Communicate with team members regarding projects, development, tools, and procedures;
- Excellent analytical, written and oral communication skills.
- Flexible work environment
- Competitive PTO packages, starting at 20+ days
