Data Migration Specialist - 3749342

You've stumbled upon the rare B Corp government contractor! At TCG, we aim to prove that businesses can be good to their employees and responsible to their community while being profitable. We're an award-winning IT solutions provider to the Federal government seeking a Data Migration Specialist to plan, implement, and execute a strategy to migrate data currently hosted in an unstructured, NoSQL MongoDB database to a structured database format hosted in a PostgreSQL relational database management system.

U.S. citizenship is required for this role. In addition, the selected applicant must submit to a government background investigation and be favorably adjudicated before their first day.

This hybrid position will require a minimum of 3 days on-site each week. The selected applicant must live within commuting distance of Washington, D.C.

RESPONSIBILITIES:

• Analyze existing MongoDB collections to understand data structures, relationships, and anomalies.
• Design normalized PostgreSQL schemas to support business and application requirements.
• Develop repeatable migration processes, including extract, transform, and load (ETL) scripts.
• Clean, standardize, and transform data to align with new relational models while identifying and resolving data quality issues.
• Work closely with technical and non-technical stakeholders to validate migrated data for accuracy, completeness, and integrity.
• Document data mapping, transformation logic, and migration processes.

REQUIRED SKILLS & EXPERIENCE:

• 5+ years of experience with data modeling and designing relational schemas.
• 3+ years of experience developing migration scripts and ETL processes using Python or similar scripting languages.
• Demonstrated experience migrating data from NoSQL databases (MongoDB preferred) to relational databases (PostgreSQL preferred).
• Experience working with unstructured or inconsistent data.
• Ability to work in an agile or iterative development environment.

PREFERRED SKILLS & EXPERIENCE:

• Experience with data migration tooling, ETL frameworks, or orchestration tools.
• Familiarity with database performance considerations and testing.

TCG does not discriminate based on race, sex, color, religion, national origin, age, disability, caste, or veteran status.

Our B Corp mission is reflected in our benefits, including offerings like health care, 401K, parental leave, adoption assistance, financial planning services, student loan repayment assistance, and training budget. There's more, see for yourself.

TCG is recognized for treating employees well. In fact, in 2024, The Washington Post named TCG as a "Top Workplace" for the tenth straight year based on how our employees feel about the company, the benefits TCG offers, and the work/life balance that our staff achieves. Our CEO was ranked best, by TCG employees' votes, among all midsize companies in the Washington Post Top Workplace survey.

Try us ... we'll make you happy.

Internal title/grade: Data Analytics Analyst, E2
Salary Range: $95,000 - $125,000

All individuals being hired to work for TCG must submit to, and successfully pass, a pre-employment background investigation prior to reporting for their first day of work. The pre-employment background investigation will include verification of employment and education, as well as, a criminal and DMV check.

Additional documentation and background checks will also be required for positions that require clearance from the Federal government.