Senior ETL Administrator

3 weeks ago

Reston, United States TekStream Solutions Full time

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

  • Senior ETL Administrator

    1 month ago

    Reston, United States TekStream Solutions Full time

    Sr. ETL AdministratorDepartment:Technology ServicesLocation:Remote/Reston, VADescriptionWe 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...

  • Senior ETL Administrator

    3 weeks ago

    Reston, United States TekStream Solutions Full time

    Sr. ETL AdministratorDepartment:Technology ServicesLocation:Remote/Reston, VADescriptionWe 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...

  • Senior Ab Initio Developer

    2 weeks ago

    Reston, United States Abidi Solutions Full time

    Job DescriptionJob 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 Summary Sr. Ab Initio Administrator to support the implementation of a Data Integration/Data...

  • Senior Ab Initio Developer

    1 week ago

    Reston, United States Abidi Solutions Full time

    Job DescriptionJob 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 Summary Sr. Ab Initio Administrator to support the implementation of a Data Integration/Data...

  • Senior Database Administrator

    4 days ago

    Reston, United States NVR Full time

    NVR, Inc. is seeking a Senior Database Administrator to work on site in Reston, VA NVR's technology teams thrive on providing multiple business lines with the tools and cutting-edge technologies that support NVR's mission to create a better living experience for our customers. Join NVR Technology and be a part of a collaborative team that welcomes...

  • Data Engineer

    4 weeks ago

    Reston, United States NS2 Mission Full time

    Job DescriptionJob DescriptionAre you interested in working in a dynamic environment that offers opportunities for professional growth and new responsibilities by helping clients drive alignment with their business, advising through critical and complex issues, while allowing you to develop personally and professionally? Then consider a career at NS2...

  • Data Engineer

    1 month ago

    Reston, United States NS2 Mission Full time

    Job DescriptionJob DescriptionAre you interested in working in a dynamic environment that offers opportunities for professional growth and new responsibilities by helping clients drive alignment with their business, advising through critical and complex issues, while allowing you to develop personally and professionally? Then consider a career at NS2...

  • Data Engineer

    3 weeks ago

    Reston, United States NS2 Mission Full time

    Job DescriptionJob DescriptionAre you interested in working in a dynamic environment that offers opportunities for professional growth and new responsibilities by helping clients drive alignment with their business, advising through critical and complex issues, while allowing you to develop personally and professionally? Then consider a career at NS2...

  • Aderant Senior Application Administrator

    3 weeks ago

    Reston, United States GCB Services LLC Full time

    Job DescriptionJob DescriptionJob Description:Our firm is currently seeking an Aderant Senior Application Administrator with a focus in Finance Systems but with general knowledge of the Aderant Technology Suite as a whole. This position is an integral part of the firm-wide Information Technology team and is responsible for the administration, maintenance and...

  • Data Engineer ETL

    1 week ago

    Reston, United States NS2 Mission Full time

    Job Description Job Description Are you interested in working in a dynamic environment that offers opportunities for professional growth and new responsibilities by helping clients drive alignment with their business, advising through critical and complex issues, while allowing you to develop personally and professionally? Then consider a career at NS2...

  • Senior Software Developer

    1 month ago

    Reston, United States Evolver Commercial Full time

    Job DescriptionJob DescriptionEvolver LLC (Reston, VA) seeks Senior Software Developer - SQL to develop ETL processes with SQL integration Services. Req. Bachelor's in Computer Science, Software Engineering, Computer Engineering, Computer Information Systems, Information Technology or related field, plus 5 years' of experience to include: development...

  • ETL Full Stack Developer

    1 week ago

    Reston, United States Booz Allen Hamilton Full time

    ETL Full Stack Developer The Opportunity: As a full stack developer, you can resolve a problem with a complete end-to-end solution in a fast, agile environment. If you're looking for the chance to not just develop software, but to create a system that will make a difference, we need you on our team. We're looking for an experienced developer like you with...

  • ETL Full Stack Developer

    7 days ago

    Reston, United States Booz Allen Hamilton Full time

    Job Number: R0199687 ETL Full Stack Developer The Opportunity: As a full stack developer, you can resolve a problem with a complete end-to-end solution in a fast, agile environment. If you're looking for the chance to not just develop software, but to create a system that will make a difference, we need you on our team. We're looking for an experienced...

  • Sr. Ab Initio Administrator(Hybrid)

    2 weeks ago

    Reston, United States SmartIPlace Full time

    Job DescriptionJob DescriptionTitle: Sr. Ab Initio AdministratorInterview process: 1-2 rounds of video interviewsVisa: Only USC/GCLocation: Hybrid in Reston, VA once a week (Candidates must reside in DMV+WV area)Duration: 12 months contract-to-hire8+ years of experience in ETL administration3+ years of recent ETL administration using Ab InitioStrong...

  • Senior Contracts Administrator

    3 weeks ago

    Reston, United States ASRC Federal Full time

    Job Description ASRC Federal is currently seeking a  Senior Contracts Administrator  to join our team. This is a full time remote position. Key Role:   Responsible for all aspects of the contract administration life cycle from “cradle to grave” including, but not limited to, supporting Business Development and Program Managers in...

  • Senior Systems Administrator

    2 days ago

    Reston, United States ICF Incorporated, LLC Full time

    Computer/IT: ICF Incorporated, LLC: Senior Systems Administrator - Reston VA. Implement enhancements & roll out new features; execute solution design activities such as data model, object modeling, page layout design, & rule logic definition in the context of the Salesforce application. Req's Bachelor's in Comp Sci or rltd tech field + 5 yrs of progressively...

  • Senior Salesforce Developer

    2 months ago

    Reston, United States AVM Consulting Inc Full time

    Company DescriptionAVM Consulting is a global technology consultancy focusing on secure, observable cloud architectures and an Everything as Code (EAC) approach. We provide strategy, design, implementation, and support for data intensive cloud applications supported by RDBMS and NoSQL solutions. Our expertise also includes CI/CD using DevOps and DevSecOps...

  • Senior Salesforce Developer

    1 month ago

    Reston, United States AVM Consulting Inc Full time

    Company DescriptionAVM Consulting is a global technology consultancy focusing on secure, observable cloud architectures and an Everything as Code (EAC) approach. We provide strategy, design, implementation, and support for data intensive cloud applications supported by RDBMS and NoSQL solutions. Our expertise also includes CI/CD using DevOps and DevSecOps...

  • Senior Systems Administrator

    21 hours ago

    Reston, Virginia, United States ICF Incorporated, LLC Full time

    Computer/IT: ICF Incorporated,LLC:Senior Systems Administrator Reston VA. Implement enhancements & roll out new features; execute solution design activities such as data model, object modeling, page layout design, & rule logic definition in the context of the Salesforce application. Req's Bachelor's in Comp Sci or rltd tech field + 5 yrs of progressively...

  • Linux/UNIX Systems Administrator

    1 month ago

    Reston, United States SilverEdge Full time

    Required Skills Overview The Systems Administrator will be responsible for data extraction, transformation and load (ETL), data mapping, data extraction, analytical support, operational support, database support, application development and associated maintenance of production systems. This is a fast-paced, dynamic team in a process oriented environment....