REMOTE Data & Analytics Technical Lead - Access Modernization & Power Platform

Insight Global

Lake Oswego, OR(remote)

Apply

JOB DETAILS

SKILLS

Analysis Skills, Automation, Best Practices, Billing, Business Processes, Cloud Computing, Communication Skills, Customer/Client Research, Data Analysis, Data Modeling, Data Processing, Data Storage, Database Programming, Database Technology, Documentation, Establish Priorities, Financial Analysis, Identify Issues, Information Technology & Information Systems, Insurance, Microsoft Access Database, Microsoft Product Family, Microsoft SQL Server, Microsoft SharePoint, Microsoft Visual Basic for Applications (VBA), Multitasking, Power BI, Problem Solving Skills, Process Improvement, Relational Databases (RDBMS), Reporting Dashboards, Requirements Management, Risk, SQL (Structured Query Language), SQL Databases, SQL Server Reporting Services (SSRS), Tax Reporting, Technical Leadership, Time Management, User Interface/Experience (UI/UX)

LOCATION

Lake Oswego, OR

POSTED

1 day ago

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 -

About the Company

Insight Global

We are a staffing agency helping individuals find jobs and employers fill open positions.

Based in Atlanta, Insight Global is a premier provider of employment and staffing solutions to Fortune 1000 customers across the United States and Canada. We provide long-term contract, short-term contract, temporary-to-permanent, direct placement, and enhanced staffing services. Insight Global specializes in placing contract job seekers into Information Technology, Accounting and Finance, Engineering (non-IT), and Government jobs.

Since our inception in 2001, we have experienced unprecedented growth within our industry, rapidly expanding from an Atlanta-based start-up to one of the most successful staffing firms in America.

Our core staffing services are the backbone upon which Insight Global was founded and have driven our success. We cater our delivery approach and recruiting efforts to meet each client’s unique demands, ensuring that we deliver both maximum client value and the differentiated Insight Global experience.

COMPANY SIZE

2,500 to 4,999 employees

INDUSTRY

Other/Not Classified

EMPLOYEE BENEFITS

Paid Sick Days, Parking, Performance Bonus, Professional Development, 401K, Subsidized Commuting, Employee Referral Program, Flexible Spending Accounts, Employee Events, Retirement / Pension Plans, Transportation Allowance, Vehicle Allowance, Work From Home, Merchandise Discounts

FOUNDED

2001

WEBSITE

http://www.insightglobal.net

Resume Resources

Free Resume Templates Free Resume Builder