Solution Architect

TechDigital Group; Minneapolis (MN); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled Data Engineer to design and maintain ETL processes using SQL Server Integration Services. This role involves developing data solutions on Azure and optimizing SQL Server databases for peak performance. The ideal candidate will ensure data integrity and quality while collaborating with cross-functional teams to drive data-driven decisions. Join a forward-thinking company that values innovation and continuous improvement in data engineering practices. If you are passionate about leveraging cloud technologies and data governance, this opportunity is perfect for you.

Qualifications

• Experience in designing and maintaining ETL processes with SSIS.
• Strong knowledge of Azure services for data solutions.
• Expertise in SQL Server database development and optimization.

Responsibilities

• Develop and maintain ETL processes using SSIS for data integration.
• Optimize SQL queries and database performance for efficiency.
• Collaborate with teams to support data-driven decision-making.

Skills

Azure

SQL Server

SSIS

Data Governance

ETL Development

Tools

Azure Data Factory

Azure SQL Database

Azure Data Lake

Azure Synapse Analytics

Azure Logic Apps

Power Automate

Job description

Mandatory Skills: Azure, SQL Server, SSIS

Data Engineering & ETL Development:

1. Design, develop, and maintain ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS).
2. Build and optimize data pipelines for efficient data extraction, transformation, and loading from various sources.
3. Implement incremental and full load ETL strategies to support real-time and batch data processing.
4. Ensure data integrity, data quality, and performance optimization across ETL workflows.

Database Development & Optimization:

1. Develop and maintain SQL Server databases, stored procedures, functions, and triggers.
2. Optimize SQL queries and indexing strategies to improve database performance.
3. Implement data partitioning, indexing, and caching strategies for high-performance data processing.

Azure Data Services & Cloud Integration:

1. Develop data solutions on Azure, leveraging services such as Azure Data Factory (ADF), Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics.
2. Integrate on-premises and cloud-based data sources using Azure Hybrid Data Solutions.
3. Automate data workflows using Azure Logic Apps, Functions, and Power Automate.
4. Implement data security best practices using Azure Key Vault, encryption, and role-based access control (RBAC).

Data Governance & Reporting:

1. Ensure compliance with data governance, security, and privacy regulations.
2. Work closely with business intelligence (BI) teams to provide data models and support analytics solutions.
3. Create and maintain documentation for data pipelines, ETL workflows, and database schemas.

Collaboration & Continuous Improvement:

1. Collaborate with cross-functional teams (Data Analysts, BI Developers, and Software Engineers) to support data-driven decision-making.
2. Identify and implement automation strategies to improve data engineering efficiency.
3. Stay up-to-date with the latest technologies and best practices in Azure, SQL Server, and ETL development.