Data Engineer

Data Ideology

At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly motivated individuals passionate about learning, understanding, collaborating, and intellectually curious. For more information about Data Ideology, visit www.dataideology.com

Data Engineer

We are seeking a hands-on Data Engineer to join our Quality Engineering team. This role is focused on building, maintaining, and optimizing production ETL pipelines and SQL-based data transformations. The ideal candidate has deep, practical ETL experience, strong SQL skills, and can work productively in existing Informatica and Snowflake environments with minimal ramp-up.
This is a delivery-focused role for someone who enjoys working directly in pipelines, troubleshooting issues, and supporting data workflows in production

Key Responsibilities

To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Other duties may be assigned to meet business needs.

• Develop, maintain, and enhance production ETL pipelines using Informatica (PowerCenter and/or IICS)
• Write, optimize, and troubleshoot complex SQL used for transformations, validations, and analytics
• Support and enhance data pipelines loading into Snowflake
• Debug failed ETL jobs, data discrepancies, and performance issues across ETL and warehouse layers
• Collaborate with business and technical stakeholders to understand data requirements and translate them into working solutions
• Support data warehouse environments across cloud and hybrid architectures
• Maintain technical documentation, mappings, and workflow logic
• Participate in SDLC processes including deployments, testing, and version control

Supervisory Responsibilities: None

Qualifications

Education and Experience:

• 5+ years of hands-on experience building and supporting ETL pipelines in production
• Strong SQL skills, including complex joins, subqueries, aggregations, and performance tuning
• Hands-on experience with Informatica PowerCenter and/or Informatica IICS
• Experience working with cloud data warehouses, including Snowflake
• Ability to independently troubleshoot ETL failures, data issues, and query performance problems
• Experience working within SDLC frameworks and version control systems
• Strong communication skills and ability to explain technical work clearly
• Important: This role requires hands-on work in existing Informatica and Snowflake environments. Candidates must be able to contribute quickly without extensive training.

Nice to Have

• Azure Data Factory (ADF)
• Healthcare data experience
• Experience supporting migrations from legacy data platforms

Work Environment:

• Remote-first role with a limited hybrid requirement. Candidates must be able to attend occasional in-person meetings or client sessions as needed (approximately once per quarter). Minimal travel required.
• Hours of work and days are generally Monday through Friday. Specific business hours will depend on client needs.

Physical Demands:

• Must be able to remain in a stationary position 50% of the time.
• The person in this position must occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc.
• Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer.
• The person in this position frequently communicates with clients and coworkers. Must be able to exchange accurate information in these situations.

Benefits:

• PTO Policy
• Eligibility for Health Benefits
• Retirement Plan
• Work from Home

Data Ideology is an EEO Employer

es1ZbGOGxD