Data Engineer

Analytica is looking for an experienced ETL Data Engineer to design buildoptimize and support scalable data pipelines using Informatica and 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.

This role is a remote opportunity.

Analytica has been recognized by 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 andoptimizecloud-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 andmaintaindata 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 communicationskills and comfort working cross-functionally

Preferred Qualifications (Nice to Have) :

Experience with Informatica Cloud connectors and Cloud Data Integration patterns

Exposure to Databricks or modernlakehouseplatforms

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 businessthat hasbeen recognized byInc. Magazineeach of the past three years as one of the 250 fastest-growingcompanies in theU.S. Analytica specializes in providing software and systems engineering information management analytics & visualization agile project management and management consulting companyis appraised by theSoftware Engineering Institute (SEI) at CMMI Maturity Level 3and is an ISO 9001 : 2008 certifiedprovider.

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 to verify its authenticity.

Required Experience :

Senior IC

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Employment Type : Full-Time

Experience : years

Vacancy : 1