Data Engineer

Job Summary

Analytica is seeking an experienced ETL Data Engineer to design, build, optimize, and support scalable data pipelines using Informatica and AWS. You will collaborate 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 individuals who enjoy solving data integration challenges, improving performance and reliability, and contributing to modern cloud-based data platforms.

This is a remote opportunity.

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

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 adhere to 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 independently troubleshoot pipeline failures and performance bottlenecks.
• 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 3 and is an ISO 9001:2008 certified provider.