Sr. ETL Administrator

2 weeks ago

McLean, United States Metric5 Full time
Job DescriptionJob Description

Description

Metric 5 is 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

  • Sr. Systems Administrator

    7 days ago

    McLean, United States NewGen Technologies (Maryland) Full time

    NewGen is seeking a Sr. Systems Administrator with the following skills and an active TS/SCI with polygraph. Required Technologies/Tools Experience with Linux platform support such as RHEL, or CentOS Linux platform administrative support, including management and troubleshooting Experience with Microsoft platform support and administrative support, including...

  • Sr. Systems Administrator

    2 weeks ago

    McLean, United States NewGen Technologies (Maryland) Full time

    NewGen is seeking a Sr. Systems Administrator with the following skills and an active TS/SCI with polygraph.Required Technologies/Tools Experience with Linux platform support such as RHEL, or CentOS Linux platform administrative support, including management and troubleshooting Experience with Microsoft platform support and administrative support, including...

  • Sr. Subcontracts Administrator

    4 days ago

    McLean, United States Aston Carter Full time

    Sr. Subcontracts Administrator | Remote with Restrictions to VA, MD and DC | $110 - $150k/yr Description: Provide subcontract administration support, including pre-and post-award subcontract administration within an internal subcontracts team, and maintain responsibility for soliciting and administering subcontracts, modifications, and task and delivery...

  • Excellent Opportunity

    2 weeks ago

    Mclean, United States SR Partners LLC Full time

    Position: Middleware Administrator With IBM MQ Location: McLean, VA (Onsite 5 days) Shift: 24/7 - Rotational Shift Duration: Long Term Contract Job Description: Middleware Apps SME to define, build and support the architecture and tools used by customer application development teams, to provide architecture support, standards, production control and...

  • Aws Redshift Database Administrator

    2 days ago

    McLean, United States NTT DATA Full time

    **Company Overview**: **Req ID**: 280762 We are currently seeking a AWS Redshift Database Administrator (Remote) to join our team in United States (US). This position may require on-call availability and might require working during non-business hours and on weekends in case of emergencies or planned maintenance. **Responsibilities and...

  • Sr. Systems Administrator

    2 months ago

    West McLean, United States The Maven Group, LLC Full time

    Job DescriptionJob DescriptionPosition Title: Sr. Systems Administrator Position Type: Direct Hire - TS/SCI w/ FSPPosition Location: Tysons Corner, VAResponsibilities: Provide system administration expertise for a specialized user environment, managing Windows workstations, servers, Linux servers, file shares, and hypervisors.Offer guidance and support for...

  • AWS Redshift Database Administrator

    4 days ago

    McLean, United States NTT DATA Full time

    Req ID: 280762 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a AWS Redshift Database Administrator (Remote) to join our team inUnited States (US). The AWS Redshift Database...

  • AWS Redshift Database Administrator

    4 days ago

    McLean, United States NTT DATA Full time

    Req ID: 280762 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a AWS Redshift Database Administrator (Remote) to join our team in United States (US). The AWS Redshift...

  • IA Engineer SR

    2 weeks ago

    McLean, United States ABBTECH Professional Resources Full time

    IA Engineer SR Location- Mclean, Va Clearance- TS/SCI w/ CI Poly Salary- 185k- 195k/yr The above salary range represents the range expected for the position; however, final salary offers are based on a number of factors such as the position’s responsibilities; the candidate’s experience, education, and skills; location; travel required; and current...

  • AWS Redshift Database Administrator

    3 days ago

    Mclean, United States NTT DATA Services Full time

    Req ID: 280762  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a AWS Redshift Database Administrator (Remote) to join our team in United States...

  • Office Administrator

    2 weeks ago

    McLean, United States Ames & Gough Full time

    Company DescriptionAmes & Gough is an industry-focused specialty insurance brokerage founded in 1992. With offices in McLean, VA, Boston, Orlando, FL, Philadelphia, PA, and Washington, D.C., we serve clients domiciled in 50 states and consult on risk and insurance issues globally. Our CLIENT FIRST philosophy is built on industry expertise, service by senior...

  • Sr IA Engineer

    2 days ago

    West McLean, United States California Creative Solutions Inc. Full time

    Job DescriptionJob DescriptionJob Title: Sr. IA Engineer McLean, VATelos Active TS/SCI w/CI Poly.Required Skills: 5+ years of relevant IT Security/Computer Science/Information Security Experience required.Must have 3 years (total aggregate) IA/Cybersecurity/Risk Management Framework as primary focus.Experience deploying systems to cloud infrastructures...

  • Systems Engineer SR Advisor

    3 days ago

    McLean, United States General Dynamics Information Technology Full time

    Job Description General Dynamics Information Technology, a world leader in Defense IT Systems Integration and Services is seeking a Systems Engineer SR Advisor to join its Air Force (AF) Distributed Common Ground System (DCGS) Enterprise Product Support (EPS) team to provide modernization, integration and sustainment engineering, sustainment planning,...

  • Sr. Accounts Payable Specialist

    4 days ago

    McLean, United States Validity BriteVerify Email Verification Full time

    About the Role Validity is seeking an experienced and highly motivated professional to serve as its Sr. Accounts Payable Specialist. Reporting to the Sr. Manager - Accounting Operations, the Sr. Accounts Payable Specialist will play a key role in ensuring that all of the Company’s invoices have been reviewed, processed and paid in accordance with company...

  • Project/Task Sr Manager

    4 weeks ago

    McLean, United States GCI Full time

    GCI, embodies excellence, integrity and professionalism. The employees supporting our customers deliver unique, high-value mission solutions while effectively leverage the technological expertise of our valued workforce to meet critical mission requirements in the areas of Data Analytics and Software Development, Engineering, Targeting and Analysis,...

  • Sr. Linux Engineer

    4 days ago

    McLean, United States Navstar Full time

    Sr. Linux Engineer The Linux Administrator will provide systems administration for RedHat Enterprise Linux (RHEL) and Solaris systems. Although maintenance is the primary focus, Navstar seeks a candidate who can automate the maintenance as much as possible in preparation for implementation of DevSecOps and a migration to the AWS Cloud.Role Responsibilities:...

  • Azure Data Engineer III

    3 days ago

    McLean, United States Ampcus Incorporated Full time

    Job Title- Azure Data Engineer III with heavy SQL & ETL Location- Vienna, VA or Pensacola, FL (fully onsite work, Candidate must be on site 5 days per week. Prefer Pensacola, FL, but open to Vienna, VA) Duration- 06 Months with possibility of extension Description: *FT Onsite* - Employee Powered Member Centric - Journeys Member Centric - Mission Data Member...

  • Cloud Developer

    2 weeks ago

    McLean, United States Janus Soft Inc Full time

    required skills and demonstrated experience Demonstrated experience with Python, Bash, and Terraform. Demonstrated experience Anaconda for development purposes. Demonstrated experience building and maintaining CI/CD pipelines with software such as source control (Git/GitHub), continuous build/delivery (Jenkins), issue management (Jira), and...

  • Cloud Engineer

    1 month ago

    McLean, United States Avolinq, LLC Full time

    Job DescriptionJob DescriptionOur client is seeking a Cloud Engineer (TS/SCI w/ Poly) to support a federal agency in Mclean, VA.Job DescriptionCandidate MUST possess a TS/SCI clearance with Intel PolygraphREQUIRED SKILLS AND DEMONSTRATED EXPERIENCEDemonstrated experience with Python, Bash, and Terraform.Demonstrated experience Anaconda for development...

  • Sr. Product Marketing Manager

    2 days ago

    McLean, United States Validity BriteVerify Email Verification Full time

    About the Role The Sr. Product Marketing Manager’s (SPMM) mission is to maximize revenue and product line growth through deep market analysis, wholistic go-to-market strategy, precise product positioning, and compelling pricing and packaging. As an SPMM, you will conduct, analyze, and generate customer insights from qualitative and quantitative market...