Data Engineer

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., * 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, To enhance efficiency, fairness, and accuracy, Analytica may use AI-assisted tools to support certain aspects of our hiring process.

• Application Review: AI tools may help identify skills and experiences relevant to the role.

• Interview Support: AI-powered notetaking tools may be used during interviews to document discussions and summarize key points.

These tools are used to assist our team. All hiring decisions are made by Analytica recruiters and hiring managers., Voluntary Self-Identification of Disability Form CC-305 OMB Control Number 1250-0005 Expires 04/30/2026 Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp. How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your "major life activities." If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

• Alcohol or other substance use disorder (not currently using drugs illegally)
• Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
• Blind or low vision
• Cancer (past or present)

• 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

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., Target Salary* What level of government security clearance do you hold? If applicable, please list any Federal agencies you currently hold a clearance for? LinkedIn Profile Where did you hear about Analytica?* Do you acknowledge and agree that your application may be reviewed by AI-assisted tools, and that interviews may be recorded or summarized using AI notetakers?* Yes, I acknowledge and agreeNo, I do not agree The following questions are entirely optional. To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more. Gender Race/Ethnicity, Invitation for Job Applicants to Self-Identify as a U.S. Veteran

• A "disabled veteran" is one of the following:

• a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
• a person who was discharged or released from active duty because of a service-connected disability.

• A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
• An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
• An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

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., When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.