ETL Developer-Mid Level

Arlington, VA

Share This Job

Job Description

Take your career to the next level with Octo!

Octo Consulting is searching for a dynamic ETL Developer to join our growing team and support a Navy Business Intelligence Program.   

What does Octo do?

At Octo, our focus is on delivering results that matter. We are a premier provider of digital solutions and services to the federal government specifically in the areas of UI/UX, Agile, Data, and Cloud services. Our clients are federal agencies that are making a difference in the world.

Responsibilities

-          Assist in creating and maintaining data warehouse schemas and ETL processes.

-          Coordinates the data administration technical function for both data warehouse development and maintenance.

-          Assist IT Architects, Analysts, Data Scientists, UI/UX designers, functional practitioners, and clients/stakeholders to gather data requirements

-          Assist in facilitating change control, problem management, and communication among data architects, programmers, analysts, and engineers.

-          Assist in establishing processes to ensure a consistent, well managed, and well-integrated data warehouse infrastructure.

-          Analyzes and identifies data and metadata requirements. 

-          Defines user requirements and database design specifications. 

-          Assist in the design, implementation, and supports data warehousing requirements. 

-          Implements business rules via stored procedures, middleware, or other technologies.

-          Provides product support and maintenance of the data warehouse.

-          Performs data warehouse design and construction.

-          Prepares/implements data verification and testing methods for the data warehouse.

 

Skills & Requirements

Requirements:

-          Experience 1-3 years working with data in either databases, data warehouses or similar applications

-          Experience working with relational databases (Oracle, PostgreSQL, MySQL or similar)

-          Ability to create complex SQL queries and tuning runtime performance of the queries

-          Ability to create stored procedures and database views

-          Knowledge with ETL tools (i.e., SSIS, Oracle Data Integrator, Informatica, InfoSphere, etc.)

-          Understanding of data warehouse modeling, data migration and auditing

-          Knowledge building high performing data transfer processes.

-          Strong consulting and client management skills.

-          Demonstrated track record of analytical and critical thinking skills.

-          Organized, motivated and demonstrate the ability to work under minimal supervision to achieve desired objectives.

 

Educational Requirements: 

  • Bachelor's degree in an IT related field

Location: Arlington, VA

Clearance Requirements:

  • An active SECRET clearance is required

Physical Requirements:

  • Regularly required to sit for extended periods up to 80% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc.
  • Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs.
  • Specific vision abilities required by this job include use of computer monitor screens up to 80% of time

 Work Environment:

  • Individual’s primary workstation is located in an office area
  • The noise level in this environment is low to moderate

 

Why Octo?

Octo has been voted an employer of choice for a reason!   We offer AMAZING benefits and competitive compensation combined with an unparalleled company culture.  Our office is a friendly and fun place to work (even if we do say so ourselves!). Everybody looks forward to our company events and Octo has a very transparent leadership style where employees matter.  At Octo, you’ll be working with inspiring industry experts working on projects that have a great impact.  

 

  • Please, no Corp-to-Corp or 1099 candidates; this position is W-2 only.
  • US citizenship is required by the contract
  • Relocation will not be offered.
  • Octo Consulting Group is an Equal Opportunity/Affirmative Action employer.  All qualified candidates will receive consideration for employment without regard to disability, protected veteran status, race, color, religious creed, national origin, citizenship, marital status, sex, sexual orientation/gender identity, age (40 or over), or genetic information. Octo Consulting Group’s commitment to diversity and inclusive selection practices includes ensuring qualified long-term unemployed job seekers receive equal consideration for employment.
  • Selected applicant will be subject to a background investigation.
  • The description provided above is not intended to be an exhaustive list of all job duties, responsibilities, and requirements.  Duties, responsibilities, and requirements may change over time and according to business need.