ETL Developer Data Vault
Company: Sylger Corporation
Location: Washington
Posted on: April 3, 2026
|
|
|
Job Description:
Job Description Job Description Sylger Corporation is an
administrative and technical support contractor to the federal
government. We have immediate openings to provide BI and ETL
support to a federal agency located in downtown DC. The candidate
must be able to pass federal security background review. We are
looking for a T-SQL, specialist and data management professional
with extensive knowledge of Phython, Pandas and Data Vault 2.0
methodology. a. The candidate must meet or exceed each of the
following requirements: (1) One or more years of data modeling or
data warehouse architecture experience using the Data Vault 2.0
methodology; (2) Two or more years of data modeling or data
warehouse architecture experience using any Data Vault methodology;
(3) Three or more years of experience developing ETL or ETL
pipelines in an environment that uses DevOps principles and
practices (e.g., automation, infrastructure as code,
containerization, testing); and (4) Five or more years of
experience developing procedural SQL development using the TSQL
dialect. b. The below elements represent the type of work to be
performed by candidates in this position: (1) Proposing and
designing changes to a physical data model to resolve and
articulate problems; (2) Developing procedural T-SQL, SQL Server
Information Services (SSIS) jobs, or set-based SQL scripts (i.e.,
using a SELECT-INTO-FROM pattern) to extract data from a source
system and load it into the data warehouse or transform and load it
between logical layers within the data warehouse; (3) Writing
transformation expressions or functions, tests to ensure edge cases
are handled correctly by the transformation, and documentation to
explain how and why the transformation works; (4) Monitoring
deployed ETL/ELT jobs and debugging/troubleshooting any
errors/issues encountered; (5) Amending ETL/ELT scripts to
correctly handle exceptional or aberrant records; and (6) Writing
tests to verify the integrity of relations/objects within the data
warehouse. In addition the candidate must have demonstrated
capability to perform the following duties: a. Experience (within
the last year) developing schema in Azure, Python and supplemented
with expert level of Tableau visualization tools. b. Experience in
dashboard development to support data-driven for
information-sharing and decision-making; c. Shall create dashboards
from live data tables, not just data extracts; d. Shall develop
both simple and complex data visualizations; e. Experience with
performance optimization techniques, allowing for efficient data
manipulation that does not slow dashboard function for the end
user; f. Experience working collaboratively with data analysts and
other end users to gather visualization and reporting needs and
requirements; g. Familiarity with and adherence to basic design
principles, including, but not limited to, meaningful use of color;
h. Experience working with a data warehouse; i. Experience in
database systems like SQL Server and PostgreSQL; j. Experience with
data blending or joins to integrate data from multiple data
sources; k. Experience manipulating and visualizing a variety of
common data types including, but not limited to, numeric, string,
date time, and geographic/geometric; l. Experience visualizing
administrative records from multi-step business process to reflect
derived dimensions of interest to process owners, including, but
not limited to, timeliness, efficiency, completeness, and
effectiveness; m. Responsive and able to complete projects in a
timely manner; n. Shall innovate while staying within the any
imposed agency constraints; o. Flexible to work well in an
environment where things may change frequently or stall for periods
of time; p. Diligent about documentation and knowledge transfer, to
include production of clean files; q. Shall host relevant training
on dashboards; and r. Shall complete dashboard testing and
improvements. About Us Sylger Corporationis an equal opportunity
employer and does not discriminate against any applicant or
employee because of race, color, religion, sex, national origin,
disability, age, or military or veteran status in accordance with
federal law. In addition, Sylger Corporation complies with
applicable state and local laws governing non?discrimination in
employment in every jurisdiction in which it maintains facilities.
Sylger Corporation also provides reasonable accommodation to
qualified individuals with disabilities in accordance with
applicable laws. Job Types: Full-time, Temporary, Contract Company
Description Sylger Corporation is a federal government support
contractor. We provide administrative, management and technical
support to the Federal Government. We offer 1099 full time
consulting options. Company Description Sylger Corporation is a
federal government support contractor. We provide administrative,
management and technical support to the Federal Government. We
offer 1099 full time consulting options.
Keywords: Sylger Corporation, Richmond , ETL Developer Data Vault, IT / Software / Systems , Washington, Virginia
