What are the responsibilities and job description for the Data Engineer position at IT Automation LLC?
Key Responsibilities
- Design, develop, and maintain ETL/ELT pipelines using Informatica to move data into Snowflake.
- Develop and optimize data models, schemas, and views within Snowflake.
- Implement and monitor data ingestion, transformation, and quality assurance processes.
- Ensure all solutions comply with HIPAA/HITECH and organizational security standards.
- Support HL7, FHIR, and X12 EDI interoperability initiatives.
- Collaborate with data analysts and business teams to fulfill reporting and analytics requirements.
- Document data flows, metadata, and transformation logic for transparency and traceability.
- 3–5 years of experience in data engineering or ETL development.
- Strong proficiency with Snowflake, Informatica (PowerCenter/IICS), and SQL.
- Deep understanding of data warehousing, data governance, and data quality principles.
- Experience with structured/semi-structured data (JSON, XML, CSV).
- Familiarity with AWS, Azure, or GCP storage and services.
- Scripting experience with Python for automation.
- Hands-on experience with IDQ, Data Catalog, Git, and CI/CD pipelines.
- Snowflake or Informatica certification(s) highly desirable.