Job Description
Sylger Corporation is an administrative and technical support contractor to the federal government. We have an immediate opening to provide support a federal client located in downtown DC. The candidate must be able to pass public trust security background review. This is an onsite, contract support position currently funded through September 29, 2020.
We are looking for a Data Vault 2.0 certified, Python Guru with extensive system level test experience, combined with ETL data management and extensive knowledge of cloud, Data warehouse. information technology, data analysis and visualization. Knowledge of Tableau data visualization and analytical tools a plus.
Required/Desired Experience: :
ETL (extract, transform, load)
a. Additional Skills Required
1. Microsoft SQL Server 2012 and above;
2. Procedural SQL development using the T-SQL dialect;
3. SQL Server Information Services(SSIS) or similar ETL/ELT tool; and
4. Deep understanding of the relational data model and common data warehousing methodologies and architectures (e.g.,Inmon-style data warehousing, Linstedt’s Data Vault).
Knowledge/Experience Desired - Please indicate in your cover letter which one(s) you possess and level of experience (knowledgeable, intermediate or proficient)..
1. SQL Server Analysis Services (SSAS);
2. SQL Server Reporting Services(SSRS);
3. ERWin or similar data modeling tool;
4. Attunity or similar data warehouse automation tool;
5. Experience with database administration activities (e.g., backup/recovery, schema-level permissions, job scheduling);
6. Commercial cloud computing experience (e.g., Azure, GCP, AWS);
7. Version control or source code management systems (e.g., Git, TFS);
8. Issue/project management systems(e.g., TFS, Github, Gitlab);
9. Subject matter knowledge within the field of criminal justice; and
10. Familiar with one or more metadata management and data publishing systems with support for tracking data lineage/provenance and facilitating user discovery of relevant data sources(e.g., CKAN, Apache Atlas, Amundsen).
b. Tasks
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;
Proposing and designing changes to a physical data model to resolve identifiable problems;
Developing procedural 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;
Monitoring deployed ETL/ELT jobs and debugging/troubleshooting any errors/issues encountered;
Amending ETL/ELT scripts to correctly handle exceptional aberrant records; and
Writing tests to verify the integrity of relations/objects within the data warehouse.
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.
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.
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.