Role Overview
Data Engineer role reporting to the Manager, Data Systems, focused on developing business intelligence solutions, executing data queries, and delivering reports and visualizations in a collaborative, fast-paced environment.
Responsibilities
- Translate business needs into technical specifications working directly with stakeholders.
- Design, build, and automate data flows from varied sources (APIs, SaaS, flat files, operational databases) into Postgres, handling incremental loads, deduplication, and schema drift.
- Move and model data into the warehouse, building analytical structures (OLAP cubes, semantic models) enabling stakeholder self-serve.
- Maintain and support existing data workflows and reporting.
- Write and optimize complex SQL queries to answer business questions directly.
- Unit-test pipelines and troubleshoot failures by interpreting error logs.
- Collaborate with engineering, analytics, and business teams on system integrations.
- Apply strong analytical skills to collect, organize, analyze, and disseminate significant information with attention to detail and accuracy.
- Demonstrate excellent organizational skills.
- Maintain strong written and verbal communication skills.
Requirements
- 3+ years experience as a Data Developer, analyst, engineer, or Data Scientist.
- Background in data warehouse design, dimensional modeling, and data mining.
- In-depth understanding of database management systems and ETL frameworks.
- Experience with Apache Airflow and Spark.
- Experience creating complex SQL queries and with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
- Knowledge of various data sources (SQL and NoSQL), programming (Python or R), XML, REST API, and JavaScript.
- Experience and comfort working with open-source tooling.
- Linux OS background considered an advantage.
- Analytical mind with proven problem-solving aptitude.
- BSc/BA in Computer Science, Engineering, or relevant field with experience.
- Familiarity with data visualization tools.
- Proven abilities to take initiative, be innovative, and collaborate.
- Positive and supportive work ethic and attitude.