> Markdown version of [/jobs/ext/1853381-technical-analyst](https://www.wearedevelopers.com/jobs/ext/1853381-technical-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Technical Analyst - **Company:** Harvey Nash - **Location:** Frankfort, KY, United States - **Salary:** $83,200.0 - $104,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Access, Microsoft Excel, Airflow, Data Analysis, Databases, Data Integrity, Data Retrieval, Database Design, Instant Messaging Technology, Pivot Tables, SQL Databases, Data Streaming, Data Processing, Data Analytics - **Published:** July 9, 2026 - **Apply:** https://careers.harveynashusa.com/jobsearch/job-details/technical-analyst-8272-1/ ## About the Role * Proven experience as a Business Analyst, Technical Analyst, or Data Analyst in a data-driven environment. * Strong skills in Microsoft Access-including database design, queries, and reporting. * Familiarity with environmental lab data (e.g., water quality, soil analysis, air monitoring) and related regulatory requirements is a plus. * Ability to create clear, detailed documentation for technical processes and data flows. * Strong analytical mindset with the ability to translate complex data processes into actionable insights. * Excellent communication skills for working with both technical teams and non-technical stakeholders. * Write and interpret SQL queries for Access (SELECT, JOINs, WHERE, GROUP BY) * Ability to extract required information for analysis, reporting, or validation., * Strong technical writing: Ability to produce architecture diagrams, structured user stories, and formal requirement specifications. * Collaboration: Demonstrated ability to facilitate requirement-gathering workshops with non-technical Subject Matter Experts (SMEs). * Database Knowledge: Familiarity with Microsoft Access. * Attention to Detail: Precision in documenting technical steps and data integrity checks. * Analytical Skills: Ability to analyze data structures, mappings, and migration scripts. * Adaptability: Be open to solutions and flexible in changes. * As Needed: As needs of department changes, the ability to adjust to requirements is a smooth transition. ## Description Cabinet is seeking a qualified TechnicalAnalyst to document the migration of Microsoft Access databases to a new, separate database system. This role will bridge the gap between technical teams and end users by creating clear, accurate, and actionable documentation that supports a smooth transition, minimizes downtime, and ensures data integrity. The selected contractor will need to have the ability to create clear and comprehensive documentation for project requirements. The ability to use consistent templates and styles for documentation. Ensures that documentation is technically accurate, easy to understand and aligns with business goals. Responsibilities: * Document and map end-to-end data flows across systems, from field collection to lab analysis to reporting. * Analyze and document Microsoft Access database structures, queries, and usage patterns to optimize performance and accuracy. * Work closely with lab teams to understand data collection processes, and reporting requirements. * Develop and maintain data dictionaries, process documentation, and workflow diagrams for both technical and non-technical audiences. * Collaborate with IT, scientists, and business stakeholders to ensure data solutions meet both regulatory and operational needs., * Create simple dashboards or reports in Access or Excel to present findings. * Identify trends and anomalies in Access data for business insights * Gather business rules and data needs from stakeholders. * Specify fields, data types, constraints, and relationships. * Link requirements to Access database design and queries. * Map how data flows through processes and how Access supports them. Key Deliverables & Responsibilities Include: * Document Migration Process: Write step-by-step guides, checklists, and troubleshooting tips for moving Access databases to the new system. * Collaborate with Teams: Work closely with database administrators, developers, and IT support to gather technical requirements, verify data mappings, and ensure accuracy. * Maintain Documentation Repositories: Update and organize documentation in a centralized system, ensuring it remains current after migration. * Review and Edit: Proofread and edit all technical content for clarity, consistency, and correctness. * Follow Up: Monitor migration outcomes, update documentation as needed, and address user feedback. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Scaling Talent from Within: How Upskilling Fuels Growth](https://www.wearedevelopers.com/videos/1379-scaling-talent-from-within-how-upskilling-fuels-growth) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)