ETL Developer Data Vault
Sylger Corporation
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 DescriptionSylger 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.
- E-logic is hiring a Modern ETL Developer to design, build, and deploy cloud-native data pipelines within our expanding cloud-based analytics ecosystem for the Office of Personnel Management (OPM), Office of Inspector General (OIG). This role will be hybrid in Washington...DataWork at officeFlexible hours
- Role: ETL Report Developer Location: Washington DC (Hybrid) Position Type: Contract Project Duration: Long Term Detailed JD Responsibilities Seeking... ...Design, automate and support sophisticated applications for data extraction, transformation, and loading. Data warehousing,...DataContract workWork experience placement
- Tech Mirrors in Washington DC is seeking an ETL Report Developer to contribute significantly to data management projects. The role involves building, testing, and deploying ETL components while ensuring data accuracy. The ideal candidate will have at least five years of...DataLong term contract
$77.14k - $89k
...include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics,... ...Application password: Niner 9th Way Insignia is seeking an ETL Developer to support a government customer in Washington, DC. The ETL...DataFull timeContract workLocal area$96.41k - $99k
...include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics,... ...password: Niner 9th Way Insignia is seeking a Senior ETL Developer to support a government customer in Washington, DC. The Senior...DataFull timeContract workLocal area- ...Consulting, LLC is seeking a full-time professional in Downtown Washington DC to support ETL generation and analytics for a Federal government agency. You will be responsible for report and data cube generation using Business Intelligence technologies. The ideal candidate has...DataFull timeContract work
- E Logic is hiring a Modern ETL Developer to design and deploy cloud-native data pipelines within their analytics ecosystem for the Office of Personnel Management. This hybrid role located in Washington DC offers the chance to transition legacy ETL processes into scalable...DataWork at office
- A leading technology firm is seeking a Senior Technical Lead to oversee data and document migration projects to the Veeva Vault RIM platform. This remote position requires deep technical expertise, strong leadership skills, and a thorough understanding of the life sciences...DataRemote job
$101.15k - $192k
LMI Government Consulting is seeking a Platform Engineer to help build and extend IronGate, an ETL solution focused on secure data movement. Candidates must be eligible for clearance and have a Bachelor's degree in Computer Science, with 7-10 years’ experience in platform...Data- An established industry player is seeking a seasoned Data Engineer with extensive experience in Azure Databricks and Pyspark. This role... ...ideal candidate will have a strong background in data engineering, ETL processes, and Agile methodologies. Join a dynamic team that...Data
- Veterans EZ Info Inc is seeking a Data Engineer for a 100% remote position on a large federal project. This role focuses on designing and... ...and analytics. The ideal candidate has strong experience with ETL processes and cloud-based platforms, particularly Azure. Responsibilities...DataRemote job
- CACI International Inc is seeking a Sr. Data Engineer in Arlington, Virginia. You will build and optimize data pipelines for ETL, integrate complex datasets, and develop scalable data warehousing solutions. The role requires a DoD Secret clearance, a BA/BS in Computer Science...DataFlexible hours
$69.4k - $158k
...JOURNEY Discover what to expect during your journey as a candidate with us. As a back-end developer, you know that a good site or system needs the right combination of ETL, data management, automation, clean code, APIs, analytics, and infrastructure to develop a user-focused...DataFull timeContract workPart timeLocal areaRemote work- ETL Developer with Cloud Technology Experience Acumen Solutions is a global cloud consultancy that is looking for a full‑time ETL Developer to support our data transformation and integration projects. Responsibilities Develop an in-depth understanding of the interrelationships...DataFull timeFor contractors
- ...needs. For more details please visit our website Job Description ETL Tech Lead 7+ years of current and hands‑on experience with... ...hands‑on experience in designing high performing ETLs in a complex Data Warehouse, Data Marts and Analytics Environments. 4+ years of current...DataPermanent employmentFull timeTemporary work
- A leading consulting firm in Arlington is seeking a Data Engineer to build, optimize, and maintain data pipelines and cloud solutions. You will work with cross-functional teams to deliver high-quality data solutions and ensure data integrity. Requirements include a Bachelor...Data
- Redhorse Corporation is seeking a skilled Data Engineer based in Arlington, Virginia, to transform data utilization within the Department of Defense. This role will enable significant advancements in data-driven decision-making impacting national security initiatives....Data
- SoTalent is looking for a Senior Data Engineer to join their Data Science division in McLean... ..., VA. You will play a pivotal role in developing cloud-based data architectures and... ...a technical field, with strong skills in ETL/ELT processes and container workflows. The...Data
- A leading consulting firm is seeking a Data Engineer at the Senior Analyst level in Arlington, Virginia. This hands-on role involves building and maintaining data pipelines and collaborating with senior engineers. Applicants should have at least 2 years of experience,...Data
- ArcGIS Developer ArcGIS Developer will provide support by maintaining and enhancing the ArcGIS... ..., which offers geospatial analysis, data management, and visualization capabilities... ...Python scripts for Extract, Transform, Load (ETL) processes. Configure and optimize...Data
- ...technical architect, API engineer, and full stack systems developer who thrives at the intersection of data systems, UI/UX dashboard design, and strategic insight... ..., SQL/NoSQL databases). Define data pipelines and ETL processes to support high performance dashboard...Data
$180k - $190k
...firms and continues to grow. We are actively hiring an ETL Developer with TS/SCI clearance and polygraph to support a program in... ...play a pivotal role in shaping, and implementing cutting-edge data flow solutions centered around Apache NiFi. The candidate will...DataContract workWork experience placement- ...applications including Oracle HCM Analytics ETL, Dashboard and Reports for the IPPS-A... ...SMEs and Testers using Agile sessions to develop high quality user-friendly IPPS-A Dashboard... ...HCM Apps and related ETL programs with new data sources, DFFs, and new DWH tables Strong knowledge...DataPermanent employment
$155k
...years of related experience as a Power BI Developer with an excellent track record... ...views to implement business intelligence and data warehousing solutions. Experience in extracting... ...and implements BI reporting solutions, ETL solutions using best practices and methodologies...Data$106.48k - $159.72k
...We are seeking a highly skilled Power BI Developer / Visualization Specialist to support a Federal... ...solutions. This role focuses heavily on data visualization, stakeholder engagement,... ..., and data models. Support ETL/ELT processes and data validation activities...DataTemporary workFlexible hours- ...evolving technology landscape, an organization’s data has never been a more important aspect in... .... At Steampunk you will design and develop solutions to high-impact, complex data problems... ...reliability. Assess and understand the ETL jobs, workflows, BI tools, and reports...Data
$118.74k - $150k
...include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics,... ...analytics. 9th Way Insignia is looking for a Expert ETL Developer to join this team. Professional Level Information An Engineer...DataWork at officeLocal area$80 - $95 per hour
...designing, building, and maintaining the data infrastructure that powers strategic decision... ...dashboards, reports, and ML features. Develop and maintain data marts , semantic layers,... ...Experience building and maintaining ELT/ETL pipelines using tools like Airflow, Prefect...DataHourly pay- ...largest sources of funding and knowledge for developing countries; a unique global partnership of... ...in groundbreaking projects and using data, research, and technology to develop solutions... ...with the Business Intelligence and ETL teams, consultants, and project managers...DataWork at officeWorldwideShift work
$103.8k - $218.1k
## Systems Data Engineering and IntegratorSuitland, MD, USApply NowFind out how well you... ...Design, engineer, test, and maintain automated ETL/ELT pipelines that transition data from... ...Automated Data Quality Gateways :** Develop code‐driven readiness gates that enforce strict...DataContract workWork experience placementLocal areaFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to ETL Developer Data Vault. Be the first to apply!
- tableau dashboard developer Washington DC
- kernel developer Washington DC
- statistical programmer Washington DC
- senior statistical programmer Washington DC
- informatica etl developer Washington DC
- developer contractor Washington DC
- seo developer Washington DC
- geospatial developer Washington DC
- postgresql developer Washington DC
- remote entry level developer Washington DC
