System Analyst

Summary

Join Sweed, a cannabis retail solution provider, as a System Analyst! We're a remote-first company with a modern data stack and a product on the market for 4 years. You will gather and analyze requirements for reports and dashboards, design and integrate storage components, and validate reports. This role requires at least 3 years of system analysis experience, data warehouse development experience, and strong analytical skills. We offer flexible working hours, a B2B contract with USD salary, 20 vacation days, 3 sick days, and medical insurance after probation. Proficiency in SQL and Python is a plus.

Requirements

• At least 3 years of experience in system analysis
• Experience in data warehouse development projects
• Strong ability to identify and break down business user requirements
• Skill in task allocation to developers with attention to detail
• Understanding of Data Vault, Anchor Modeling, star, OLAP cube schemes, with knowledge of their pros, cons, and use cases
• Solid understanding of database theory
• Upper-Intermediate and higher English level

Responsibilities

• Gather and analyze requirements for reports, dashboards, and data mechanisms
• Review new requirements to ensure alignment with storage needs and resolve conflicts
• Design and integrate storage components into a unified model
• Validate reports and dashboards to ensure they meet specifications
• Document tasks, update the glossary, and create diagrams/models for complex solutions
• Communicate requirements to developers and identify potential risks

Preferred Qualifications

• Proficiency in SQL
• Python proficiency for testing ETL and data profiling
• Experience with analytical databases like Greenplum, Vertica, ClickHouse, etc
• Familiarity with Python DS stack tools (Jupyter, Pandas, SciPy, Matplotlib, Bokeh)

Benefits

• Flexible working hours
• Fully remote work
• Salary in dollars (employment under a B2B contract with the USA)
• 20 working days per year vacation
• 3 days sick leave
• Medical insurance (available after probation)
• Equipment reimbursement for essential items such as laptops and additional equipment like monitors