Sundt | SQL Developer | tempe, az

Job Description As a 100% employee-owned contractor, when you work at Sundt, you're not just hiring on at a company, you're joining a culture. Because everyone at Sundt is part owner, you'll join a team of people who are deeply invested in their work. From apprentices to managers, we're passionate about the details and deliberate in everything we do. At Sundt we focus on building long-term prosperity for our clients, communities and employee-owners. We offer competitive pay, industry-leading benefits including a 401k and employee stock ownership plan, incentive programs for craft and administrative employees as well as training that focuses on your personal and professional growth. We're driven by skill, grit and purpose. Join us as we strive to be the most skilled builder in America Job Summary Join our dynamic team as an SQL Developer II and embark on an exciting journey where every day brings new challenges and opportunities for growth. The ideal candidate for this diverse and fast-paced position is a self-starter who thrives in a dynamic environment, fueled by the prospect of tackling any issue that arises and finding innovative solutions. As a key member of our team, they will be responsible for creating, maintaining, debugging, and promoting integration packages to Production using various technologies. This "hands-on" role requires solid technical and analytical skills, as well as excellent interpersonal and communication skills. The SQL Developer II will play a pivotal role in facilitating complex workflows for data movement between on-premises databases, Azure, SFTP, and third-party applications through flat files and REST API calls. Collaboration and effective communication with stakeholders across departments will be essential. Join us now and become an integral part of a team that values expertise, rewards hard work, and offers continuous opportunities for professional development. Together, we'll revolutionize data integration and shape the future of our organization. Key Responsibilities 1. Ability to prioritize on-going tasks and projects with distractions while maintaining attention to detail; Ability to meet deadlines and deal with shifting priorities. 2. Ability to work on multiple projects at once with given priorities and timelines. 3. Build complex workflows, expressions, queries, and validations with proper error handling and alerting. 4. Create and maintain complex packages in SSIS using third party plugins, data transformations, slowly changing dimensions, and advanced expressions. 5. Designing and creating tables, stored procedures, views, indexes, and functions using T-SQL. 6. Develops and maintains new and existing ETL / integrations adhering to industry standards and established company best practices. 7. Diagnoses job failures and produce solutions to ongoing issues. 8. Documenting integration processes, configurations, and workflows for future reference and knowledge sharing. 9. Ensuring data integrity, accuracy, and security throughout the integration lifecycle. 10. Maintains a high level of accurate and up to date documentation. 11. Provides advanced technical assistance and support for end users. 12. Reporting and data driven subscriptions in SSRS. 13. Supplemental and backup support for Data Warehouse residing in Azure. 14. Tracks database schema changes, code changes, and promotion to Production using GIT repos and Cl/CD pipelines. 15. Work on projects independently including coding and debugging while following technical specifications. Minimum Job Requirements 1. 5+ years advanced technical experience with three or more of the following: TSQL, SSIS, SSRS, Azure Data Factory, REST API, JSON. 2. Bachelor's Degree in related field or 8+ years relevant work experience. 3. Experience in an environment supporting Windows and/or Azure components. 4. Must be able to work collaboratively within a multi-disciplinary team. 5. Must have strong verbal and written communication skills. 6. Proficient use of all Microsoft Office Suite programs. 7. Self-motivated with sharp attention to detail. Note: Job Description is subject to change at any time and may include other duties as assigned. Physical Requirements 1. May stoop, kneel, or bend, on an occasional basis 2. Must be able to comply with all safety standards and procedures 3. Required to use hands to grasp, lift, handle, carry or feel objects on a frequent basis 4. Will interact with people and technology frequently during a shift/work day 5. Will lift, push or pull objects up to 50Ibs on an occasional basis. 6. Will sit, stand or walk short distances for up to the entire duration of a shift/work day. 7. Will use telephone, computer system, email, and other electronic devices on a frequent basis to communicate with internal and external customers or vendors Safety Level Non-Safety Sensitive Note: Jobs with the Safety-Sensitive designation are those that include tasks or duties that the employer reasonably believes could affect the safety and health of the employee performing the task or others such as operating a vehicle, operating equipment, operating machinery or power tools, repairing/maintaining the operation of any vehicle/equipment, the handling/disposal/transport of hazardous materials, or the handling/treatment/disposal of potentially flammable/combustible materials. Equal Opportunity Employer Statement: Sundt is committed to the equal treatment of all employees, and/or applicants for employment, and prohibits discrimination based on race, religion, sex (including pregnancy), sexual orientation, gender identity, color, age, disability, national origin, covered veteran status, genetic information; or any other classification protected by applicable Federal, state, or local laws. Benefit list: 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

Created: 2024-11-26