Data Engineer

Highbrow LLC; Deutschland; Remote; EUR 60.000 - 80.000; Vollzeit

Zusammenfassung

A technology company is looking for a Data Engineer to work remotely. The ideal candidate will have over 5 years of experience in data warehousing, especially with Azure and Snowflake, and proficient in T-SQL for queries. Responsibilities include analyzing solutions, enhancing ETL processes, and creating dashboards with Power BI and Excel. Strong communication skills are required to present findings to management. A Bachelor's degree in Computer Science is preferred.

Qualifikationen

• 5+ years’ experience in a data warehouse team environment.
• Strong data warehousing experience with Azure, Databricks, and Snowflake.
• Demonstrated strength with querying Snowflake with T-SQL.

Aufgaben

• Analysis, design, coding, and implementation of data warehousing solutions.
• Evaluation, maintenance, and enhancement of existing ETL processes.
• Creation of BI dashboards using Power BI and Excel.

Kenntnisse

Data warehousing experience

Azure

Snowflake

T-SQL

Microsoft SQL Server

Power BI

Python

Excellent writing skills

Ausbildung

Bachelor's Degree in Computer Science or related field

Tools

Power BI

Databricks

SSIS

Azure Data Factory

Jobbeschreibung

Job Title: Data Engineer

Job ID: 2023-12455

Job Location: Remote (EST only)

Job Travel Location(s): N/A

# Positions: 1

Employment Type: W2

Candidate Constraints:

Duration: Longterm

# of Layers:0

Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers

Key Technology: Data Warehouse, Azure, Snowflake

Job Responsibilities

• 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.

Skills and Experience Required

Required

• 5+ years’ experience in a data warehouse team environment.
• Strong data warehousing experience with Azure (and GCP and AWS), 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)
• Hands-on experience with SSIS, Azure Data Factory, Azure Databricks, and Snowflake
• Proven skills with data visualization tools: Microsoft Excel (PowerPivot, Pivot Tables, Slicers) Power BI
• Experience with storage devices and connectivity tools such as AWS development tools
• A basic understanding of HTML, CSS, and web page deployment.
• Excellent written and verbal skills and the ability to present to upper management.
• A good understanding of basketball.

Desired

• Experience working with DBT and/or FiveTran

Educational Background

• Bachelors Degree in Computer Science or related field preferred