The business problem is to design, deploy, optimize, and maintain an Azure SQL Database and associated ETL pipelines to handle data integration and reporting needs, potentially for state or government data projects.
Requirements
- Proficiency in Azure SQL Database design, deployment, optimization, and performance tuning.
- Hands-on experience with ETL pipelines in Azure Data Factory using Python.
- Knowledge of Azure Blob Storage and integration with Azure services.
- Experience with Power BI integration for reporting and dashboards.
- Strong background in relational database schema design, normalization, and indexing.
- Understanding of data security, RBAC, encryption, and compliance standards.
- Relevant Azure certifications (e.g., Data Engineer Associate, Database Administrator Associate).
Responsibilities
- Proficiency in Azure SQL Database design, deployment, optimization, and performance tuning.
- Hands-on experience with ETL pipelines in Azure Data Factory using Python.
- Knowledge of Azure Blob Storage and integration with Azure services.
- Experience with Power BI integration for reporting and dashboards.
- Strong background in relational database schema design, normalization, and indexing.
- Understanding of data security, RBAC, encryption, and compliance standards.
- Ability to perform testing, validation, and database maintenance planning.
Other
- Need Overall 10+Years of experience
- 3 References from the recent projects are must.
- Skills in documentation, training, and knowledge transfer.
- Strong communication and project management abilities.
- Bachelor’s degree in Computer Science, Information Systems, or related field (preferred)
