This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description GovCIO is currently hiring for a highly skilled and experienced Data Migration Specialist to support the migration of legacy HR data systems into a new Workday based HR environment. The successful candidate will play a critical role in ensuring a seamless and efficient transition, optimizing data preparation and transfer performance, and assist in maintaining data integrity throughout the migration process. This position is fully remote with the potential to support in person in Washington, DC, as needed. - Conduct a comprehensive assessment of existing databases and systems, including schema, data, stored procedures, and applications. - Support the data migration effort, utilizing tools, custom scripts, or ETL processes to transfer data. - Provide technical experience regarding data models (logical and physical) database design development, data mining and segmentation techniques. - Perform mass data imports/exports using the API or various import tools. - Apply strong analytical skills to collect, organize, analyze, and distribute substantial amounts of information with meticulous attention to detail and accuracy. - Ensure data integrity and accuracy during the migration process. - Implement effective indexing and caching strategies. - Document the entire migration process, including best practices, procedures, and configurations. - Assist with training and knowledge transfer to internal teams for ongoing support and maintenance. Qualifications - Ability to obtain a DHS Public Trust security clearance (US Citizenship Required). - Bachelor’s degree in information technology or related field, or the equivalent combination of education, professional training, or commensurate work experience. - 5+ years of work experience. - 3+ years of experience in data migration or related roles. - Experience with ETL development tools and data warehouse architecture techniques. - Working knowledge of databases (Microsoft SQL, Oracle, DB2), programming (XML, JavaScript, or ETL frameworks). - Knowledge of and experience using analytical reporting tools. - Familiar with effective approaches and practical experience in data migration, data quality, master data management, and data security, including the use of relevant tools. - Strong proficiency in scripting and automation for data migration tasks. - Experience with performance tuning and optimization of PostgreSQL databases. - Excellent problem-solving and troubleshooting skills. Requirements - Experience with Low Code / No Code Platforms such as Workday, ServiceNow, Salesforce, etc. - Experience with HR systems and HR data lifecycle. Company Description GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens. But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer? Employee Perks - Employee Assistance Program (EAP) - Corporate Discounts - Learning & Development platform, to include certification preparation content - Training, Education and Certification Assistance* - Referral Bonus Program - Internal Mobility Program - Pet Insurance - Flexible Work Environment *Available to full-time employees Equal Opportunity Employer We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets. Posted Salary Range The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an “at-will position” and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors. Posted Salary Range: USD $105,000.00 - USD $115,000.00 /Yr.

Role Description Aktuell migrieren wir unsere gesamte Infrastruktur von selbst-gehosteten Systemen (Shopware 6 + Moodle) auf eine moderne SaaS-Architektur (LearnWorlds + Hubspot). Unsere Shopware-Datenbank wird bereits vollständig via Fivetran nach Google Cloud (BigQuery) gespiegelt. Du arbeitest nicht im Shop selbst, sondern direkt auf Datenbank- und Cloud-Ebene. Wir suchen jemanden, der diese Migration technisch sauber umsetzt und danach unsere Dateninfrastruktur strategisch weiterentwickelt. - KURZFRISTIG: Datenmigration - Extraktion relevanter Daten aus unserer gespiegelten Shopware DB (BigQuery) - Datenbereinigung (Duplikate, Formate, Sonderfälle) - Mapping und Überführung in das HubSpot-Datenmodell (Kontakte, Deals/Orders, Products, Line Items) - Intelligentes Deduping (E-Mail als Match-Key, keine Doppelkontakte) - Entwicklung von Import-Skripten via HubSpot API (Batch-Imports, Rate Limits, Error Handling) - Validierung & Abgleich - Saubere Dokumentation aller Skripte, Mappings und Prozesse - LANGFRISTIG: Dateninfrastruktur & Automatisierung - Sicherstellung und Weiterentwicklung der Datenqualität in LearnWorlds & HubSpot - Aufbau und Pflege von Reporting- und Dashboard-Strukturen - Umsetzung neuer Integrationen zwischen unseren SaaS-Tools (API-Anbindungen, Automatisierungen) - Weiterentwicklung unseres Datenmodells bei neuen Anforderungen Qualifications - Sehr gute SQL-Kenntnisse - komplexe JOINS über relationale Datenbanken sind für dich Standard - Erfahrung mit BigQuery oder vergleichbaren Cloud-DWH-Systemen - Erfahrung mit ETL-Prozessen und Datenmigrationen - API-Erfahrung (idealerweise HubSpot) oder schnelle Einarbeitung in REST-APIs - Scripting-Erfahrung (Python, Node.js oder vergleichbar) - Strukturierte, saubere Arbeitsweise inkl. Dokumentation - Sehr gute Deutsch und Englischkenntnisse - Wohnsitz in DE Benefits - Ein motiviertes, junges Team, das gemeinsam wächst und dich dabei unterstützt, deine Ziele zu erreichen - Konstruktives Feedback auf Augenhöhe, das dich fachlich wie persönlich weiterbringt - 100 % remote – arbeite dort, wo du dich am wohlsten fühlst - Legendäre Teamreisen & regelmäßige Teamevents, die für echte Highlights sorgen - Ein innovatives Umfeld, in dem du gestalten kannst statt nur abzuarbeiten - Vertrauen in dich als Mensch – Eigenverantwortung statt Mikromanagement - Kolleg:innen, die zusammenhalten, nicht nur zusammenarbeiten - Das geilste Online-Unternehmen Deutschlands – behaupten wir nicht nur, ist so!

• Design and optimize scalable data pipelines and data architecture. • Build cloud-native data solutions using Azure, Databricks ( Unity Catalog & Delta Lake), and other big data technologies. • Build and maintain DBT models and understand the data domains like finance, e-commerce, pharma, and supply chain. • Collaborate with business stakeholders and analysts to deliver data-driven solutions. • Apply CI/CD practices and continuously improve performance, scalability, and security. • Contribute to a strong data culture through continuous learning and knowledge sharing.

• Manages the overall data platform and infrastructure and mentors the team of data engineers • Supports developing processes, and expanding technology roadmap, planning features, measuring outputs, and ensuring quality products • Derives analytical insights from a variety of business contexts and communicates those insights effectively to stakeholders • Manages design and development of software and processes to support large scale, efficient data pipelines • Optimizes the availability of data to generate insights and address business needs • Translates technical business goals and requirements into designs utilizing best practice design patterns • Partners with engineering leads, product managers, and design leads in shaping and guiding the technical direction for the data engineering team • Plans, prioritizes and executes data production projects and processes • Develops the standards and processes required to ensure high-quality data products • Participates in code reviews and helps lead technical discussions • Manages the automation of key ETL / ELT processes for large volumes of data