DMI
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, ef?cient, and cost-effective solutions that drive measurable results. Learn more at www.dminc.com
About the Opportunity
DMI, LLCis seeking a
Conversion/Data Specialist to join us. Duties and Responsibilities: 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 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. Utilize ETL tools for data integration. Design and implement ETL processes to load data into the Data Warehouse, ensuring efficient performance and data integrity. 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. 8 years of total experience needed. Additional Requirements: 5 years of experience in data migration projects, specifically from PeopleSoft to a Cloud BasedData Warehouse system. Strong proficiency in SQL for data extraction and manipulation. 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/Remote Can be remote within the US with occasional onsite in DMV. Working at DMI
DMI is a diverse, prosperous, and rewarding place to work. Our culture is shaped by five core values that guide how we work, grow, and succeed together: Do Whats Right
We lead with honesty and integrity. Own the Outcome
We take responsibility and deliver. Deliver for Our Customers
We are relentless about delivering value. Think Bold, Act Smart
We innovate with purpose. Win Together
We collaborate and celebrate our success. These values arent just idealsthey show up in how we support every part of your well-being: Convenience/Concierge
Virtual health visits, commuter perks, pet insurance, and entertainment discounts that make life easier. Development
Annual performance reviews, tuition assistance, and internal career growth opportunities to help you thrive. Financial
Generous 401(k) matches, life and disability insurance, and financial wellness tools to support your future. Recognition
Annual awards, service anniversaries, referral bonuses, and peer-to-peer shoutouts that spotlight your achievements. Wellness
Healthcare coverage, wellness programs, flu shots, and biometric screenings to support your health. DMIvalues employeesfor their talents and contributions, and we take pride in helping our customers achieve their goals. Because when we live our values, we all win together. ***************** 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. #J-18808-Ljbffr
DMI, LLCis seeking a
Conversion/Data Specialist to join us. Duties and Responsibilities: 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 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. Utilize ETL tools for data integration. Design and implement ETL processes to load data into the Data Warehouse, ensuring efficient performance and data integrity. 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. 8 years of total experience needed. Additional Requirements: 5 years of experience in data migration projects, specifically from PeopleSoft to a Cloud BasedData Warehouse system. Strong proficiency in SQL for data extraction and manipulation. 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/Remote Can be remote within the US with occasional onsite in DMV. Working at DMI
DMI is a diverse, prosperous, and rewarding place to work. Our culture is shaped by five core values that guide how we work, grow, and succeed together: Do Whats Right
We lead with honesty and integrity. Own the Outcome
We take responsibility and deliver. Deliver for Our Customers
We are relentless about delivering value. Think Bold, Act Smart
We innovate with purpose. Win Together
We collaborate and celebrate our success. These values arent just idealsthey show up in how we support every part of your well-being: Convenience/Concierge
Virtual health visits, commuter perks, pet insurance, and entertainment discounts that make life easier. Development
Annual performance reviews, tuition assistance, and internal career growth opportunities to help you thrive. Financial
Generous 401(k) matches, life and disability insurance, and financial wellness tools to support your future. Recognition
Annual awards, service anniversaries, referral bonuses, and peer-to-peer shoutouts that spotlight your achievements. Wellness
Healthcare coverage, wellness programs, flu shots, and biometric screenings to support your health. DMIvalues employeesfor their talents and contributions, and we take pride in helping our customers achieve their goals. Because when we live our values, we all win together. ***************** 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. #J-18808-Ljbffr