Data Engineer II

• Location: Madison, Wisconsin
• Type: Direct Hire
• Job #2292

Candidate must be located within the greater Madison, WI region or willing to relocate.

The Data Engineer II is responsible for the full lifecycle development, implementation, production support, and performance tuning of the enterprise data warehouse, data platforms, analytics, and reporting environments. This role will also be responsible for supporting the integration of these systems with other applications. The Data Engineer II will collaborate with different IT and operations teams and will develop complex technical solutions.

What You’ll Do

• Engage in the full development lifecycle, from understanding business enterprise data needs through solution design, development, testing, implementation, and support
• Develop and automate data pipelines, clean and prep data
• Peer code review and build advisory
• Partner with IT and operational analysts to define reporting tool goals and best practices
• Provide expertise in data management, integration, analytics, reporting, and assist with technical and non-technical questions
• Provide technical design for solutions from business and undertake code development
• Provide technical support for code deployments, query optimization, and investigating data issues in data warehouses, operational data stores, and other disparate data sources
• Monitor technology trends and solutions and recommend enhancements to our technical environment to keep pace with changing business demands and scale
• Promote the role and capabilities of IT to enhance the professional development of all staff through example, recommendation, and accommodation

Skills you might have:

• 2+ years of experience in data and/or software engineering or related field
• Ability using SQL server for data development, exploration, debugging, and query optimization; including, but not limited to, DDL and DML
• Technical understanding of business needs, design, development, and deployment.
• Experience with or knowledge of Cloud Infrastructure services (i.e., Azure, SQS, S3, and GitLab)
• Experience with Snowflake or other cloud database systems
• Demonstrated ability to successfully work in ETL job orchestration, batch process automation, and lights-out batch processing in medium to large data warehouse implementations, setup, and optimization of operational data streams using scheduling tools.
• Experience with data quality and data transformation tools like Talend
• Adaptable, open to change and able to work in ambiguous situations and respond to new information or unexpected circumstances
• Ability to build consensus across functions
• Strong analytical, problem solving, and trouble-shooting skills

#LI-TB1