Job Description
This role is a hands-on technical position responsible for maintaining and enhancing existing MS Access database applications while actively driving the migration of legacy processes to modern Microsoft platforms.
The ideal candidate will be both a strong Access developer and a builder in modern tools (Power Platform, Power BI, SQL), capable of translating existing workflows—including reporting and data update processes—into scalable, automated solutions.
Primary Responsibilities
Access Application Ownership (Day-to-Day)
Serve as the primary developer and support resource for existing MS Access databases (queries, forms, macros, VBA, reports)
Troubleshoot, enhance, and stabilize critical legacy applications used across multiple departments
Maintain accuracy, reliability, and timely delivery of business-critical reporting and workflows
Support users and stakeholders with issues, enhancements, and ad hoc requests
Shape
Hands-On Migration & Modernization (Core Focus)
Actively design and build modern replacements for legacy Access applications
Convert existing solutions into appropriate platforms, including:
Power BI for reporting and dashboards (replacing view-only reports)
Power Automate / Power Apps for workflow automation and user interfaces
SQL-based solutions for data storage and processing
Rebuild processes that currently rely on:
Access queries (including update queries)
Manual data manipulation steps
Work directly with business stakeholders to understand current-state functionality and deliver improved, modern solutions
Prioritize and execute a migration roadmap, balancing ongoing support with transformation work
Shape
Data Processing & Reporting
Process and integrate customer-provided data into structured environments
Maintain and enhance reporting processes supporting:
Monthly and quarterly reporting requirements
Billing control and revenue-driving outputs
Risk, insurance, and tax-related reporting
Build and deliver new reporting solutions in modern tools (Power BI preferred)
Deliver ad hoc analysis using SQL, Excel, and Power Platform tools
Shape
Automation & Process Improvement
Identify and implement automation opportunities to improve efficiency, accuracy, and repeatability
Replace manual or semi-manual workflows with automated, auditable processes
Ensure processes are documented and compliant with audit requirements
Shape
Collaboration & Technical Leadership
Partner closely with IT and business teams to ensure alignment with long-term data architecture
Serve as a go-to technical expert for data processes, automation, and reporting
Share best practices and support team capability growth where appropriate
What Success Looks Like:
- Reliable, well-supported Access environment in the near term
- Steady, measurable reduction in reliance on legacy Access applications
- Modernized reporting and workflows with improved scalability and transparency
- Clear, maintainable, and documented data processes
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
Education & Experience
- Bachelor’s degree in Business, Information Systems, or related field
- 4+ years of data, database development, or analytics experience
- Demonstrated experience owning end-to-end solutions (build + support)
Core Technical Skills
-Advanced MS Access development (VBA, queries, forms, reports, macros)
-Strong SQL and relational database experience
-Experience with SQL Server tools (e.g., SSMS, SSRS) or equivalent
-Advanced Excel skills (Power Pivot, complex formulas, data modeling)
Modernization Experience (Critical)
- Proven, hands-on experience migrating or rebuilding legacy systems (especially Access) into modern tools, such as:
- Power BI (reporting and dashboards)
- Power Automate (workflow automation)
- Power Apps (application interfaces)
- SQL or cloud-based data platforms
- Ability to translate: Legacy reports → modern dashboards, Update queries and batch processes → automated workflows or structured pipelines
Analytical & Execution Skills
- Strong problem-solving and analytical thinking
- Ability to independently manage multiple priorities and deliverables
- Experience documenting processes and building repeatable, governed solutions
Communication
- Strong ability to work directly with business users to gather requirements and deliver solutions
- Clear and concise communication with both technical and non-technical stakeholders
Nice to Have Skills & Experience
- Experience with Microsoft Power Platform (Power BI, Power Automate, Power Apps)
- Experience modernizing legacy business processes in a corporate environment
- Familiarity with SharePoint, OneDrive, and enterprise data environments -
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.