SQL Developer

Sundt Construction - Tempe, AZ

Full-time - Mid Level

Tempe, AZ

Construction of Buildings

About the position

As an SQL Developer II at Sundt Construction, you will join a dynamic team focused on data integration and management. This role involves creating, maintaining, and debugging integration packages while collaborating with various stakeholders. The position requires strong technical skills, analytical thinking, and effective communication to facilitate complex workflows involving on-premises databases, Azure, and third-party applications. You will be part of a culture that values employee ownership and continuous professional development.

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

• 401(k)
• Disability insurance
• Employee assistance program
• Employee stock ownership plan
• Flexible spending account
• Health insurance
• Tuition reimbursement