DMI Mobile Enterprise Solutions-posted 3 months ago
Remote • Washington, DC
1,001-5,000 employees
Professional, Scientific, and Technical Services

DMI, LLC is seeking a Conversion/Data Specialist to join us. The role involves analyzing existing data structures in PeopleSoft, extracting data using SQL, and creating efficient data structures for reporting and analytics. The specialist will develop and implement data transformation processes, create data mapping documents, and utilize ETL tools for data integration. Responsibilities also include designing ETL processes, validating data accuracy post-migration, and ensuring compliance with data governance and security protocols. The position may involve recommending cloud data warehousing solutions.

  • 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.
  • Bachelor's degree in computer science or information systems.
  • 8 years of total experience needed.
  • 5 years of experience in data migration projects, specifically from PeopleSoft to a Cloud Based Data 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.
  • 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.
  • Convenience/Concierge - Virtual health visits, commuter perks, pet insurance, and entertainment discounts.
  • Development - Annual performance reviews, tuition assistance, and internal career growth opportunities.
  • Financial - Generous 401(k) matches, life and disability insurance, and financial wellness tools.
  • Recognition - Annual awards, service anniversaries, referral bonuses, and peer-to-peer shoutouts.
  • Wellness - Healthcare coverage, wellness programs, flu shots, and biometric screenings.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service