Data Ideology, LLC

Analytics Engineer

• Collect and understand business requirements and translate those requirements into an actionable data warehouse plan.
• Knowledge of multi-dimensional and tabular design patterns and ability to identify solutions.
• Work within the SDLC framework in multiple environments.
• Define and implement best practices across database design and ETL.
• Direct ETL development, demonstrating an understanding of key concepts of ETL/ELT.

ETL Developer

Data Engineer

• 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