Senior Data Warehouse (SSIS) Developer - Remote

$88,000 - $173,200/Yr

UnitedHealth Group - Lansing, MI

Full-time - Mid Level

Remote - Lansing, MI

11-50 employees

Insurance Carriers and Related Activities

About the position

The position involves working as part of a 43-person team at Optum, focusing on data management and conversion processes. The role requires effective communication with various stakeholders and emphasizes the importance of data quality and clarity during conversion activities. The candidate will have the flexibility to work remotely from anywhere in the U.S. and will be responsible for managing code repositories, supporting network issues, and leading data research and analysis efforts.

Responsibilities

• Provides code repository management and SSIS packages support
• Provides support/coordination for network related issues and development
• Leads source data research and target data requirements analysis for successful conversions
• Audits existing data for quality and clarity
• Responsible for converting existing data and adding new data sources as needed according to conversion best practices
• Preserves and improves data quality during data conversion activities
• Prepare necessary forms and documentation for implementation
• Works with the State and stakeholders to convert existing data and reports, including algorithm to assure matching occurs between datasets before and after conversion
• Analyze and recommend process improvements
• Must be able to work independently

Requirements

• 5+ years of Teradata and Teradata Utilities experience
• 5+ years of experience with SQL Assistant
• 5+ years of experience performing data extracts, data transformations & data loads (ETL)
• 5+ years of experience with all phases of SDLC
• 3+ years of DEV OPS Experience in SQL/WIN Environment; SSIS packages/authored in Visual Basic
• 3+ years of experience using GitHub code repository or similar
• 3+ years of experience with troubleshooting server network issues related to firewalls, VPN, B2B connections, etc.

Nice-to-haves

• 1+ years of experience with State Government/Public Health business areas
• Experience working with business partners to proactively identify value add solutions
• Experience with report development
• Experience with analytical tools

Benefits

• Comprehensive benefits package
• Incentive and recognition programs
• Equity stock purchase
• 401k contribution