Navy ERP Specialist (5185) with Security Clearance

Three Saints Bay, LLC; Patuxent Highland (MD); Presencial; USD 74.415.000 - 85.418.000; Jornada completa

Descripción de la vacante

Three Saints Bay, LLC is seeking a data analyst-type professional for the Navy ERP reporting data warehouse project located in Patuxent River, MD. The role involves collecting and analyzing large financial data sets, defining requirements with customers, and performing ETL using TOAD, SQL, and Informatica.

The candidate will support data warehouse reporting, provide technical specifications, and ensure data integrity through testing and validation in a fast-paced environment.

Formación

• Minimum of a High School Diploma or equivalent.
• Three (3) years of data analysis experience.
• US Citizen.

Responsabilidades

• Perform data collection, data analysis, testing and troubleshooting on large quantities of financial data.
• Translate customer requirements into technical specifications for reporting solutions.
• Extract, transform and load data using TOAD, SQL and/or Informatica.
• Provide configuration and/or data management for data, information, files and documents.
• Support requirements include data mapping, data warehouse reports and end user test plans.

Conocimientos

Data analysis

SQL queries

Communication

Teamwork

Problem solving

Time management

Attention to detail

Educación

High school diploma or equivalent

Herramientas

TOAD

Business Objects

Cognos

Power BI

Tableau

Qlik

Informatica

Descripción del empleo

Description of duties:

• Perform data collection, data analysis, testing, and troubleshooting on large quantities of financial data.
• Work with customers to define requirements and business rules for reporting solutions
• Extract, transform, and load data using TOAD, SQL, and/or Informatica
• Provide configuration and/or data management for data, information, files, and documents. Position Responsibilities:
• Translate customer requirements into technical specifications.
• Analysis to address current and future Navy ERP information needs.
• Functional support for reporting solutions.
• Involved in database design and deployment. Position Requirements:
• US Citizen.
• Experience developing and executing SQL queries in Business Objects / TOAD / Cognos or similar BI tool
• Familiarity with visualization tools such as Qlik, Tableau or PowerBI
• Advanced proficiency in MS Word and Excel (mail merge, pivot tables, macros, VBA)
• Ability to pass background check and Investigation for Tier 3 Public Trust Clearance.
• Minimum of a High School Diploma or equivalent.
• Minimum of three (3) years of data analysis experience .
• Strong attention to detail and organizational skills.
• Excellent verbal and written communication skills.
• Demonstrated problem-solving skills.
• Ability to work independently and as a team.
• Must possess strong time management skills.
• Must be able to work in a fast-paced, changing, and challenging environment. Desired Experience:
• Experience developing/creating reports with Business Objects or other BI query tool
• Experience developing visualizations using Qlik, Tableau or PowerBI
• Experience with Navy ERP or other similar financial management system a plus Support requirements include, but are not limited to:
• Provide technical analyses and functional support of the Data Warehouse Project through all phases of requirements development, testing and maintenance. The Contractor shall collect information from a variety of source systems or files (e.g., Navy ERP, Defense Civilian Personnel Data System (DCPDS), Total Force Manpower Management System (TFMMS), Navy Manpower Planning and Budgeting System (NMPBS), etc.) as well as the various legacy transactional systems and spreadsheets for data mapping, integration, and loading.
• Review and research data warehouse table discrepancies.
• Prepare end user test plans to support User Acceptance Testing, conduct functional testing and perform system validation.
• Provide updates and corrections to the data mapping and validate/test the data warehouse reports.
• Provide functional support for the restructuring or redesigning of existing data which will result in improved reporting capability.
• Support live systems, currently housed in the data warehouse as well as any that are planned to be included in the warehouse.
• Perform information technology/management information studies on business, financial, and total force systems and provide recommendations and alternative solutions.
• Provide data management for the warehouse by the review of Functional Design Specifications (FDS) and Technical Design Specifications (TDS), source analysis worksheets (SAWs), identify business rules, and develop data dictionaries and nomenclature conventions. Position located in Patuxent River, MD. Rate: $25.97 - $29.81/Hour VEVRAA Federal Contractor Three Saints Bay, LLC and its subsidiaries offer a team-oriented working environment and the opportunity to work with exceptional, dedicated industry professionals. We offer our employees a comprehensive benefits package and the opportunity to take part in exciting projects with government and commercial clients, both domestic and international. We are an Equal Opportunity Employer. We invite resumes from all interested parties without regard to race, color, sex, sexual preference, religion, creed, national origin, age, genetic information, marital or veteran status, disability, or any other category protected by federal, state, or local law.