Senior ETL Developer
Company: 9th Way Insignia
Location: Washington
Posted on: February 18, 2026
|
|
|
Job Description:
Job Description Job Description 9th Way Insignia is a
service-disabled, veteran-owned small business bringing
transformative technology to our government customers so they can
achieve their missions. Our specialties include cybersecurity,
cloud modernization, software development, data analytics,
enterprise architecture, enterprise IT, analytics, process
automation, and artificial intelligence. Learn more about 9th Way
Insignia at https://9thwayinsignia.com/. Application password:
Niner Team (Project) Introduction The Office of Performance
Analysis and Integrity manages and enhances the Veterans Benefits
Administration (VBA) Enterprise Data Warehouse (EDW) which resides
on one Oracle M8 Supercluster database and thirteen application
servers. Our team provides the technical services required to
sustain EDW applications to include Project Management, Data
Warehouse Management, Advanced Analytics, Tableau Server
Administration/Tableau Desktop Administration, Technical
Collaboration Support, Lessons Learned, Executive Orders and
Special Projects, Architectural Enhancement, and Cloud Migration.
We also provide management, enhancement, integration,
implementation, maintenance, modernization, and infrastructure
support for EDW applications as well as enhancement and maintenance
of business intelligence capabilities and predictive analytics. 9th
Way Insignia is looking for a Senior ETL Developer to join this
team. Professional Level Information An Engineer 3 typically plans
and directs research or development work on complex projects, along
with engaging various parties in design and development. Costs and
recommendations of new components may also involve part of the job
scope. Performs multiple engineering-related tasks in various
assignments within the project and firm. An Engineer 3 oversees the
design, development, implementation, and analysis of technical
products and systems. An Engineer 3 has broad knowledge of
engineering procedures and assists in the resolution of complex
problems. An Engineer 3 has strong technical skills and background,
a knack for learning new technologies, and a blend of good
problem-solving and innovation needed to resolve a wide variety of
technical production challenges. Responsibilities: Data
warehousing, data modeling, data integration, data Migration, ETL
process and Business Intelligence Data Modeling design, analysis
and implementation - conceptual, logical, and physical data
modeling, data conversion, data integration and data mining
specialization in the area of Data Warehouse and Business
Intelligence Installing, configuring, developing, supporting and
maintaining of the BI APPS Developing ETL's using Informatica to
facilitate Extraction Transformation and data load from OLTP
systems to OLAP systems Designing schema using KPIs, Fact,
Dimensions, Physical, Logical, Alias and Extension tables Building
business model and established relationships and foreign keys
(physical & logical) between tables Creating LDAP authentication to
enable single-sign on for users in development environment
leveraging analytics repository Using Informatica Mapping Designer
to create/update mapping using different transformations required
to move data into data warehouse Providing recommendations and
identifying critical issues and processing faults as it pertains to
data modeling, ETLs and Informatica Other responsibilities as
assigned Requirements: Master's degree in computer science or other
technical disciplines (an additional 10 years of experience can
substitute for a degree). 15 experience in ETL tools, especially
Informatica and data warehousing applications 10 years' experience
developing and tuning complex SQL queries in Oracle relational
database Must be authorized to work for any employer in the U.S
Must be able to obtain and maintain the required security clearance
Location On site in Washington DC. Salary Range $118,737—$150,000
USD 9th Way Insignia's range for this job level is a general
guideline only and not a guarantee of compensation or salary.
Additional factors considered in extending an offer include (but
are not limited to) responsibilities of the job, education,
experience, knowledge, skills, and abilities, as well as internal
equity, alignment with market data, applicable bargaining agreement
(if any), or other law. Clearance/Background Investigation
Applicants selected will be subject to a security investigation and
may need to meet eligibility requirements for access to classified
information. Benefits Eligible employees will have access to our
comprehensive benefits package which includes Medical, Dental,
Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD,
LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources
include our Employee Assistance Program (EAP) and Traveling
Assistance. Legal We're an equal employment opportunity employer
that empowers our people to fearlessly drive change – no matter
their race, color, religion, sex (including pregnancy, childbirth,
lactation, or related medical conditions), national origin, age,
marital status, sexual orientation, gender identity, disability,
veteran status, military or uniformed service member status,
genetic information, or any other status protected by applicable
federal, state, or local law.
Keywords: 9th Way Insignia, Alexandria , Senior ETL Developer, IT / Software / Systems , Washington, Virginia