Job Summary: We are seeking a Data Analyst to support data ingestion pipelines, develop transformations, and optimize reporting tables. Key Responsibilities: 1. Support for data ingestion pipelines and transformations. 2. Development of transformations in Python and SQL. 3. Optimization of reporting tables and troubleshooting. - Review Redshift queries and the reporting layer. - Provide support for data ingestion pipelines from multiple data sources. - Develop transformations in Python and SQL. - Maintain and improve orchestration workflows for queries. - Create, diagnose, and optimize reporting tables that feed dashboards in LookML and Looker Studio. - Manage synchronization processes between Redshift and Postgres used as the serving layer for Looker and Looker Studio. - Investigate and resolve pipeline failures, broken dashboards, schema issues, and data quality issues.-Requirements- Minimum education: Technical degree 1 year of experience Languages: English Skills: Database, Power BI, Python, Redshift, SQL Keywords: analyst, data