DMI · 1 day ago
Full Stack BI Specialist
Washington, DC
Full-time
Hybrid
Senior Level, Lead/Staff
8+ years expDMI is a leading provider of digital services and technology solutions, headquartered in Tysons Corner, VA. They are seeking a Full Stack BI Specialist to facilitate the re-platforming of their Data Warehouse to Oracle FDIP, ensuring data integrity and optimal performance, while also assisting with data conversion and ETL processes.
Cyber SecurityEnterprise SoftwareInformation TechnologySoftware
No H1B
U.S. Citizen Only
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
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
Qualification
Required
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
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 the Task Order
Excellent communication skills
Must be a U.S. Citizen or Work Visa Holder
Preferred
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
Benefits
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.
Company
DMI
DMI is a leading provider of digital services and technology solutions with a focus on end-to-end managed services, including managed mobility, cloud, cybersecurity, network operations, and application development.
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
$8.44MKey Investors
OceanSound Partners
2021-10-26Private Equity
2016-08-31Series Unknown· $4.19M
2013-06-03Debt Financing· $0.2M
Leadership Team
Gary Wang
Chief Technology Officer
Jay Sunny Bajaj
Founder and Board Member
Recent News
Company data provided by crunchbase