Company Name: Data Ideology

Job Details: RemoteFull,Time

Job Url: https://hiring.cafe/viewjob/y7s4l151ic6wtc9d

Job Description: Posted 2w agoData Engineer@ Data IdeologyView All JobsWebsitePittsburgh, Pennsylvania, United StatesRemoteFull TimeResponsibilities:Develop pipelines, Write SQL, Troubleshoot ETLRequirements Summary:5+ years ETL production experience; strong SQL; Informatica PowerCenter/IICS; Snowflake; SDLC; production data workflows.Technical Tools Mentioned:Informatica PowerCenter, Informatica IICS, Snowflake, SQL
Data IdeologyAt 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 EngineerWe’re starting the year strong by adding a Data Engineer to 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 productionKey ResponsibilitiesTo 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 analyticsSupport and enhance data pipelines loading into SnowflakeDebug failed ETL jobs, data discrepancies, and performance issues across ETL and warehouse layersCollaborate with business and technical stakeholders to understand data requirements and translate them into working solutionsSupport data warehouse environments across cloud and hybrid architecturesMaintain technical documentation, mappings, and workflow logicParticipate in SDLC processes including deployments, testing, and version controlSupervisory Responsibilities: NoneQualificationsEducation and Experience:5+ years of hands-on experience building and supporting ETL pipelines in productionStrong SQL skills, including complex joins, subqueries, aggregations, and performance tuningHands-on experience with Informatica PowerCenter and/or Informatica IICSExperience working with cloud data warehouses, including SnowflakeAbility to independently troubleshoot ETL failures, data issues, and query performance problemsExperience working within SDLC frameworks and version control systemsStrong communication skills and ability to explain technical work clearlyImportant: 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 experienceExperience supporting migrations from legacy data platformsWork Environment: Remote work from home. 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 PolicyEligibility for Health BenefitsRetirement PlanWork from HomeData Ideology is an EEO Employer.