Washington, DC
51-200 employees
Analytica is an award-winning federal consulting & IT solutions firm supporting federal health, civilian, & national security missions.

ETL Developer

ETL Developer

This job is no longer open

Analytica is seeking a senior ETL Developer to support a federal government client.  The ideal candidate is able to work in a consultative approach with clients, has solid experience in ETL development experience. The ETL Developer will be working with Data Science team to understand data requirements, develop SQL queries and stored procedures to extract and cleanse data, load into database format for consumption by data models.

Analytica has been recognized by Inc. Magazine as the fastest-growing private US small business.  We work with U.S. government customers in health, civilian, and national security missions.  As a core member you’ll work with a diverse team of professionals to solution matters, architect nuisances, and come up with alternatives.  We offer competitive compensation with opportunities for bonuses, employer paid health care, training and development funds, and 401k match.

Responsibilities include (But Are Not Necessarily Limited To):

  • Support extract, transform, and load (ETL) processes for SQL Server database and support programs and processes to load update.
  • Create and maintain SQL scripts, stored procedures, and other program logic to create, update, and delete data.
  • Design and implement schema changes, manage indexes, and alter data objects to optimize performance.
  • Design efficient data models from a logical design based on business requirements and available use patterns.
  • Identify entity relationships, referential integrity constraints, and primary key structures. Perform analysis of tradeoffs between alternative schemas.
  • Design efficient data models from a logical design based on business requirements and available use patterns.
  • Create and maintain documentation that includes file specifications, schema, core record layouts, programs, business requirements, test plans, and other artifacts used in the administration, creation, and execution of database operations

Basic Qualifications:

  • Bachelor’s Degree in Computer Science, IT, Computer Engineering, or related field
  • Strong SQL development experience, data modeling and database security
  • Knowledge of /familiar with, Sap Data Services
  • Experience using SQL tools
  • Experience conducting ETL processes on large XML, flat files, and database table data sources
  • Experience working in Unix and Linux
  • Familiarity with tax and financial data a plus

About ANALYTICA: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD, the company is an established SBA certified HUBZone and 8(a) small business that has been recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growing companies in the U.S.  Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI® Maturity Level 3 and is an ISO 9001:2008 certified provider.

As a federal contractor, Analytica is required to verify that all employees are fully vaccinated against COVID-19. If you receive an offer and are unable to get vaccinated for religious or medical reasons, you may request a reasonable accommodation.

This job is no longer open
Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.