Data Engineer

Role Overview

• Guide an agile development team through the full project lifecycle.
• Designing and implementing data acquisition pipelines from a variety of data sources and technologies for multiple analytic and reporting use cases.
• Developing complex SQL scripts (including Snowflake SQL) to transform source data into a dimensional model, and creating views and materialized views in relational databases (e.g., Oracle).
• Developing automated ETL/ELT processes using Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS) to pull data from external sources and transform it into a dimensional model.
• Collaborating with other members of the Data Engineering team on the design, implementation, and optimization of data models and data flows.
• Verifying and validating SQL scripts, Informatica automation, database views, and related integration components.
• Designing and developing automated verification and validation processes to ensure data quality and integrity.
• Participating fully in agile ceremonies (e.g., sprint planning, daily stand-ups, backlog refinement, sprint reviews, and retrospectives).
• Working closely with architects and other engineering team members on implementation designs, data acquisition strategies, and technical solution patterns.
• Developing prototypes and mockups and working directly with business and technical stakeholders to validate requirements and solution approaches.
• Collaborating with team members to investigate, troubleshoot, and resolve technical issues in a timely manner.
• Assisting with the implementation, configuration, and optimization of development tools and environments (e.g., code repositories, CI/CD pipelines, work management tools).
• Producing and maintaining technical specifications, diagrams, data models, process flows, and other documentation required to support DD&I efforts.
• Participating in requirements and design sessions with stakeholders to ensure technical solutions meet business needs.
• Interpreting new and evolving business requirements, assessing their impact on the existing data integration hub, and proposing enhancements and changes to meet these requirements.

Requirements

• 8+ years of experience developing mappings and workflows to automate ETL processes using Informatica PowerCenter and/or Informatica IICS
• 8+ years of experience acquiring and integrating data from multiple data sources/technologies (Oracle, SQL Server, Excel, Access, Adobe PDF, etc.) using Informatica PowerCenter or IICS for consumption by data visualization tools (e.g., Tableau)
• 8+ years of experience designing and developing complex, high‑performance Snowflake SQL scripts
• 8+ years of experience as a systems analyst supporting data analytics, performance management, or data warehousing initiatives
• 8+ years of experience with technical writing and diagramming, including proficiency with tools such as Microsoft Visio, Erwin, and the Microsoft Office Suite (Word, Excel, PowerPoint) and MS Project
• 8+ years of experience planning and delivering software platforms used across multiple products and organizational units
• Proven ability to write well‑designed, testable, and efficient code using industry best practices
• Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.

Tech Stack

• Cloud
• ETL
• Informatica
• Oracle
• SQL
• Tableau

Benefits

• Medical, Dental and Vision Insurance
• Wellness Program
• Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
• Short-Term and Long-Term Disability options
• Basic Life and AD&D Insurance (Company Provided)
• Voluntary Life and AD&D options
• 401(k) Retirement Savings Plan with matching after one year
• Paid Time Off