Data Engineer Job at Analytica, Washington DC

STZCN080MmRXUlE2UVlPclVydUxBaTFpUHc9PQ==
  • Analytica
  • Washington DC

Job Description

Analytica is  looking for an experienced ETL Data Engineer to design, build, optimize, and support scalable data pipelines using Informatica and AWS. You’ll work closely with data architects, analysts, and business stakeholders to ensure reliable, secure, and high-quality data delivery across enterprise systems. 

This role is ideal for someone who enjoys solving data integration challenges, improving performance and reliability, and contributing to modern cloud-based data platforms. 

Analytica has been recognized by Inc. for 3 consecutive years as one of the 250 fastest growing business.  We offer competitive compensation with opportunities for bonuses, employer paid health care, training and development funds, and 401k match.  

Key Responsibilities:

  • Design, develop, and maintain ETL workflows using Informatica (PowerCenter and/or IICS) 

  • Build and optimize cloud-based data pipelines and integrations on AWS 

  • Develop and support ingestion, transformation, and loading processes from multiple source systems (SQL, APIs, flat files, etc.) 

  • Implement and maintain data quality, validation, and reconciliation checks 

  • Manage scheduling, dependencies, and monitoring of ETL jobs; troubleshoot failures and performance issues 

  • Collaborate with data architects to implement target models in data lakes/warehouses 

  • Ensure pipelines follow security, governance, and compliance standards 

  • Contribute to best practices for CI/CD, version control, environment promotion, and deployment automation 

  • Document ETL design, mappings, lineage, and operational processes 

  • Participate in on-call or production support rotations as needed 

Required Qualifications:

  • 7+ years of hands-on ETL/data engineering experience 

  • Strong experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS) 

  • Experience building data solutions in AWS, including services such as:  

  • S3, IAM, CloudWatch 

  • Glue, Lambda, Step Functions 

  • Redshift, RDS, or Aurora 

  • Strong SQL skills (query optimization, joins, windowing, performance tuning) 

  • Python scripting for automation or integration support 

  • Experience with data warehouse concepts and dimensional modeling 

  • Familiarity with SDLC practices and version control tools (Git, Bitbucket, etc.) 

  • Ability to troubleshoot pipeline failures and performance bottlenecks independently 

  • Strong communication skills and comfort working cross-functionally 

Preferred Qualifications (Nice to Have):

  • Experience with Informatica Cloud connectors and Cloud Data Integration patterns 

  • Exposure to Databricks or modern lakehouse platforms 

  • CI/CD pipeline experience (Jenkins, GitHub Actions, Azure DevOps, etc.) 

  • Experience with metadata management, lineage, and governance tools 

  • Familiarity with Agile/Scrum methodologies 

About  ANALYTICA : Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD, the company is an established  SBA small business that has been recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growing companies in the U.S.  Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at  CMMI® Maturity Level 3and is an  ISO 9001:2008 certified provider. 

Analytica LLC is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other characteristic protected by applicable federal, state, or local law. As a federal contractor, we comply with the Vietnam Era Veterans' Readjustment Assistance Act (VEVRAA) and take affirmative action to employ and advance in employment qualified protected veterans.

We ensure that all employment decisions are based on merit, qualifications, and business needs. We prohibit discrimination and harassment of any kind. Analytica LLC also provides reasonable accommodations to applicants and employees with disabilities, in accordance with applicable laws

When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.

Job Tags

Full time, For contractors, Local area,

Similar Jobs

Wolfson Children's Hospital

Manager, The Women's Board of Wolfson Children's Hospital, Baptist Health System Foundation Job at Wolfson Children's Hospital

Job SummaryThe Womens Board of Wolfson Childrens Hospitalis seeking a dedicated and skilled individual to fill the role of Manager...  ...collaboration with the staff of Wolfson Childrens Hospital and Baptist Foundation. The Womens Board staff must function as a... 

Orangetheory Fitness

Fitness Coach Job at Orangetheory Fitness

 ...company. Preferred certifications: NSCA, ACE, PTA Global Certified Trainer, ACSM, AFAA, CI, and NASM. Must hold and maintain a current CPR certification. Must have completed and passed the 4 days or single hire" OT Fit Certification Process. Other Skills, Abilities... 

People Architects

Tax Accountant CPA Job at People Architects

Tax Accountant CPA Location Lakeland, FL (Francis Blvd area) : People Architects has partnered with a well-established tax and advisory practice located in Lakeland Florida Our client's size and collaborative environment promise the interaction with all levels of the... 

FlightSafety International

Lead Data Engineer Job at FlightSafety International

 ...Centers and training locations in the United States, Canada, France and the United Kingdom. Purpose of Position The Lead Data Engineer is a hands-on technical leader responsible for architecting, developing, and guiding the implementation of modern data solutions... 

The State of Kansas

Storekeeper Job at The State of Kansas

 ...government conditions of participation. About the Position: The Storekeeper monitors the stockroom, lined room, warehouse, and clothing store. They receive and examine deliveries and verify receipt of items. They establish, modify, and maintain receiving, stocking,...