Senior ETL Administrator - Reston, United States - TekStream Solutions

TekStream Solutions Reston, United States

3 weeks ago

Description

Sr. ETL Administrator

Department:
Technology Services

Location:
Remote/Reston, VA

Description

We are currently seeking an Application Administrator to work within a team that provides Data Warehouse and Business Intelligence services to our government customer using Agile scrum processes.

You will work with varying data sources with different schemas and data elements to ultimately produce an effective and efficient Data Warehouse.

You have an eye for spotting data correlations and a desire to dig into large datasets to find technical solutions and deliver business value.

This role will interact with officially designated product owners, system owners, and business owners of the source systems to understand transactional system data models and elicit requirements and logic for the ETLs.

As a senior admin, we seek an individual who is self-driven with the ability to adapt quickly, work independently in a challenging and fast paced environment within cross-functional teams, and to promote creative problem solving within their team as well.

Program Details
The program you will be supporting has a mission to provide development, security, and operations (DevSecOps) support to U.S.

Citizenship and Immigration Services (USCIS) with a focus on development, operations, and modernization of the agency's Enterprise Data Warehouse/Data Lake.

The team utilizes open-source, AWS Cloud, and Big Data technologies, Agile project management practices, and modern DevSecOps delivery to provide the business intelligence support systems to meet the reporting, data analytics, and machine learning/artificial intelligence needs critical to USCIS leadership, data/business analysts, data scientists, and other decision-makers.

Responsibilities:
Work with Information System Security Officers (ISSO) to mitigate and/or improve security posture
Troubleshoot data discrepancies and missing data issues resulting from daily ETL loads
Work with operations team to promote ETL code/jobs across all environments and debug /troubleshoot critical production issues
Implement procedures to maintain, monitor, backup and recover operations for ETL/BI environment
Report regularly on health and performance of ETL/BI environment and jobs
Conduct ETL/BI optimization, troubleshooting and debugging
Maintain ownership of release activities interacting with ETL/BI projects
Perform import and export ETL jobs across various ETL projects and servers
Establish projects, roles, users, privileges in different ETL/BI environments (DEV, QA, PROD)
Collaborate with various ETL/BI developers to implement solutions per requirements
Record and maintain ETL/BI software and operational procedures. Provide detailed analysis of problems and recommend solutions.
Conduct troubleshooting of production and ETL/BI job issues and mitigate performance issues.
Perform independently with little direct supervision in administration of ETL/BI application (Informatica IICS and Tableau)

Actively participate in Agile release and sprint planning, sprint grooming, artifact creation, sprint testing, demonstrations and retrospectives and solution releases.

Execute other activities related to development work, such as participate in meetings, provide briefings, presentations and other support materials that will promote the program, assist in achieving user buy-in, and explain technical concepts to non-technical audiences.

Perform and assume other duties and responsibilities as required at direction of management.

Required Skills :
5+ years of experience with ETL (Informatica/Power Center/IICS)
5+ years of experience in application administration on Linux environments
3+ years of experience with Tableau administration
3+ years of experience with supporting BI applications using relational databases and Data Lake
3+ years of experience in technical development and leadership roles on BI projects, including designing and developing with ETL Tools
3+ years of experience working in AWS Cloud environment
Experience with ETL/BI Process Management to include establishing boundaries of data processing, building system architecture for the data pipeline, drawing up technical documentation for system requirements, and participate in the determination and implementation off ETL/BI and testing tools
Experience with scripting languages e.g., Bash and UNIX
Experience with building automated ETL/BI pipelines using DevOps tools like Jenkins
Strong teamwork, communication, co-ordination, planning and leadership skills
Experience with GitHub and branching strategies
Experience with Microsoft Office Suite including Excel, PowerPoint, and Visio

Desired Skills:
Experience with Microsoft Office Suite including Excel, PowerPoint, and Visio
Knowledge of Agile, including Scrum and Kanban, and management tools (e.g., Jira, Confluence)
Knowledge of Scripting languages e.g., Python
Experience with Databricks/Apache Spark, AWS Data Migration Service (DMS), and/or Informatica PowerCenter and/or IICS
Experience with Postgres, Oracle, and Data Lake environments

Education:
Bachelor's degree in a technical discipline preferred – Computer Science, Mathematics, or equivalent technical degree, or the equivalent combination of education, professional training, and work experience

Location:
Reston, VA – Currently fully remote

Clearance:
Must be a US Citizen and be able to obtain a government agency Suitability Clearance. USCIS Entry on Duty (EOD) preferred

#J-18808-Ljbffr

Senior Data Scientist

3 weeks ago

Huntington Ingalls Industries Fairfax, United States Full time

Requisition Number: 18361 · Required Travel: 0 - 10% · Employment Type: Full Time/Salaried/Exempt · Security Clearance: TS/SCI · Level of Experience: Senior · This opportunity resides with Cyber & Electronic Warfare, a business group within HII's Mission Technologies division. ...
Business Objects Developer

3 weeks ago

OneZero Solutions Herndon, United States

We are an employee-centric company that truly appreciates our team members and their value to our customers and the missions they support. We pride ourselves on being forward-leaning thinkers and fostering teams that are and continue to be technically proficient and technically c ...
Sr. Ab Initio Administrator(Hybrid)

3 days ago

SmartIPlace Reston, United States

Job Description · Job DescriptionTitle: Sr. Ab Initio AdministratorInterview process: 1-2 rounds of video interviews · Visa: Only USC/GC · Location: Hybrid in Reston, VA once a week (Candidates must reside in DMV+WV area) · Duration: 12 months contract-to-hire · 8+ years of exper ...
Senior Ab Initio Developer

3 days ago

Abidi Solutions Reston, United States

Job Description · Job DescriptionJob Title: Senior Ab Initio Administrator · Location: Hybrid in Reston, VA once a week (Candidates must reside in DMV+WV area) · Duration: 12 months contract-to-hire · Candidate Status Requirement: USC/GC · Interview Process: MS Teams Project ...
Lead Data Engineer-Cloudera Administrator

3 weeks ago

Blue Cross and Blue Shield Association Reston, United States

Resp & Qualifications · PURPOSE: · This is a Big Data/Cloudera Administrator Lead position and not a developer position and need CDP7 experience. · The Lead Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise infrastructure targe ...
Data Engineer

1 day ago

Ageatia Global Solutions Reston, United States

PURPOSE: · This is a Big Data Administrator Lead position and not a developer position. · The Lead Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise infrastructure targeting big data and platform data management (e.g., data w ...
Lead Data Engineer-Cloudera Administrator

5 days ago

CareFirst BlueCross BlueShield Reston, United States

**Resp & Qualifications** · **PURPOSE:** · **This is a Big Data/Cloudera Administrator Lead position and not a developer position and need CDP7 experience.** · The Lead Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise infra ...
Telemetry and Data Pipeline Engineer

2 days ago

ScienceLogic Reston, United States

*This position can be remote within the US* · What were looking for · ScienceLogic is searching for a Python Engineer to develop and maintain critical ETL processes which run across data pipelines between our customer environments and our own cloud hosted data warehouse. · Wha ...
Big Data Administrator Lead

1 day ago

Ageatia Global Solutions Reston, United States

PURPOSE · This is a Big Data Administrator Lead position and not a developer position. · The Lead Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise · infrastructure targeting big data and platform data management (e.g., data ...
Tableau Developer with Security Clearance

3 weeks ago

Tallon Recruiting & Staffing Reston, United States

Job Highlights Obtain CI Poly Tableau Developer VA, Reston 22310 Security Clearance: U.S. Citizen, Current Security Clearance, TS/SCI, CI Polygraph Skills: Tableau, Business Intelligence, Business Analytics Tableau Developer · Reston, VA 20190 On-Site: This position requires Mon- ...
Software Engineer

4 days ago

Base2 Solutions Reston, United States

This position is responsible for working with DoD, IC, and Federal customers to develop, deploy and configure data centric Zero Trust solutions. These solutions should adhere to Zero Trust best-practices, reference frameworks, regulations, and guidelines. Position requires interf ...
Data Engineer

5 days ago

Draper Reston, United States

Overview · Draper is an independent, nonprofit research and development company headquartered in Cambridge, MA. The 2,000+ employees of Draper tackle important national challenges with a promise of delivering successful and usable solutions. From military defense and space explo ...
Full Stack Developer UI Angular

1 week ago

Acclaim Technical Services Reston, United States

Acclaim Technical Services, founded in 2000, is a leading language, operations, and technology services company supporting a wide range of U.S. Federal agencies. We are an Employee Stock Ownership Plan (ESOP) company, which is uncommon within our business sector. We see this as a ...
Data Engineer

2 days ago

Draper Labs Reston, United States

· Data Engineer · Job Location · US-MA-Cambridge | US-AL-Huntsville | US-VA-Reston | US-FL-St. Petersburg 16th St · Requisition ID · Overview · Draper is an independent, nonprofit research and development company headquartered in Cambridge, MA. The 2,000+ employees of Drape ...
Software Engineer

1 day ago

Base2 Solutions Reston, United States

This position is responsible for working with DoD, IC, and Federal customers to develop, deploy and configure data centric Zero Trust solutions. These solutions should adhere to Zero Trust best-practices, reference frameworks, regulations, and guidelines. Position requires interf ...
ETL/SQL Developer

3 weeks ago

Idea Entity Herndon, United States

Job Description · Job DescriptionIdea Entity, a Microsoft Gold Partner, is a global change management consulting firm committed to delivering customer outcomes that change the way business is done. We are looking for an experienced ETL/SQL Developer who will assume a key role on ...
Linux Engineer

1 week ago

Cornerstone Defense Herndon, United States

Location: Herndon, Virginia · Type: Contract · Job #3010 · Title: Linux Engineer · Location: Herndon, VA · *Clearance: *Active TS/SCI w/ Polygraph needed to apply * · Company Overview: · Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Sp ...
Systems Engineer

3 weeks ago

The Swift Group Herndon, United States

Job Description · Job DescriptionThe Swift Group is looking for a Systems Engineer to join an exciting mission oriented program. The role is located on onsite in Herndon, VA and requires a TS/SCI with Poly clearance. · This role is focused on the implementation process and IT ope ...
Business Objects Developer

3 weeks ago

Twenty Bridge Staffing Herndon, United States

Description · Our client is seeking a Business Objects Developer to join their team of qualified, diverse individuals. This position will be located in Herndon, VA, with some remote work possible. The qualified applicant will become part of the client's Department of State (DOS) ...
Business Objects Developer

2 weeks ago

Twenty Bridge Staffing Herndon, United States

Description · Our client is seeking a Business Objects Developer to join their team of qualified, diverse individuals. This position will be located in Herndon, VA, with some remote work possible. The qualified applicant will become part of the client's Department of State (DOS) ...