Data Integrator

Employment Type

: Full-Time

Industry

: Miscellaneous



/ETL Specialist

Key Role:

Integrate Navy-wide enterprise data sources in a federated computing environment and administer Data as a Service (DaaS) capabilities to provide customers with newfound situational awareness, operational intelligence, and insight for informed decision making. Manage and administer Extract, Transform, and Load (ETL) processes to ingest various data sources into a centralized data lake. Apply advanced knowledge of SQL to write, optimize, and debug database queries, procedures, and functions. Use relational database concepts and theories to cleanse data and identify anomalies which may lead to inaccurate reporting. Profile, clean, and normalize large datasets for ingestion into a data lake, using tools and programming languages, including Informatica PowerCenter, R Studio, VBA, Microsoft Access, and SQL. Develop data strategies to successfully oversee data flow from ingestion to repository storage and then ultimately to dashboards, interfaces, tools, and other stakeholder databases. Collaborate with teammates, data providers, and end-users to successfully transform data to information that meets stakeholder requirements and contribute to leadership decision making.

Basic Qualifications:

-1+ years of experience with performing ETL on remote systems using SOAP, RESTful, and web services

-Experience with SQL and an Object-Oriented language, including C++, C#, or Java

-Experience with converting data from and to XML, CSV, and JSON file formats

-Experience in working with an Agile or Scrum development process

-Experience with the Microsoft Office suite of applications

-Knowledge of writing software with an emphasis on programming logic and constructs

-Ability to troubleshoot integration, application, and database issues

-Active Secret clearance

-HS diploma or GED

Additional Qualifications:

-Experience with industry standard ETL tools, including Tableau or Informatica PowerCenter

-Experience with the following languages: R, Python, HTML5, CSS, JavaScript, or PowerShell

-Experience with the handling and processing of classified information

-Experience with Risk Management Framework (RMF)

-Knowledge of emerging technology solutions, including cloud and NoSQL environments, such as HDFS and Hadoop, geographically-enabled databases, such as GIS systems, real-time data processing applications, and DoD variants

-Knowledge of IT security at the Security+ level

-Possession of excellent oral and written communication skills

-BS degree in Science, Technology, Engineering, Mathematics, Information Systems, or a related field

-Certified Business Intelligence Professional (CBIP) Certification

Clearance:

Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; Secret clearance is required.

We’re an EOE that empowers our people—no matter their race, color, religion, sex, gender identity, sexual orientation, national origin, disability, veteran status, or other protected characteristic—to fearlessly drive change.


Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...