Sr DW ETL SQL Developer

Horizontal Talent - Lansing, MI

Full-time

Lansing, MI

11-50 employees

About the position

This position is for a candidate to join a 43-person team that includes Project Managers, Developers, Data Modelers, DBAs, Business Analysts, and Report Analysts. The role focuses on data conversion and quality assurance, requiring effective communication with various stakeholders, including programmers, analysts, and management. The candidate will be responsible for managing code repositories, supporting SSIS packages, and ensuring data quality during conversion activities.

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
• Prepares 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
• Analyzes and recommends process improvements
• Must be able to work independently

Requirements

• 3 - 5 Years DEV OPS Experience in SQL/WIN Environment; SSIS packages/authored in Visual Basic
• 3+ Years Experience using GitHub code repository or similar
• 3+ Years Experience with troubleshooting server network issues related to firewalls, VPN, B2B connections, etc.
• 5+ Years Experience with all phases of SDLC

Nice-to-haves

• Bachelor's degree or equivalent technical study
• Teradata Experience and Teradata Utilities
• Experience with SQL Assistant
• Experience performing Data Extracts, Data Transformations & Data Loads (ETL)
• 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