Data Collection Tool Developer job in Santa Rosa, CA
Vacancy has expired
Santa Rosa, CA CorTech LLC
| Job Ref: | 374764 |
| Employer: |
CorTech LLC |
| Job Type: | Contract |
| Salary and Benefits: | 30.30/Per Hour |
| Remote: | No |
Location |
|
| City: | Santa Rosa, CA |
| Post Code: | 95403 |
| Map: |
|
Description |
|
|
We are seeking to hire a Data Collection Tool Developer for our client in Santa Rosa, CA. $30.30/Hour We are seeking a contract developer to design, build, and support a data collection solution that will begin as an Excel-based tool and later transition to a scalable web application. The initial phase focuses on Excel ?Smart Forms? that pull data from Microsoft SQL Server and use macros, VBA, validations, and business rules to guide accurate data entry. The long-term goal is a dynamic, user-friendly web application that improves usability, data quality, maintainability, and process efficiency. Primary Responsibilities Develop and maintain Excel-based data collection forms integrated with Microsoft SQL Server. Create macros, VBA scripts, formulas, validations, and guided workflows to improve data accuracy. Translate business requirements into rules, dependencies, constraints, mandatory fields, and exclusion logic. Design forms that display only relevant fields, selections, and instructions based on business logic. Collaborate with stakeholders to gather requirements, validate functionality, and support adoption. Support planning for the future web application, including requirements, data structure, workflow, and user experience. Document functionality, assumptions, requirements, test cases, and support procedures. Required Technical Experience Advanced Microsoft Excel skills, including formulas, data validation, structured templates, and macro-enabled workbooks. Hands-on experience with VBA, Visual Basic, or similar scripting languages for Excel automation. Experience connecting Excel or business applications to Microsoft SQL Server or relational databases. Familiarity with SQL or T-SQL for troubleshooting, reporting, validation, and analysis. Ability to implement business rules, dependencies, constraints, mandatory fields, and exclusion logic. JavaScript, TypeScript, JSON, YAML, and Python experience are preferred for future development, automation, and testing. Testing, Quality, and Deployment Develop and execute unit, scenario-based, regression, and user acceptance testing. Troubleshoot data, macro, rule logic, and workflow issues; identify root causes and resolve defects. Promote changes through development, test, and production environments. Follow Agile Scrum practices, including backlog refinement, sprint planning, demos, and iterative delivery. Ensure solutions are maintainable, documented, and aligned with business requirements. Skills: Soft Skills & Role Expectations Strong communication, collaboration, and interpersonal skills. Ability to clarify ambiguous requirements and translate them into practical technical solutions. Ability to explain technical trade-offs to technical and non-technical stakeholders. Strong analytical, diagnostic, and problem-solving abilities. Comfortable working independently as a contractor while staying aligned with priorities, timelines, and stakeholder expectations. Ability to work effectively with cross-functional teams across geographies. Preferred Tools and Technologies Microsoft Excel, VBA, Visual Basic, JavaScript, TypeScript, SQL, T-SQL, SQL Server, and relational databases. Visual Studio or similar development environments; Angular, React, or similar web frameworks. Confluence, Jira, Bitbucket, Power BI, Report Builder, and Microsoft 365 applications. AI-assisted development tools such as ChatGPT, GitHub Copilot, or Claude Code. Education: Qualifications Bachelor?s degree in Computer Engineering, Computer Science, Information Systems, or equivalent experience. Experience developing Excel-based tools, macro-enabled workbooks, or business process automation solutions. Experience with web application development and object-oriented programming preferred. Experience developing user-friendly tools that collect, validate, and process business data. | |
ref: (374764)
98 days ago
Back to search results