Senior Data Analyst

**SENIOR DATA ANALYST-REMOTE BUT MUST LIVE IN PORTUGAL**

**About Tillster**
Headquartered in the USA, with teams in Portugal, Germany, and Spain. Tillster is the global leader in digital ordering and customer engagement solutions. For over a decade we have developed revolutionary self-service, ordering and payments solutions - for mobile, tablet, online, kiosk, call center, and more - creating personalized interactions based on consumer preferences, language, and currency. Our platform is compatible with 15+ unique POS systems, representing over 90% coverage in multi-unit restaurants. We offer one platform: one scalable, enterprise class solution - to create world-class digital engagement solutions. Our mission and passion are one in the same: Empower restaurants and consumers to engage and transact anywhere, anytime, and from any device - one consumer at a time, one order at a time, billions of times over. In doing so, together we are transforming e-commerce in restaurants and making the till grow for Tillster and our customers.

**Position Summary**
In the role of Sr. Data Analyst, you will work across Data Analytics, Data Engineering, BI Engineering related tasks, exercising excellent problem solving, data wrangling and analytical storytelling You will be responsible for helping to transform data from our services and existing reports and Tableau dashboards into consumable data Explores and dashboards in our platform. You will play a crucial role in enabling data democratization inside Tillster and with our customers - owning the implementation, improvement, and maintenance of our data products. This includes partnering and consulting with business teams to provide guidance and assistance in creating and streamlining Looker or equal style reports and underlying ETL pipelines. You will collaborate across the organization, with business, market, customer and consumer focused leadership and team members alike. It is an opportunity to solve complex business, technology, customer, and consumer challenges and realize globally impactful wins

**Responsibilities**
- Develop and present analyses, actionable insights & recommendations to key stakeholders including senior executives & customers in forums and periodic business review meetings.
- Explore data to find actionable insights through funnel analysis, user segmentation & cohort analysis (and other modeling approaches).
- Conduct A/B Tests to help the development teams optimize and enhance Tillster’s products, as well as helping customers take decisions on how they conduct their business.
- Develop and maintain data pipelines to support various data needs for internal or external data consumption.
- Identify and implement new capabilities and best practices to develop and improve self-service and automated data analysis processes.
- Develop and update clear, high performing Explores and dashboards for business stakeholders such as Marketing, Product, Finance, Engineering, Sales, Account, and Support/Operations.
- Create new Explores to enable non-technical analysts to access data, build dashboards, and solve critical business challenges on Looker technology.
- Create new complex dimensions and measures for analysts to meet their business needs.
- Help create and maintain coding standards (style guides, etc.) and perform code reviews for other BI developers or technical analysts.
- Update production explores and dashboards to ensure consistent and accurate data as underlying data warehouse changes.
- Promote and ensure the use of a common semantic layer, data definitions, and metric calculations across all business areas.
- Maintain Tillster Data infrastructure.
- Write SQL, build derived tables, and work with data engineering to ensure queries are performant, maintainable, and consuming cloud computing resources most efficiently.
- Ensure project: model: view structure is optimized to handle internal and external multi-tenant access and re-architect as needed for growing business use cases.
- Optimize performance through re-architecting as needed.
- Maintain existing data pipelines.
- Develop LookML in Looker.
- Troubleshoot Jenkins orchestration jobs.
- Modify SQL and Python code for ELT process to load data into Redshift.
- Other duties as needed, required, or directed.

**About You**
- Bachelor’s degree in a quantitative area such as Math, Statistics, Computer Science, Engineering, or equivalent experience
- Minimum of 2-3 years of experience in similar role
- Excellent SQL skills
- 2 years of experience on AWS or Google cloud technologies (Redshift or BigQuery)
- Mid to Advanced skills in Python, Looker and LookML
- 2+ years’ experience in developing end to end business intelligence solutions, including data warehousing and business intelligence tools, techniques, and technology.
- Proven analytical and quantitative skills (including ability to effectively use business tools such as Excel, Tableau, Looker) and an ability to use data and metrics t