Minneapolis MN
Requirements:
>> Design, develop, and maintain SSIS packages for ETL processes, including error handling and logging.
>> Build and optimize SQL objects (stored procedures, functions, views) for high-performance data operations.
>> Migrate and consolidate data from multiple sources (files, APIs, databases) into SQL Server.
>> Implement parameterized, reusable ETL frameworks and metadata-driven pipelines.
>> Diagnose and tune query performance using execution plans, indexing, and partitioning strategies.
>> Optimize SSIS data flows for efficiency (buffers, parallelism, incremental loads).
>> Implement data quality checks, reconciliation processes, and audit trails.
>> Enforce security controls for sensitive data (encryption, secrets management, PIl handling).
>> Create and maintain technical documentation, including data lineage and runbooks.
>> Partner with cross-functional teams to gather requirements and deliver solutions.
>> Lead code reviews, mentor junior developers, and promote best practices.
>> Troubleshoot and resolve production issues, performing root cause analysis and implementing fixes.
>> Contribute to modernization initiatives (e.g., migration from SSIS to cloud-native solutions).