Full Stack BI Specialist

Role: Full Stack BI Specialist

About Rigil

Rigil is an award-winning, woman-owned, small business that specializes in technology consulting, strategy consulting and product development. We value teamwork and strive to build strong leaders.

Location: Washington, DC
Duration: Fulltime

Job Description:

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

Minimum Requirements:

• At least 8 years of progressively responsible, diversified technical application operations
  and maintenance in a large organization.
• 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.

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.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Rigil Corporation

About Rigil

Rigil is an award-winning, woman-owned business that specializes in technology consulting, strategy consulting and product development. We value teamwork and strive to build strong leaders.

Company Website: