Title: Data Automation Specialist
Pay Rate: $29/hr
Job Type: Contract
City: Santa Rosa, CA, 95403
Job Code: JPC-12446
Tekberry is looking for a highly qualified and motivated Data Automation Specialist to work on-site with our client, a top-tier electronic test and measurement company.
Our client is at the forefront of technology innovation, delivering breakthroughs and trusted insights in electronic design, simulation, prototyping, test, manufacturing, and optimization. Their ~15,000 employees create world-class solutions in communications, 5G, automotive, energy, quantum, aerospace, defense, and semiconductor markets for customers in over 100 countries.
Data Collection Tool Developer
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.
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.
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.
Tekberry is an equal opportunity employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. Tekberry is a certified Minority Business Enterprise (MBE) and Disadvantaged Business Enterprise (DBE).
By applying to this position, you agree to receive text message updates from Tekberry regarding your application status. Msg & data rates may apply. Reply STOP to opt out
#INDHP