Current jobs related to Sr. ETL Administrator - McLean - Metric5

  • ETL Engineer, Senior

    3 weeks ago

    McLean, United States Booz Allen Hamilton Full time

    ETL Engineer, Senior The Opportunity: Ever-expanding technology like IoT, machine learning, and artificial intelligence means that there's more structured and unstructured data available today than ever before. As a data engineer, you know that organizing big data can yield pivotal insights when it's gathered from disparate sources. We need an experienced...

  • Sr. Data Science Analyst

    4 weeks ago

    McLean, United States BLN24 Full time

    Job DescriptionJob DescriptionBLN24 is an award-winning digital creative agency that supports the U.S. Federal Government in successfully achieving their mission and goals. Our service and solutions delivery start with understanding each client’s end-state, and then seamlessly integrating within each Agency’s organization to improve and enhance...

  • Senior Database Administrator

    2 weeks ago

    McLean, United States NuvoLogic Consulting Full time

    Job DescriptionJob DescriptionNuvoLogic Consulting is a management consulting company in the Northern Virginia area. We engage with public and private sector clients with a primary focus on financial services and mortgage finance. We help our clients in the areas of finance, accounting and operations to support CFO, budget, audit readiness, and risk...

  • Senior Database Administrator

    2 weeks ago

    McLean, United States NuvoLogic Consulting Full time

    Job DescriptionJob DescriptionNuvoLogic Consulting is a management consulting company in the Northern Virginia area. We engage with public and private sector clients with a primary focus on financial services and mortgage finance. We help our clients in the areas of finance, accounting and operations to support CFO, budget, audit readiness, and risk...

  • ETL Engineer, Senior

    2 months ago

    McLean, United States Booz Allen Hamilton Full time

    ETL Engineer, SeniorThe Opportunity:Ever-expanding technology like IoT, machine learning, and artificial intelligence means that there’s more structured and unstructured data available today than ever before. As a data engineer, you know that organizing big data can yield pivotal insights when it’s gathered from disparate sources. We need an experienced...

  • Senior Database Administrator

    2 weeks ago

    McLean, Virginia, United States NuvoLogic Consulting Full time

    Job Description:NuvoLogic Consulting, a management consulting company in the Northern Virginia area, is seeking a Senior Database Administrator to support the Small Business Administration's (SBA) Office of Disaster Recovery & Resilience (ODR&R).This role is crucial in managing and optimizing the database systems that underpin the advanced data analytics...

  • Sr. ServiceNow SAM Developer

    3 weeks ago

    McLean, United States Diverse Lynx Full time

    Job Title: Sr. ServiceNow SAM Developer Location: Mclean VA; Plano TX Experience: 8+ Year Duration: 12+ Months Must Have Experience •Experienced in implementation of SAM solution using industry best practices. •Hands-on development and configuration of ServiceNow SAM Pro module. •3rd party software integrations with ServiceNow •Design and...

  • Experienced Sr. Financial Analyst

    2 weeks ago

    McLean, United States Capital One Full time

    Center 2 (19050), United States of America, McLean, Virginia Experienced Sr. Financial Analyst As a Financial Analyst, you will have the opportunity to partner with business customers on driving strategic business direction that leads to sustainable performance. You will work for a company that invests in ways to tell stories, view trends, and diagnose...

  • Experienced Sr. Financial Analyst

    1 month ago

    McLean, United States Capital One Financial Corp Full time

    Experienced Sr. Financial Analyst As a Financial Analyst, you will have the opportunity to partner with business customers on driving strategic business direction that leads to sustainable performance. You will work for a company that invests in ways to tell stories, view trends, and diagnose results in a more compelling and visual nature. We are seeking...

  • Project Manager

    2 months ago

    McLean, United States Eliassen Group Full time

    We are seeking a highly motivated and detail-oriented Project Manager / Administrator to join our team. This role involves working closely with technology partners and end users/customers to ensure seamless project execution. The ideal candidate will have a solid technical background, a keen interest in learning, and the ability to thrive in a dynamic and...

  • Senior Database Architect

    2 weeks ago

    McLean, Virginia, United States NuvoLogic Consulting Full time

    Job Description:NuvoLogic Consulting is a management consulting firm that provides expert services to public and private sector clients in the financial services and mortgage finance industries. We are seeking a highly skilled Senior Database Administrator to join our team and support the Small Business Administration's (SBA) Office of Disaster Recovery &...

  • Sr Resident Care Director RN

    4 months ago

    McLean, United States Sunrise Senior Living Full time

    Overview"Sunrise is the best place that I've ever worked, simply because of the people. We provide quality care in an environment that feels like home. Our focus is doing what’s right for the resident. For me, that’s a big breath of fresh air."- Sunrise Leader  At Sunrise, our Senior Resident Care Director (Sr. RCD) is responsible for providing overall...

  • Sr. Quantitative Financial Analyst

    1 month ago

    McLean, United States National Black MBA Association Full time

    Job Description: At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities, and shareholders every day. One of the keys to driving Responsible Growth is being a great place to work for...

  • Systems Engineer

    2 months ago

    McLean, United States LMI Consulting, LLC Full time

    Systems Engineer - TS/SCI with Polygraph Required Job Locations US-VA-McLean Job ID 2022-9142 # of Openings 2 Category Engineering Overview LMI is looking for an expert Systems Engineer to support a client in the northern Virginia area. The client requires expertise specializing in software...

  • Database Systems Engineer

    2 weeks ago

    McLean, Virginia, United States NuvoLogic Consulting Full time

    Job Description:NuvoLogic Consulting, a leading management consulting firm in the Northern Virginia area, is seeking a highly skilled Senior Database Administrator to join our team.About the Role:We are looking for a seasoned database professional to support the Small Business Administration's (SBA) Office of Disaster Recovery & Resilience (ODR&R). As a...

  • Experienced Sr. Financial Analyst

    1 month ago

    McLean, United States Capital One Financial Corp Full time

    Center 2 (19050), United States of America, McLean, Virginia Experienced Sr. Financial Analyst As a Financial Analyst, you will have the opportunity to partner with business customers on driving strategic business direction that leads to sustainable performance. You will work for a company that invests in ways to tell stories, view trends, and diagnose...

  • Sr. Product Manager, Enterprise Identity

    2 weeks ago

    McLean, United States Workday Full time

    Your work days are brighter here.At Workday, it all began with a conversation over breakfast. When our founders met at a sunny California diner, they came up with an idea to revolutionize the enterprise software market. And when we began to rise, one thing that really set us apart was our culture. A culture which was driven by our value of putting our people...

  • Cloud Engineer

    5 months 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. SAS Engineer

    1 month ago

    McLean, United States Metric5 Full time

    Job DescriptionJob DescriptionSkills and RequirementsMetric5 is seeking a Senior SAS Engineer to join our growing team. As a SAS subject matterexpert, you possess extensive expertise in SAS software and will lead the management of existingplatforms while planning and implementing the upgrade to SAS Viya 4. You will facilitate the migrationof users and...

  • DIR, DINING SERVICES SR II

    3 weeks ago

    McLean, United States Compass Group Careers Full time

    Job DescriptionJob Description Flik Hospitality Group Salary: Other Forms of Compensation:What makes FLIK clickWhat makes FLIK click? Our people. The decisions, actions and attitudes of our associates earn the trust and loyalty of our clients every day. We know how to pick them and we know how to grow them. It starts with hiring people who share our passion...

Sr. ETL Administrator

4 months 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