Conversion/Data Specialist

DMI is a leading provider of digital services and technology solutions, headquartered in Tysons Corner, VA. With a focus on end-to-end managed IT services, including managed mobility, cloud, cybersecurity, network operations, and application development, DMI supports public sector agencies and commercial enterprises around the globe. Recognized as a Top Workplace, DMI is committed to delivering secure, efcient, and cost-effective solutions that drive measurable results. Learn more at www.dminc.com

DMI, LLC is seeking a Conversion/Data Specialist to join us.

The Washington Metropolitan Area Transit Authority (WMATA) is seeking two Data Conversion Specialists to facilitate
the migration of data from PeopleSoft to the Oracle FDIP (Fusion Data Intelligence Platform) system, ensuring data
integrity and optimal performance. As a Data Conversion Specialist, they will be responsible for extracting, transforming,
and loading (ETL) data from PeopleSoft into FDIP. They will also need to possess front end development skills to
develop reports and dashboards as required. They will ensure that data is accurately migrated and optimized for
reporting and analytics, collaborating with various teams to achieve project goals.

Analyze the existing data structures in PeopleSoft and confirm the necessary transformations for Data Warehouse compatibility.
* Extract data from PeopleSoft using SQL and other relevant tools.
* Creation of efficient data structures that support reporting and analytics (expertise in dimensional modeling and entity-relationship (ER) modeling)
* Develop and implement data transformation processes to clean, standardize, and enhance the quality of the data during migration. * Create data mapping documents that outline the relationships between source and target data fields.
* Design and implement ETL processes to load data into the Data Warehouse, ensuring efficient performance and data integrity.
* Utilize ETL tools for data integration.
* Validate data accuracy and completeness post-migration to ensure that all data has been successfully transferred.
* Work closely with business analysts, data architects, and stakeholders to understand
data requirements and ensure alignment with business objectives.
* Familiarity with data governance, compliance, and data security protocols, including
encryption, data masking, and compliance with regulations (e.g., PII, HIPAA)
* Recommending and analyzing the possibility of Cloud Data Warehousing

Education and Years of Experience: Bachelor's degree in computer science, information systems, or a related field plus 8 years experience

Additional Requirements:

5+ experience in data migration projects, specifically from PeopleSoft to a Cloud BasedData Warehouse system.
* Strong proficiency in SQL for data extraction and manipulation
* 8+ Experience with ETL tools and data integration techniques.
* Experience with databases such as ORACLE, SQL Server, SYBASE, INFORMIX, and DB2
* Familiarity with data warehousing concepts, data modeling, and reporting tools.
* Excellent analytical, problem-solving, and communication skills. Strong attention to detail and commitment to data accuracy.

Preferred Skills:
* Experience with cloud-based Data Warehouse solutions (e.g., Oracle FDIP, Snowflake,
Amazon Redshift, Google BigQuery).
* Relevant certifications in data management or ETL tools are a plus.

Min Citizenship Status Required: Must be a U.S. Citizen or Work Visa Holder

Physical Requirements: No Physical requirement needed for this position.

Location: Washington, DC

• Can be remote within the US with occasional onsite in DMV.

DMI is a diverse, prosperous, and rewarding place to work. Being part of the DMI family means we care about your well-being. As such, we offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with a number of our award-winning, Fortune 1000 clients. The following categories make up your DMI well-being:

• Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel, and many other items to provide convenience.
• Development - Annual performance management, continuing education, tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.
• Financial - Generous 401k matches both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance, and Disability to help provide financial stability for each DMI employee.
• Recognition - Great achievements do not go unnoticed by DMI through the Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgment, and employee referral bonuses.
• Wellness - Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, and several other wellness options.

Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company.

***************** No Agencies Please *****************

Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.