As a senior data architect, you will play a key role in designing and implementing data acquisition and integration processes in Microsoft Azure to support enterprise reporting needs. Your primary responsibility will be to integrate multiple technical datasets into a central Azure SQL Database, ensuring cleansed, reliable, and query-ready data for downstream dashboards.
Key Responsibilities
* You will build and maintain ETL pipelines in Azure Data Factory to automate ingestion from APIs, files, and vendor systems.
* Your task is to develop and optimize SQL stored procedures, scheduled jobs, and views in Azure SQL Database.
* You will apply data governance and quality checks to ensure dataset accuracy and consistency.
* Collaboration with technical staff and SMEs is required to document sources, transformations, and dependencies.
* You will also support Power BI developers by delivering clean, structured datasets.
Required skills:
* Strong experience with Microsoft Azure (Data Factory, SQL Database, Blob/Data Lake) is essential.
* Advanced SQL skills, including stored procedures, scheduled jobs, indexing, and views are required.
* A proven track record of ETL development experience, particularly with batch and scheduled pipelines, is necessary.
* A solid understanding of data governance, lineage, and quality frameworks is crucial.
* Familiarity with Power BI data models, excluding visualization, is desirable.