Full Stack BI Specialist

DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation, manufacturing, and other critical infrastructure sectors. DMI has grown to over 2,100+ employees globally and has been continually recognized as a Top Workplace in both regional and national categories.

DMI, LLC is seeking a Full Stack BI Specialist to join us.

Duties and Responsibilities:

WMATA is seeking two (2) BI Specialists to facilitate the re-platforming of our current Data Warehouse to Oracle FDIP, ensuring data integrity and optimal performance. This resource will also assist as a Data Conversion Specialist, they will
be responsible for extracting, transforming, and loading (ETL) data from PeopleSoft into our Data Warehouse system,
and rebuilding data warehouse structures and reports in the FDIP system. They will ensure that data and reports are
accurately migrated and optimized for accurate reporting and analytics, collaborating with various teams to achieve
project goals

* 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
* Analyze requirements for BI reports and dashboards;
* Analyze data sources for mapping to BI requirements;
* Work closely with customers to determine the best approach for the user community
* Use BI tools to develop reports, dashboards, and widgets; create and execute test plans
* coordinate life cycle activities from development to production;
* Create and maintain data models to support requirements;
* Determine the best approach for data delivery depending on data sources and requirements;
* Develop spreadsheets and databases as needed to support interim strategies for data
* To analyze and gather the requirements of BI data from users/customers
* Need a create ETL/ELT for Peoplesoft EPM Datawarehouse
* Maintaining the ERP data warehouse and Ascential/Datastage environments
* To design and develop data models and data mart tables
* To design and develop ETL processes and data pipelines using Data Stage ETL tool.
* To support and maintenance of Production ETL processes and jobs of Data Stage
* To support and fulfill adhoc data requests from customers and management using SQL queries and Excel sheets and to perform data validation, accuracy and its completeness during delivery of the data
* To support other BI team members during development of reports and dashboards for their data needs.
* Document product specifications, create user guides for operations and maintenance
* Support cyber security reviews and implement remediations as required

Education and Years of Experience:
Graduate degree or equivalent from an accredited college or university with a bachelor's degree in Management information science, Computer Science, Mathematics, Finance, Business, Accounting, Public Administration, or in a related discipline
At least 8 years of progressively responsible, diversified technical application operations and maintenance experiencein a large organization

Required and Desired Skills/Certifications:

Additional Requirements:

* Proven 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.
* 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 in IBM Datastage
* Experience in customizing Peoplesoft delivered maps
* Six (6) months of experience using the Datastage tool and version designated in theTask Order
* Excellent communication skills

Preferred Skills:
* Experience with cloud-based Data Warehouse platforms and solutions (e.g., Oracle FDIP, Snowflake, Amazon Redshift, Google BigQuery).
* Relevant certifications in data management or ETL tools are a plus
Experience with one or more of the following systems: Maximo, PeopleSoft FSCM,
HCM, ELM, PeopleSoft EPM, NextFare, and Trapeze;
3+Years of Experience in building ETL Maps/Sequences using IBM DataStage(IBM
Infosphere Information Server)
In depth understanding of Data Warehouse Principles
Experience in the transit industry

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

Physical Requirements: No Physical requirement needed for this position.

Location: Remote, US with occasional onsite in DMV

Working at DMI

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

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, and 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 help provide financial stability for each DMI employee.
• Recognition - Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgment, 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. The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination based on their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.

***************** 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.