Full Stack BI Specialist Job Washington area,District of Columbia USA,IT/Tech

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

About the Opportunity

DMI, LLC is seeking a Full Stack BI Specialist to join us. 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, responsible for extracting, transforming, and loading (ETL) data from People Soft 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.

Duties and Responsibilities:

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.

Analyze and gather the requirements of BI data from users/customers.

Create ETL/ELT for Peoplesoft EPM Data Warehouse.

Maintain the ERP data warehouse and Ascential/Datastage environments.

Design and develop data models and data mart tables.

Design and develop ETL processes and data pipelines using Data Stage ETL tool.

Support and maintain Production ETL processes and jobs of Data Stage.

Support and fulfill ad-hoc data requests from customers and management using SQL queries and Excel sheets and perform data validation, accuracy, and completeness during delivery of the data.

Support other BI team members during the 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.

Qualifications

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 experience in a large organization.

Additional Requirements:

Proven experience in data migration projects, specifically from People Soft 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 Data Stage.
Experience in customizing People Soft delivered maps.
Six (6) months of experience using the Data Stage tool and version designated in the Task Order.
Excellent communication skills.

Preferred Skills:

Experience with cloud-based Data Warehouse platforms and solutions (e.g., Oracle FDIP, Snowflake, Amazon Redshift, Google Big Query).
Relevant certifications in data management or ETL tools are a plus.
Experience with one or more of the following systems:
Maximo, People Soft FSCM, HCM, ELM, People Soft EPM, Next Fare, and Trapeze.
3+ Years of Experience in building ETL Maps/Sequences using IBM Data Stage (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: Washington, DC with option to work remote.

Working at DMI

DMI is a…


Increase/decrease your Search Radius (miles)



Job Posting Language