Senior Data Analyst

Summary

Join Tillster as a Senior Data Analyst and contribute to the development and improvement of data products. You will work with various teams to transform data into consumable dashboards and reports, enabling data democratization within the company and with customers. Responsibilities include developing analyses and insights, conducting A/B tests, maintaining data pipelines, and creating Looker explores and dashboards. You will collaborate with business teams, providing guidance on report creation and ETL pipelines. This role offers the opportunity to solve complex business challenges and achieve global impact. The position requires a Bachelor's degree in a quantitative field and 2-3 years of experience in a similar role, along with strong SQL skills and experience with cloud technologies. Mid-to-advanced skills in Python, Looker, and LookML are also necessary.

Requirements

• 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 to back up assumptions, develop business cases, and complete root cause analyses

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

Benefits

• Compensation competitive to market and geographical location
• Meal allowance for each day worked available through meal card
• Home/Office allowance reimbursement per calendar month, pro-rated based on employment start date
• Health insurance : Tillster pays the premium for employee private health insurance. Employees have the option to add their spouse/dependents at the employee’s cost
• Holidays: Up to 14 federal and local/municipal holidays in accordance with applicable Portuguese Labor laws, dependent on your employment start date
• Vacation: Up to 22 days of vacation every holiday year, pro-rated based on employment start date
• Education, Learning & Development : We offer Udemy Learning courses; and ongoing learning and development opportunities