Key skills
SQLAnalyticsBITableauSnowflakeRedshiftDatabricksdbtPerformance Optimization
About this role
PCG Talent Network is seeking a part-time Analytics Engineer to support their analytics engineering workload. This role focuses on transforming and modeling data within their data warehouse to enhance analytics, reporting, and business insights.
Responsibilities:
- Transform and model raw data into clean, structured datasets for analytics and reporting
- Develop and maintain data transformation pipelines using dbt
- Write efficient SQL queries to prepare and optimize datasets within the data warehouse
- Ensure data accuracy, consistency, and reliability through testing and validation
- Support BI reporting by preparing datasets used in dashboards and visualization tools
- Collaborate with analytics and data teams to understand business data requirements
Requirements:
- 3+ years of experience working with modern data warehouses such as Snowflake, Databricks, or Amazon Redshift
- SQL skills for data transformation, modeling, and performance optimization
- Experience using DBT for analytics engineering workflows
- Experience with BI or visualization tools such as Tableau
- Ability to work independently in a remote, part-time contractor role
- Experience working with financial datasets or financial analytics