Data Engineer (MS SQL) @ Scalo
Core
Designing and optimizing data warehouse solutions, building ETL processes, and creating analytical models for business intelligence.
Role type
Senior Data Engineer (SQL & BI)
Builds
Data warehouses, ETL pipelines, SSIS packages, and Power BI/DAX analytical models.
Domain
Enterprise Data Management & Business Intelligence
Deliverable
production ML models | product features | dashboards & analysis
Required skills
MS SQL Server (2016+), T-SQL, SSIS, Data Warehouse modeling, DAX, Azure Data Factory, DevOps
Preferred skills
Azure Synapse, Power BI Service, incremental load, CDC, surrogate keys, SCD, large volume data processing
Technologies
SQL Server, SSIS, SSAS, Azure, Power BI, DAX, R, CSV, Excel, API
Responsibilities
Write advanced queries and optimize execution plans, design and develop SSIS packages for data integration, create tabular models and DAX measures, collaborate with business to gather requirements, ensure data quality and documentation.
Seniority
Senior, hands-on IC