5+ years of experience in a data warehouse team environment.
Strong data warehousing experience with Azure, Databricks, and Snowflake.
Demonstrated strength with querying Snowflake and other DBs with T-SQL for database queries, procedures, tables, views, etc.
Advanced level of experience with Microsoft SQL Server, Azure, and SSMS (Management Studio)
Requirements:
Analysis, design, coding, performance tuning, and implementation of new data warehousing solutions.
Evaluation, maintenance, and enhancement of existing ETL processes.
Creation of BI dashboards and workbooks using Power BI and Excel.
Code data ingest solutions (Python, Databrick Notebooks, NodeJS) leveraging 3rd party APIs.
Job description
Data Engineer Location: Remote (EST) Duration: Contract
Rate: DOE US Citizens, GC, EAD ( H4, L2), E3 TN visa holders preferred, NO third party corp to corp accepted for this job
What You Will Do:
Analysis, design, coding, performance tuning, and implementation of new data warehousing solutions.
Evaluation, maintenance, and enhancement of existing ETL processes.
Creation of BI dashboards and workbooks using Power BI and Excel.
Code data ingest solutions (Python, Databrick Notebooks, NodeJS) leveraging 3rd party APIs.
Daily triage of bugs and tasks.
Create documentation for applications and processes.
Enforce best practices in all aspects of work and evaluate new data warehousing platforms and solutions.
Requirements
5+ years' experience in a data warehouse team environment.
Strong data warehousing experience with Azure, Databricks, and Snowflake.
Demonstrated strength with querying Snowflake and other DBs with T-SQL for database queries, procedures, tables, views, etc.
Advanced level of experience with Microsoft SQL Server, Azure, and SSMS (Management Studio)
Proven skills with data visualization tools: Microsoft Excel (PowerPivot, Pivot Tables, Slicers)
Experience with storage devices and connectivity tools such as AWS development tool
A basic understanding of HTML, CSS, and web page deployment.
