5+ years of experience in SQL scripting (SSIS) and report writing (SSRS)
Experience supporting enterprise ERP and/or CRM systems
Ability to understand and design solutions based on business and technical requirements
Strong problem-solving and troubleshooting skills
Knowledge of Change Management, Incident Management, and Request Management processes (ITIL preferred)
Excellent communication and time management skills
Responsibilities
Write advanced SQL functions, scripts, procedures, and triggers
Build and support automated ETL pipelines using tools like SSIS and APIs
Design and prepare ad-hoc data extractions and operational dashboards
Gather data requirements through collaboration with business, vendors, and technical teams
Administer assigned applications and manage system customizations
Monitor SQL integrations and ensure output accuracy
Identify opportunities for improving efficiencies in processes
Benefits
Opportunity to work on diverse projects involving data integrations and reporting
Gain expertise in Cavco's data and applications
Collaboration with cross-functional teams and vendors
Participation in change control and upgrades ensures skill enhancement
Engagement with compliance processes for IT GRC and SOX
Potential for remote work flexibility with occasional travel required
Full Job Description
ABOUT THE ROLE
The primary role of the SQL Developer is to design, build, test and prepare code to support integrations, scripted application configurations, and reporting as needed to support business needs. This position covers a range of responsibilities such as support of day to day requests for new/updated reports, involvement in projects which drive changes or creation of new integrations between systems, develop and support new scripts within configurable systems, create data extractions as used for migrations or data analysis, troubleshooting issues that arise, testing and approval of new vendor builds, and support of smaller enterprise applications as may be assigned. This person must also acquire a deep understanding of Cavco's data and data sources in order to facilitate discussions and requirements gathering with business, vendor and technical team members. As assigned, this person must acquire knowledge to setup, configure, secure and support smaller enterprise applications. This position reports to the Director of Enterprise Applications.
ESSENTIAL DUTIES & RESPONSIBILITIES
Code Development: Write advanced functions, scripts, stored procedures, and triggers. Develop and maintain automation and administrative scripts (e.g., PowerShell, SQL jobs, Batch, or similar).
Data Integration: Build and support automated ETL pipelines using tools like SSIS, SSMS, sFTP, APIs.
Business Intelligence and Report Development: Design, build, test and prepare deployment of ad-hoc data extractions, scheduled reports, and operational dashboards using tools such as SSRS and Report Builder. Maintain and troubleshoot reports as needed to support business operations.
Collaboration: Meet with business,vendors and technical teams to gather data requirements and formatting needs to provide data integration and reporting solutions.
Configuration: Perform day-to-day administration of assigned applications and configurations such as managing system customizations (user defined fields, calculations, constants, and application scripting).
Processing: Monitor daily SQL integrations, batch jobs, outputs for completeness and accuracy.
Continuous Improvement: Identify opportunities for implementation of features or enhancements to improve efficiencies
Support and Change Control: Troubleshoot, research, and document reported issues. Write and optimize SQL queries for data analysis, reporting, and issue resolution. Perform change management, incident management and request management activities following ITIL best practices, ensuring system availability, reliability and issue prevention. Work with technical, vendor and business team members to obtain resolutions on critical issues. Monitor application health, investigate incidents and perform root cause analysis.
Upgrades and Customizations: Participate in testing new versions, customizations and upgrades; coordinate user-acceptance testing of these changes and obtain business approvals before release.
Data Subject Matter Expert: Become an expert on Cavco's data, data sources, processing, application configurations, reporting and outputs. Maintain technical documentation, knowledge articles, and operational procedures.
Compliance: Maintain documentation required by IT GRC, SOX, and Internal Audit department
May require occasional travel
MINIMUM QUALIFICATIONS
Bachelor's degree or equivalent work experience
Minimum 5 years' experience in SQL scripting (SSIS), Report Writing (SSRS), and application configurations and support.
