Position: DB/DWH/BI/ETL Architect
Company: Blackthorn
Category: Lead
Experience required: 3y
English level: intermediate
Published: 2022-07-01T00:00:00+03:00

Responsibilities:
- Business requirements collection and analysis (bus matrix - at least)
- Relational DB design
- OLAP data warehouse design (layers, star schema - at least)
- ETL design 
- BI dashboards design
- Technical leadership for Data Engineers, Database Engineers, ETL developers, Business Analysts, etc.
- Cooperate closely with a project manager to deliver perfect operational performance.
- Ability to carry technical project ownership
- Development of monitoring systems to measure usage and ensure operational stability.

Required Skills:
- Architected, led, and successfully delivered more than 5 OLAP data warehouses with ETL and business analytics.
- At least one successful cloud migration project
- SQL grandmaster
- Designed and implemented warehouses on Azure, AWS, GCP. Familiar with SQL Server, SSIS, SSRS, Azure Data Factory, Cosmos DB, Athena, Redshift, Dynamo DB, BigTable, BigQuery, Spanner, etc.
- Familiar with BI tools such as Power BI, Tableau, Google Data Studio, etc. Knows the pros and cons of each.
- Experienced in design and implementation of ETL pipelines, including orchestration of the pipelines. Familiar with GCP Dataflow, GCP Cloud Data Fusion, Azure Data Factory, AWS Glue, Apache Airflow, Xplenty, Talend, etc.

Desired:
- AWS, Azure, GCP cloud architect, and/or data engineer certificates

Personality:
- Responsible
- Attentive to details
- Results-driven
- Proactive

Details:
- Full remote
- Flexible schedule
- Part-time, consulting mode
- Hourly-based salary