Data Migration Specialist

Data EngineerData EngineerOtherRemoteMid LevelTeam 11-50

Location

United States

Posted

86 days ago

Salary

$135K - $145K / year

Seniority

Mid Level

Job Description

Data Migration Specialist

IMAGINEEER LLC

Benefits: - 401(k) matching - Competitive salary - Health insurance - Paid time off About this Role: Imagineeer is seeking an experienced Data Architect / Data Analyst to support our client, the Department of Health and Human Services (DHHS), Office of the Chief Information Officer (OCIO) in migrating their core HR IT functions into OPM’s new HR 2.0 government-wide federated HR IT platform. The yet-to-be-announced platform will encompass Time and Attendance, Position Description management, Performance Management, Employee/Manager/HR Self-Service, and an Enterprise Business Intelligence capability. The solution will be compliant with federal cybersecurity, records management, and accessibility standards, to improve system performance, user satisfaction, and long-term sustainability of HR services. This role is critical for assisting HHS in the consolidation and migration of their existing data into the new platform and optimizing HCM applications and processes that support essential administrative and operational functions across the department. The ideal candidate combines strong technical development skills with an understanding of federal government systems and requirements. This position requires the ability to obtain and maintain a Public Trust clearance. Key Responsibilities: - Assess and inventory existing legacy data in application data stores, shared folders and shared drives. - Assess the quality, completeness, and relevance of data to be migrated. - Identify and document data dependencies, redundancies, and inconsistencies. - Collaborate with stakeholders to understand data structures, relationships, and required formats for successful migration. - Develop a comprehensive data migration plan that outlines steps, timelines, and resource requirements for the migration process. - Identify potential challenges and propose solutions to mitigate risks associated with data migration. - Interpret legacy APIs and other system integrations, and define mapping between systems - Plan for thorough testing of the migrated data to ensure accuracy, completeness, and successful integration. - Recommend validation reports and the process to document any discrepancies and work closely with stakeholders to resolve issues. - Collaborate with software engineers, database administrators, and development teams to ensure compatibility and alignment with the overall architecture. - Maintain effective communication with project stakeholders to provide updates on migration planning progress and gather feedback. - Create and maintain technical documentation related to planned data migration processes, procedures, and system configurations. - Specify reports on migration progress, data quality metrics, and issue resolution. Qualifications and Skills: - Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field. - Previous experience as a Database Engineer and proven experience in data migration, particularly with legacy systems and cloud environments. - Proficiency in data migration tools and ETL processes (e.g., Talend, Informatica, SSIS, or similar). - Strong knowledge of database management systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL). - Experience with scripting languages (e.g., Python, Perl, SQL, PowerShell) for data transformation and automation. - Familiarity with indexing and data accessibility in software applications. Desired Skills and Competencies: - Experience with federal HRIT systems is a huge plus, particularly USA Staffing, USA Performance, DFAS, ITAS, HHS LMS, EHCM, ServiceNow for HR case management. - Experience with federal agency data governance best practices, data quality standards, and compliance measures. - Strong analytical and problem-solving skills, with attention to detail. - Experience with large federal agency data migration planning and execution. Equal Opportunity Employer: We are an Equal Opportunity Employer and do not discriminate in employment decisions on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other status protected by applicable federal, state, or local laws. All employment decisions are based on business needs, job requirements, and individual qualifications. This is a remote position.

Job Requirements

  • Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
  • Previous experience as a Database Engineer and proven experience in data migration, particularly with legacy systems and cloud environments.
  • Proficiency in data migration tools and ETL processes (e.g., Talend, Informatica, SSIS, or similar).
  • Strong knowledge of database management systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL).
  • Experience with scripting languages (e.g., Python, Perl, SQL, PowerShell) for data transformation and automation.
  • Familiarity with indexing and data accessibility in software applications.
  • Desired Skills and Competencies
  • Experience with federal HRIT systems is a huge plus, particularly USA Staffing, USA Performance, DFAS, ITAS, HHS LMS, EHCM, ServiceNow for HR case management.
  • Experience with federal agency data governance best practices, data quality standards, and compliance measures.
  • Strong analytical and problem-solving skills, with attention to detail.
  • Experience with large federal agency data migration planning and execution.

Benefits

  • 401(k) matching
  • Competitive salary
  • Health insurance
  • Paid time off
  • Equal Opportunity Employer
  • We are an Equal Opportunity Employer and do not discriminate in employment decisions on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other status protected by applicable federal, state, or local laws. All employment decisions are based on business needs, job requirements, and individual qualifications.
  • This is a remote position.

Related Categories

Related Job Pages

More Data Engineer Jobs

Cushman & Wakefield logo

Data Integrations Lead

Cushman & Wakefield

We will never settle for the world that’s been built, but relentlessly drive it forward. #BetterNeverSettles

Data Engineer86 days ago
OtherRemoteTeam 10,001+Since 1917H1B No Sponsor

Job Title Data Integrations Lead Job Description Summary Reporting to the Global Head of Data Architecture and Engineering, you will be the primary custodian of our data platform standards, integration patterns, and engineering best practices. A high-level strategy and architectural guardrails are already in place; your role is to translate them into a living North Star – defining the standards and platform capabilities that all data engineering teams build against. This is a player-coach position: you will remain somewhat hands-on with complex platform work while mentoring other engineers and driving consistency across a global organisation. Our primary stack is Microsoft Azure and Databricks and deep expertise in both is essential.Job Description Key Responsibilities: · Own and evolve our data platform reference architectures and standards, spanning ingestion, batch and real-time integration, event-driven patterns, lakehouse design, and AI/ML enablement. · Define, socialise, and enforce engineering standards across multiple teams – including metadata-driven patterns, code reuse, and software engineering best practice. · Champion DataOps and CI/CD practices organisation-wide, including pipeline standards, automated testing, and release governance within the Azure and Databricks ecosystem. · Define the approach to metadata management, data cataloguing, lineage, and data quality, ensuring compliance and data residency requirements are met across global jurisdictions. · Shape the platform's AI/ML enablement strategy, ensuring data is accessible and well-governed for AI teams without creating ungoverned, bespoke patterns. · Mentor and develop data engineers across teams, setting a high technical bar and fostering a culture of quality and continuous improvement. Knowledge & Experience: · Extensive hands-on experience across the data platform spectrum – ingestion, batch and real-time streaming, event-driven integration, lakehouse architecture, and AI/ML data enablement probably gained over 10+ years including at least 3 years working with Azure and Databricks · Deep practical expertise with Microsoft Azure data services in secure private VNet environments, including Event Hubs, Service Bus, ADLS, Function Apps, API Manager, Cosmos DB, and Azure Monitor. · Expert-level, hands-on Databricks experience – including Lakeflow, Spark Declarative Pipelines (DLT), Delta Lake, Unity Catalog, Lakehouse architecture and cluster management & optimisation. · Proven DataOps and CI/CD expertise using Azure DevOps, Databricks Asset Bundles (DABs), or similar, with strong instincts for metadata-driven, reusable engineering patterns. · Demonstrable track record defining and enforcing architecture standards across large, distributed engineering organisations, with the ability to influence without direct authority. · Exposure to Corporate Real Estate data domains would be welcome but not essential · Familiarity with Terraform for Azure data platform provisioning would be beneficial but not required · Background contributing to a data platform community of practice or centre of excellence is helpful. Cushman & Wakefield also provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health, vision, and dental insurance, flexible spending accounts, health savings accounts, retirement savings plans, life, and disability insurance programs, and paid and unpaid time away from work. In addition to a comprehensive benefits package, Cushman and Wakefield provide eligible employees with competitive pay, which may vary depending on eligibility factors such as geographic location, date of hire, total hours worked, job type, business line, and applicability of collective bargaining agreements. The compensation that will be offered to the successful candidate will depend on factors such as whether the position is covered by a collective bargaining agreement, the geographic area in which the work will be performed, market pay rates in that area, and the candidate’s experience and qualifications. The company will not pay less than minimum wage for this role. The compensation for the position is: $ 103,955.00 - $122,300.00 Cushman & Wakefield is an Equal Opportunity employer to all protected groups, including protected veterans and individuals with disabilities. Discrimination of any type will not be tolerated. In compliance with the Americans with Disabilities Act Amendments Act (ADAAA), if you have a disability and would like to request an accommodation in order to apply for a position at Cushman & Wakefield, please call the ADA line at 1-888-365-5406 or email HRServices@cushwake.com. Please refer to the job title and job location when you contact us. INCO: “Cushman & Wakefield”

United States
$103K - $122K / year
Zocdoc logo

Staff Software Engineer, Data

Zocdoc

Zocdoc is the beginning of a better healthcare experience for millions of patients every month.

Data Engineer86 days ago
OtherRemoteTeam 501-1,000Since 2007H1B Sponsor

Our Mission Healthcare should work for patients, but it doesn’t. In their time of need, they call down outdated insurance directories. Then wait on hold. Then wait weeks for the privilege of a visit. Then wait in a room solely designed for waiting. Then wait for a surprise bill. In any other consumer industry, the companies delivering such a poor customer experience would not survive. But in healthcare, patients lack market power. Which means they are expected to accept the unacceptable. Zocdoc’s mission is to give power to the patient. To do that, we’ve built the leading healthcare marketplace that makes it easy to find and book in-person or virtual care in all 50 states, across +200 specialties and +12k insurance plans. By giving patients the ability to see and choose, we give them power. In doing so, we can make healthcare work like every other consumer sector, where businesses compete for customers, not the other way around. In time, this will drive quality up and prices down. We’re 18 years old and the leader in our space, but we are still just getting started. If you like solving important, complex problems alongside deeply thoughtful, driven, and collaborative teammates, read on. Your impact on our mission We are looking for a Staff Software Engineer (SSE) to join our Data Engineering team! In this role, you will design, build, and optimize scalable data systems that empower decision-making and innovation at Zocdoc. You’ll collaborate with cross-functional teams to manage data pipelines, strengthen governance, and improve the tools and processes that help data producers and consumers work together effectively. This role leads our specialized Data Infrastructure group, which is responsible for building, maintaining, and optimizing the platforms that power data workflows across the company. You’ll focus on the underlying infrastructure that supports analytics, experimentation, and machine learning—ensuring it runs efficiently, securely, and cost-effectively to improve the healthcare experience for patients and providers. You’ll enjoy this role if you are… - Passionate about the inner workings of data platforms and infrastructure - Excited to tackle both technical and strategic challenges to build reliable, scalable systems - Motivated to create high-leverage tools that power analytics and data science - Energized by the opportunity to build tools and processes that directly improve patient and provider experiences through better data - Autonomous, proactive, and eager to solve complex problems with practical, scalable solutions Your day to day is… - Designing and maintaining scalable data pipelines for ingestion, transformation, and delivery across multiple data sources - Collaborating with Analytics Engineers and Product teams to curate datasets and establish data contracts that improve transparency and reliability - Developing and managing modern data architectures, such as lakehouses and medallion layers, using tools like Databricks, Delta Lake, or Iceberg - Optimizing Snowflake usage and performance, ensuring data quality and cost efficiency - Supporting and scaling orchestration platforms (like Dagster), metadata systems (like Unity Catalog or Collibra), and monitoring tools (like Datadog) - Collaborating with data engineering, analytics engineering, and security teams to deliver stable and efficient infrastructure for diverse workflows - Building tools, alerting systems, and documentation that ensure reliable operation and developer self-service across our data stack You’ll be successful in this role if you have… - 8+ years of experience in data engineering or platform/infrastructure roles, with a focus on scaling tools and systems - Expertise in Python or Scala, and strong proficiency in SQL for data modeling and optimization - Deep experience with data warehouse technologies like Snowflake, including clustering, performance tuning, query profiling, and access management - Experience with data lake and lakehouse architectures such as Databricks, Delta Lake, Iceberg, or Apache Hudi, and query engines like Athena or Presto - Proven ability to design and implement scalable ETL pipelines using technologies like dbt for transformation and Databricks for large-scale processing - Familiarity with managing infrastructure-as-code, job orchestration (Dagster, Airflow), and CI/CD workflows - A proactive mindset and strong problem-solving skills, especially when troubleshooting complex infrastructure issues - Excellent collaboration and communication skills to support cross-functional teams and data consumers Bonus if you have… - Experience implementing row-level security and data masking for PHI/PII use cases - Exposure to governance tools (e.g., Collibra, Amplitude, Looker admin, Unity Catalog) - Familiarity with AWS services, especially for storage and compute cost optimization Benefits: - Flexible work environment - Unlimited Vacation - 100% paid employee health benefit options (including medical, dental, and vision) - Commuter Benefits - 401(k) with employer funded match - Corporate wellness program with Wellhub - Sabbatical leave (for employees with 5+ years of service) - Competitive paid parental leave and fertility/family planning reimbursement - Cell phone reimbursement - Catered lunch everyday along with beverages and snacks - Employee Resource Groups and ZocClubs to promote shared community and belonging - Great Place to Work Certified Zocdoc is committed to fair and equitable compensation practices. Salary ranges are determined through alignment with market data and internal equity. The base salary offered will depend on experience, skills, qualifications, and business needs. This role is also eligible for bonus and equity. Silicon Valley, CA Base Salary Range $211,100—$285,000 USD About us Zocdoc is the country’s leading digital health marketplace that helps patients easily find and book the care they need. Each month, millions of patients use our free service to find nearby, in-network providers, compare choices based on verified patient reviews, and instantly book in-person or video visits online. Providers participate in Zocdoc’s Marketplace to reach new patients to grow their practice, fill their last-minute openings, and deliver a better healthcare experience. Founded in 2007 with a mission to give power to the patient, our work each day in pursuit of that mission is guided by our six core values. Zocdoc is a private company backed by some of the world’s leading investors, and we believe we’re still only scratching the surface of what we plan to accomplish. Zocdoc is a mission-driven organization dedicated to building teams as diverse as the patients and providers we aim to serve. In the spirit of one of our core values - Together, Not Alone, we are a company that prides itself on being highly collaborative, and we believe that diverse perspectives, experiences and contributors make our community and our platform better. We’re an equal opportunity employer committed to providing employees with a work environment free of discrimination and harassment. Applicants are considered for employment regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity, gender expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or any other class protected by applicable laws. Job Applicant Privacy Notice

United States
$211K - $285K / year
Job Closed
Mashreq logo

Technology Manager – Data Warehouse

Mashreq

We are Mashreq - Inspiring you to Rise Every Day

Data Engineer86 days ago
Full TimeRemoteTeam 1,001-5,000Since 1967H1B No Sponsor

• Manage successful execution of large engagements into production • Oversee work of the team and motivate members towards common goals • Handle client/business escalations • Conduct budgeting and resource planning activities

India
Job Closed
OtherRemoteTeam 201-500Since 1986H1B Sponsor

• Develop and own the enterprise data architecture roadmap, aligning it with the company's strategic modernization goals. • Lead the evaluation, selection, and implementation of modern data technologies, including cloud data warehouses, data lakes, data integration tools, and governance platforms. • Design a target-state architecture that supports everything from operational reporting to advanced analytics and machine learning workloads. • Create detailed architectural blueprints for data ingestion, transformation, storage, and consumption patterns across the organization. • Lead the design and oversee the development of robust, scalable, and real-time ETL/ELT data pipelines to migrate and integrate data from legacy on-premise systems to our new cloud platform (Azure). • Establish standards and best practices for data modeling (e.g., dimensional modeling, 3NF), data quality, and metadata management. • Architect solutions that ensure strict adherence to healthcare regulations, including HIPAA and HITECH, for all data at rest and in transit. • Design and implement a comprehensive Master Data Management (MDM) strategy for core entities such as Members, Providers, Claims, and Products. • Partner with security and compliance teams to define data classification, access control, and data masking/anonymization policies within the new architecture. • Serve as the lead technical subject matter expert on data architecture, providing guidance and mentorship to data engineers, BI developers, and data scientists. • Collaborate closely with business stakeholders, application developers, and infrastructure teams to ensure architectural alignment and successful solution delivery. • Effectively communicate complex technical concepts and architectural designs to both technical and non-technical audiences, from engineers to executive leadership.

Washington
$150K - $175K / year
Job Closed