BI Data Engineer - Platform Analytics
- Full-time
Company Description
Job Description
As a Business Intelligence Data Engineer, you will be partnering with Platform Analytics team to architect, implement and manage Data Models and ETLs that curate product and event tracking data for fast and thorough analyses. You will play an integral part in enabling the Platform Analytics team to take data-driven decision making and ROI optimization to the next level. You are a self-starter and you are comfortable working cross-functionally with other teams across Square.
You will:
Partner with various stakeholders in Platform Analytics, Marketing, Product Analytics and Data Science teams to understand their priorities, identify the right data sets to work on, understand their data and reporting requirements, and translate them into definitions and technical specifications (PRD)
Be responsible for defining, developing and optimizing curated datasets and schemas with standardized metrics and definitions across the company
Develop, deploy and maintain ETL jobs and visualizations
Work closely with technical partners in BI team on designing and developing robust data structures and highly reliable data pipelines
Troubleshoot technical issues with platforms, data discrepancies, alerts etc
Perform ad hoc analysis, insight requests, and data extractions to resolve critical business issues
Qualifications
You have:
5+ years working experience in a successful data engineering or business intelligence team
Expert knowledge in data modeling concepts and implementation
Strong technical accomplishments in SQL, ETLs and data analysis
Hands on experience in processing extremely large data sets.
Strong business intuition and ability to understand complex business systems
Experience with Linux/OSX command line, version control software (git)
Even Better:
Familiarity with technologies such as Airflow
Experience with Snowflake database
Work experience with Python or any programming language
Experience with visualization technologies such as Looker
Knowledge of payment network transactional data and event logging data