ETL Developer Data Vault

Sylger Corporation; Washington (District of Columbia); On-site; USD 80,000 - 120,000; Full time

Job summary

A leading company is seeking a specialized data management professional proficient in T-SQL and Python. This role involves providing BI and ETL support to a federal agency in Washington DC, utilizing Data Vault methodology, and developing dashboards for data-driven decision-making. Candidates must possess relevant experience in data architecture and regulatory compliance.

Qualifications

• 1+ years in data modeling/warehouse using Data Vault 2.0.
• 2+ years using any Data Vault methodology.
• 5+ years in T-SQL development.

Responsibilities

• Propose and design changes to data models.
• Develop ETL/ELT jobs for data warehousing.
• Create complex data visualizations.

Skills

T-SQL

Data Management

Python

Data Vault 2.0

Azure

Tableau

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

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.