Conversion/Data Specialist
Company: DMI (Digital Management, Inc.)
Location: Washington
Posted on: June 1, 2025
|
|
|
Job Description:
Conversion/Data Specialist
Job ID
2025-27573
Category
System Engineering
Location
US-DC-Washington
About DMI
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
About the Opportunity
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
Qualifications
Education and Years of Experience: Bachelor's degree in computer
science, information systems, or a related field plus 8 years
experience Additional Requirements:
* 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
Working at DMI
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:
Connect With Us!
Not ready to apply? Connect with us for general consideration.
Keywords: DMI (Digital Management, Inc.), Lancaster , Conversion/Data Specialist, Other , Washington, Pennsylvania
|
Click
here to apply!
|
