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 Python, Pandas, and Data Vault 2.0 methodology.
- The candidate must meet or exceed each of the following requirements:
- One or more years of data modeling or data warehouse architecture experience using the Data Vault 2.0 methodology;
- Two or more years of data modeling or data warehouse architecture experience using any Data Vault methodology;
- 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);
- Five or more years of experience developing procedural SQL development using the T-SQL dialect.
The below elements represent the type of work to be performed by candidates in this position:
- Proposing and designing changes to a physical data model to resolve and articulate problems;
- 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;
- 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;
- Monitoring deployed ETL/ELT jobs and debugging/troubleshooting any errors/issues encountered;
- Amending ETL/ELT scripts to correctly handle exceptional or aberrant records;
- 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:
- Experience (within the last year) developing schema in Azure, Python, and supplemented with expert level of Tableau visualization tools.
- Experience in dashboard development to support data-driven information-sharing and decision-making;
- Shall create dashboards from live data tables, not just data extracts;
- Shall develop both simple and complex data visualizations;
- Experience with performance optimization techniques, allowing for efficient data manipulation that does not slow dashboard function for the end user;
- Experience working collaboratively with data analysts and other end users to gather visualization and reporting needs and requirements;
- Familiarity with and adherence to basic design principles, including, but not limited to, meaningful use of color;
- Experience working with a data warehouse;
- Experience in database systems like SQL Server and PostgreSQL;
- Experience with data blending or joins to integrate data from multiple data sources;
- Experience manipulating and visualizing a variety of common data types including, but not limited to, numeric, string, date time, and geographic/geometric;
- Experience visualizing administrative records from multi-step business processes to reflect derived dimensions of interest to process owners, including, but not limited to, timeliness, efficiency, completeness, and effectiveness;
- Responsive and able to complete projects in a timely manner;
- Shall innovate while staying within any imposed agency constraints;
- Flexible to work well in an environment where things may change frequently or stall for periods of time;
- Diligent about documentation and knowledge transfer, to include production of clean files;
- Shall host relevant training on dashboards;
- 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
#J-18808-Ljbffr