Full Stack BI Specialist

Job Description

Duties/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 Data Warehouse
• 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 the Datastage ETL tool.
• To support and maintenance of Production ETL processes and jobs of Datastage
• 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

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

Must have 

At least 8 years of progressively responsible, diversified technical application operations and maintenance in a large organization.

Experience

Minimum Requirements:

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• 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; and 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