We are seeking an experienced Lead Data Architect with over 10 years of expertise in SQL, Azure, Python, and BI tools. The ideal candidate will drive enterprise-scale data architecture, cloud transformation, and analytics strategy, ensuring scalable and secure data solutions for global clients.
- Architect and implement end-to-end Azure data solutions using Synapse, ADF, ADLS, and Azure Functions.
- Design and develop Python-based ETL pipelines integrating data from diverse sources like Salesforce, Google Analytics, QuickBooks, etc.
- Lead data modeling (Star/Snowflake schemas) using tools like Erwin, SQLDBM, and ER/Studio.
- Optimize SQL queries, execution plans, and database performance across large-scale systems.
- Build and publish interactive Power BI dashboards for actionable insights.
- Ensure data governance and security using Azure Key Vault, Microsoft Purview, and RBAC.
- Drive CI/CD practices using Azure DevOps for ADF pipeline deployments.
- Collaborate with business stakeholders and mentor cross-functional data teams.
Key Skills:
- Databases & ETL: SQL Server, T-SQL, SSIS, ADF, MySQL, Oracle
- Cloud Platforms: Azure Synapse, ADLS, ADF, Azure Functions, Key Vault, Databricks
- Programming: Python (Pandas, NumPy), PySpark, Spark SQL
- BI Tools: Power BI, DAX, SSRS, Excel
- Data Modeling: Star/Snowflake schema, OLAP/OLTP
- Tools & DevOps: Azure DevOps, GitLab, JIRA, SSMS, SSDT
