Job Summary:
We are seeking a skilled Data Analytics Professional to design and implement data acquisition and ETL processes in Microsoft Azure, supporting enterprise reporting needs. The successful candidate will collaborate with technical staff and subject matter experts (SMEs) to document sources, transformations, and dependencies.
Key Responsibilities:
* Design and develop ETL pipelines in Azure Data Factory (or equivalent) to automate ingestion from APIs, files, and vendor systems.
* Develop and optimize SQL stored procedures, scheduled jobs, and views in Azure SQL Database.
* Apply data governance and quality checks to ensure dataset accuracy and consistency.
* Support Power BI developers by delivering clean, structured datasets.
Required Skills and Qualifications:
* Strong experience with Microsoft Azure, including Data Factory, SQL Database, and Blob/Data Lake.
* Advanced knowledge of SQL, including stored procedures, scheduled jobs, indexing, and views.
* Proven experience in ETL development, including batch and scheduled pipelines.
* Solid understanding of data governance, lineage, and quality frameworks.
* Familiarity with Power BI data models, excluding visualization capabilities.