Job Description

As a Business Intelligence Data Engineer supporting Square F&S team, you will be responsible for defining, developing and managing curated datasets, key business metrics and reporting across functional units at Square.  You will architect, implement and manage data models and ETLs that will enable product and business teams access consistent metrics across the Square ecosystem. You are a self-starter and you are comfortable working cross-functionally with other teams across Square.

You will:

• Partner with the Guidance team, upstream infrastructure platform engineering teams, and downstream data consumers to understand data and translate business requirements into technical design of building scalable data pipelines
• Work with DS lead to define the metrics/KPI required to measure to measure performance and forecast
• Focus on accuracy and scalability of data pipelines ensuring it’s easy to ingest new projects 
• Develop and take ownership of BI data pipelines and centralized data warehouse with trustworthy curated datasets and standardized metrics and business definitions to empower data access and self-service
• Perform ad hoc analysis, insight requests, and data extractions to resolve critical business reporting issues.
• Design dashboards in Looker or Tableau to empower stakeholders monitoring pertinent KPIs through novel visualizations.

Qualifications

Required: 

• 5+ years of data engineering experience with an understanding of database management and cloud computing databases
• Experience with data warehousing architecture 
• Hands on experience with data modeling and dimensional modeling design
• Experience with end to end ETL pipeline development and implementation using SQL and python
• Experience building reports with Looker, Tableau, or similar BI visualization tools
• Hands on experience on cloud-based computing services and data warehouses like Snowflake, Redshift, Azure, or similar
• Excellent communication skills with strong business intuition and ability to understand complex business systems and requirements

Preferred: 

• Experience with the following tools and technologies: 
  • Snowflake
  • Airflow
  • Looker/Tableau
  • Git
• Experience working with Finance/Accounting partners in helping them measure/tracking financial metrics like top line growth, NPA etc.