Position Details |
Job Location/Client Location (with City & State) | Minnesota/Minneapolis |
Remote ok (Yes / No) | Yes |
Project Duration | 6 Months |
Project Start date | Asap |
Mode (TP/FTE) | TP |
No of openings/positions | 1 |
Job Title/Role | Solution Architect |
Mandatory Skills | Azure SQL Server SSIS |
Client Interview Needed for Selection (Yes / No) | Yes |
Job Description | Data Engineering & ETL Development: Design develop and maintain ETL (Extract Transform Load) processes using SQL Server Integration Services (SSIS). Build and optimize data pipelines for efficient data extraction transformation and loading from various sources. Implement incremental and full load ETL strategies to support realtime and batch data processing. Ensure data integrity data quality and performance optimization across ETL workflows. Database Development & Optimization: Develop and maintain SQL Server databases stored procedures functions and triggers. Optimize SQL queries and indexing strategies to improve database performance. Implement data partitioning indexing and caching strategies for highperformance data processing. Azure Data Services & Cloud Integration: Develop data solutions on Azure leveraging services such as Azure Data Factory (ADF) Azure SQL Database Azure Data Lake and Azure Synapse Analytics. Integrate onpremises and cloudbased data sources using Azure Hybrid Data Solutions. Automate data workflows using Azure Logic Apps Functions and Power Automate. Implement data security best practices using Azure Key Vault encryption and rolebased access control (RBAC). Data Governance & Reporting: Ensure compliance with data governance security and privacy regulations. Work closely with business intelligence (BI) teams to provide data models and support analytics solutions. Create and maintain documentation for data pipelines ETL workflows and database schemas. Collaboration & Continuous Improvement: Collaborate with crossfunctional teams (Data Analysts BI Developers and Software Engineers) to support datadriven decisionmaking. Identify and implement automation strategies to improve data engineering efficiency. Stay uptodate with the latest technologies and best practices in Azure SQL Server and ETL development. |