Talent.com
Solution Architect

Solution Architect

Omni InclusiveMinneapolis, MN, United States
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Mandatory Skills : Azure, SQL Server, SSIS

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 real-time 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 high-performance 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 on-premises and cloud-based 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 role-based 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 cross-functional teams (Data Analysts, BI Developers, and Software Engineers) to support data-driven decision-making.
  • Identify and implement automation strategies to improve data engineering efficiency.
  • Stay up-to-date with the latest technologies and best practices in Azure, SQL Server, and ETL development.
    • serp_jobs.job_alerts.create_a_job

    Solution Architect • Minneapolis, MN, United States