Lead Data Architect – Azure | SQL | Python | Power BI

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