Job Title:
Data Architect
Description:
We are seeking an experienced Data Architect to design and implement data acquisition and ETL processes in Microsoft Azure to support enterprise reporting needs. You will be responsible for integrating multiple technical datasets (ServiceNow, PeopleSoft, and vendor systems) into a central Azure SQL Database, ensuring cleansed, reliable, and query-ready data is available for downstream dashboards.
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.
* Collaborate with technical staff and SMEs to document sources, transformations, and dependencies.
* Support Power BI developers by delivering clean, structured datasets.
* (Optional) Utilize Alteryx or similar tools for advanced data transformations.
Requirements:
* Strong experience with Microsoft Azure (Data Factory, SQL Database, Blob/Data Lake).
* Advanced SQL (stored procedures, scheduled jobs, indexing, views).
* Proven ETL development experience (batch + scheduled pipelines).
* Solid understanding of data governance, lineage, and quality frameworks.
* Familiarity with Power BI data models (not visualization).
Benefits:
* Opportunity to work on enterprise-scale reporting systems.
* Remote work environment based out of Brazil (supporting EST/CST hours).
* Short-term but impactful contract opportunity.
About the Role:
This role offers a unique opportunity to contribute to meaningful projects and work alongside skilled professionals. If you are passionate about data architecture and excited about this challenge, apply today!