Job Summary
Azkivam is looking for a mid-level Data Engineer with strong SQL and ETL skills to support and enhance our data infrastructure. The ideal candidate will have solid experience in developing and maintaining ETL processes, working with SQL Server, and building structured datasets for analysis. While this is a backend-focused role, you must be comfortable using Power BI to deliver or modify reports and should be open to growing in this area over time.
Key Requirements:
- Experience: 2+ years in data engineering or similar roles
- Technical Skills:
- T-SQL – Advanced
- SQL Server & SSMS – Intermediate
- SSIS (ETL development) – Intermediate
- Power BI – Familiar (capable of building/modifying reports)
- Language: English – Intermediate
Responsibilities:
- Design, develop, and optimize ETL pipelines using SSIS to transform and load data from various sources.
- Write and maintain complex T-SQL scripts to support data preparation, validation, and transformation processes.
- Manage and troubleshoot SQL Server databases and jobs, ensuring data quality, performance, and availability.
- Collaborate with analysts and stakeholders to understand data needs and translate them into efficient, scalable data solutions.
- Use Power BI to build and update reports and dashboards as needed — primarily working with structured SQL datasets.
- Assist in the design of dimensional models to support reporting and analysis.
- Maintain documentation and data process standards for reusability and governance.
Required Skills:
- Strong hands-on experience with T-SQL (stored procedures, views, window functions, performance tuning).
- Proficient in SSIS and ETL workflows for data integration and transformation.
- Solid understanding of SQL Server (schemas, indexing, scheduling jobs, error handling).
- Familiarity with Power BI, including:
- Connecting to data sources
- Creating or modifying basic dashboards and visuals
- Understanding of workspaces, refresh schedules, and report publishing
- Understanding of data warehousing principles, star/snowflake schema, and staging models.
- Strong troubleshooting, debugging, and data validation skills.
Nice to Have
- Basic DAX knowledge or experience with Power BI measures
- Familiarity with Git or version control tools