REMOTE Data & Analytics Technical Lead Access Modernization & Power Platform

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/. Skills and Requirements 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
• 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

•