About the Role:
As a Data Analyst at FGI, you will transform complex, imperfect datasets into actionable insights via large-scale data transformation and standardization, productionized ETL pipelines, performant and reliable data monitoring, and polished client-facing data visualizations and dashboards.
We want to make actionable, data-driven insights easily accessible to every employee at FGI. Your role will be to partner with data engineering and product leaders to establish and evolve the data practices for the company into ones that will inform key strategic decisions, measure the success of our goals, and make data points more easily accessible to the team as a whole.
Your projects will involve a mixture of running experiment-based data analyses, building out automated dashboards/reports, and building out key data models.
Key Responsibilities:
You will:
- Own the transformation of raw, semi-structured datasets into standardized schemas/models in our cloud-based data warehouses.
- Work closely with data engineering and business team leads to distill complex data into easily interpretable dashboards that enable leadership / business teams to extract data insights and monitor KPIs
- Build centralized data tooling to support self-service analytics and data-driven decision making across the company
- Develop models to scale key business areas (e.g. e-commerce customer segmentation / customer lifetime value)
- Establish best practices for data analyses and experiments
Qualifications:
- Advanced SQL skills – You know your way around analytical and aggregate functions, complex joins, window functions, and are confident in wrangling all types of data in SQL.
- Strong Python skills – You are well-versed in common data science libraries such as Pandas and NumPy and tools like Jupyter notebooks but are also able to write basic Python code that is clean, well-documented and tested.
- Curiosity and willingness to dive into data to discover actionable insights. You are always asking relevant questions and you know how to find answers within data.
- Experience working with large datasets for ETL activities; experience with task orchestration tools like Airflow is a plus.
- Strong communication skills / experience collaborating across multiple teams and functions.
- Experience with A/B & Feature Flag Testing
- Experience with data visualization (Metabase, Tableau, Looker, etc.) and cloud computing platforms (GCP, etc.) is a plus.
Our Data Tooling:
- Airflow
- Stitch
- GCP: Google BigQuery / Google Data Studio
- dbt
- Metabase
- TBD (you’ll help us decide what’s next!)