ETL Developer Data Vault

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 Corporation is 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

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.