Data Engineer

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;
• Communicate with team members regarding projects, development, tools, and procedures; and
• Provide end-user support including setup, installation, and maintenance for applications

Qualifications
 

• Bachelor's Degree in Computer Science, Data Science, or a related field;
• 3+ years of experience in Data Engineering;
• 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#, Azure development is a bonus; and
• Excellent analytical, written and oral communication skills.