Job ID Number
R5974Employment Type
Full timeWorksite Flexibility
HybridJob Summary
The Data Integration Specialist will focus on assessing, planning, and converting legacy Microsoft Access databases currently used to a modern supported technology platform.Job Description
We are seeking a highly skilled and experienced Data Integration Specialist to join our IT team. This position will be full-time , hybrid , and is a contract position .
What You'll Do
Analyze existing Microsoft Access applications and develop a comprehensive migration strategy
Convert and modernize Access databases by migrating data, rebuilding forms, and upgrading user interfaces
Refactor legacy code and queries to enhance performance and maintainability
Validate functionality and data integrity through structured testing processes
Deploy modernized solutions and provide end-user training, documentation, and long-term support plans
Conduct discovery and requirements gathering by inventorying databases and engaging stakeholders
Analyze existing data connections and plan integration with target platforms
Evaluate current security configurations and implement role-based access control in the new environment
Redesign database schemas and optimize performance to meet enterprise standards
Develop a migration playbook and provide hands-on training for client staff
Execute the transition of Access databases into a secure, scalable data warehouse environment
Develop internal and external interfaces, custom reports, and data entry forms
What You'll Need
Required:
Proven experience with Microsoft Access database architecture and conversion
Strong understanding of enterprise data warehousing and integration strategies
Proficiency in SQL, VBA, and modern database platforms (e.g., SQL Server, Azure)
Experience with data migration tools and methodologies
Knowledge of security best practices and compliance frameworks
Ability to optimize database performance and redesign schemas
Excellent communication and stakeholder engagement skills
Experience in training and mentoring technical staff
Physical Demands
Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards
Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
The pay range for this position is $55 - $65 per hour (USD). Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages for this role includes medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave as provided by applicable law.
Reasonable Accommodation Statement
If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.
Equal Employment Opportunity Policy Statement
CAI is committed to equal employment opportunity. We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability, or veteran status. All employment decisions are based on valid job requirements, including hiring, promotion, and compensation. Harassment and retaliation are prohibited.
...A leading engineering firm in Phoenix, Arizona is seeking a BMS Leader for their Data Center Facilities Engineering and Design Team. This role involves overseeing a team, managing project execution, and fostering client relationships. The successful candidate will have...
...closely with the Data Science team Working with the Project Manager and front end mobile development team to understand the flow and requirements. Play the role of front end web developer to create web apps in ReactJS, NextJs and VueJS and eventually transition as...
...Job Description Are you passionate about the ever-evolving world of cybersecurity and digital forensics? Do you thrive on tackling complex challenges and unraveling digital mysteries? If so, Cyber Centaurs is looking for a talented and motivated individual to join...
Lincoln Electric is the world leader in the engineering, design, and manufacturing of advanced arc welding solutions, automated joining, assembly and cutting systems, plasma and oxy-fuel cutting equipment, and has a leading global position in brazing and soldering alloys...
...JD# SPLK-0425 | Splunk Engineer (W2 Only) Location: Ohio or New Jersey Metropolitan Area (Hybrid 3 Days Onsite / 2 Days Remote) Type: W2 Only Local candidates highly preferred Were Hiring a Splunk Engineer with SRE/DevOps Experience Are you a hands-on...