SQL Developer

At Cavco Industries, Inc. (NASDAQ CVCO), our 7000 team members are at the heart of everything we do. We design and produce quality, affordable factory-built homes. We are also a leading producer of park model RVs, vacation cabins and factory-built commercial structures. In addition to providing competitive pay and benefits, we provide opportunities for development and upward mobility, while investing in the communities we serve.

Our values are our foundation. We’re constantly striving to diversify our teams to ensure we have the best and brightest talent. We’re deeply committed to creating an inclusive and equitable workplace where each person can contribute.

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.

• Code Development:
  Write advanced functions, scripts, stored procedures, and triggers. Develop and maintain automation and administrative scripts (e.g., Power Shell, 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…