SQL Developer

The Sundt Companies - Tempe, AZ

Full-time - Mid Level

Tempe, AZ

Management of Companies and Enterprises

About the position

Join Sundt as an SQL Developer II, where you will be a key player in creating, maintaining, and promoting integration packages to Production. This hands-on role requires strong technical and analytical skills, as well as excellent communication abilities. You will facilitate complex workflows for data movement between various platforms, ensuring data integrity and security throughout the integration lifecycle. As part of a dynamic team, you will have opportunities for personal and professional growth while contributing to innovative data integration solutions.

Responsibilities

• Ability to prioritize ongoing tasks and projects with distractions while maintaining attention to detail; Ability to meet deadlines and deal with shifting priorities.
• Ability to work on multiple projects at once with given priorities and timelines.
• Build complex workflows, expressions, queries, and validations with proper error handling and alerting.
• Create and maintain complex packages in SSIS using third party plugins, data transformations, slowly changing dimensions, and advanced expressions.
• Designing and creating tables, stored procedures, views, indexes, and functions using T-SQL.
• Develops and maintains new and existing ETL/integrations adhering to industry standards and established company best practices.
• Diagnoses job failures and produces solutions to ongoing issues.
• Documenting integration processes, configurations, and workflows for future reference and knowledge sharing.
• Ensuring data integrity, accuracy, and security throughout the integration lifecycle.
• Maintains a high level of accurate and up-to-date documentation.
• Provides advanced technical assistance and support for end users.
• Reporting and data-driven subscriptions in SSRS.
• Supplemental and backup support for Data Warehouse residing in Azure.
• Tracks database schema changes, code changes, and promotion to Production using GIT repos and CI/CD pipelines.
• Work on projects independently including coding and debugging while following technical specifications.

Requirements

• 5+ years advanced technical experience with three or more of the following: TSQL, SSIS, SSRS, Azure Data Factory, REST API, JSON.
• Bachelor's Degree in related field or 8+ years relevant work experience.
• Experience in an environment supporting Windows and/or Azure components.
• Must be able to work collaboratively within a multi-disciplinary team.
• Must have strong verbal and written communication skills.
• Proficient use of all Microsoft Office Suite programs.
• Self-motivated with sharp attention to detail.

Benefits

• Market Competitive Salary (paid weekly)
• Bonus Eligibility based on company, group, and individual performance
• Employee Stock Ownership Plan & 401K
• Industry Leading Health Coverage Starting Your First Day
• Flexible Time Off (FTO)
• Medical, Health Savings, and Wellness credits
• Flexible Spending Accounts
• Employee Assistance Program
• Workplace Wellness Programs
• Mental Health Program
• Life and Disability Insurance
• Employee-Owner Perks
• Educational Assistance
• Sundt Foundation - Charitable Employee-Owner's program