Description
You will build and maintain data integration pipelines and reporting solutions using the Microsoft stack.
Responsibilities
- Execute ELT processes using Azure Synapse.
- Develop data visualizations and reports within Power BI.
- Write and optimize SQL stored procedures, functions, and SQL Agent jobs.
- Implement data integration workflows using Python and shell scripting.
- Apply testing discipline to ensure data accuracy and code quality.
Required Skills
- 5+ years of experience in database integration and development.
- Strong SQL skills, including writing stored procedures and functions for SQL Server.
- Experience with Azure Synapse for ELT processes.
- Proficiency in Power BI and data visualization techniques.
- Experience working with Microsoft Azure cloud data warehouse platforms.
- Hands-on experience with Python and shell scripting.
- Knowledge of Kimball Methodology.
- Experience using code repositories.
- Proficiency in mapping visualizations.
Preferred Skills
- Experience working across the full Microsoft Stack.