About Smartwyre

Founded in 2018, Smartwyre is a venture-financed SaaS business delivering enterprise software to large agricultural businesses, operating in a $400 billion global industry. With an estimated 5 million farmers and over 5,000 distributors globally, Smartwyre works across the agricultural supply chain, from large corporations to local farms. Presently, we work from the United States, United Kingdom, Europe, and South America.

We are building a B2B SaaS platform to network together the commercial operations of the companies that supply the world’s farmers with seeds, fertilizer, chemicals, and services, with their target markets being the United States, Europe, and Latin America. We aim to first offer SaaS applications to solve key commercial pain points (pricing, costing, quoting), then network these companies using a common data platform (transactional data exchange, product information publication, people networking, and user analytics), and finally empower the network to facilitate new business model amongst network participants.

About The Role

At Smartwyre, we’re helping our customers adapt to an ever-changing environment by leveraging data and insights to help them drive exceptional commercial performance. As part of our Business Insights Team, you will help provide our customers with the actionable insights that only Smartwyre can provide to make these decisions. This is core to transforming the agriculture inputs industry that we are focused on.

We are creating and managing datasets using a Snowflake SQL environment to present and analyze pricing, costs, rebates, products and businesses in real time with market leading accuracy. This is the platform the Insights team is building to help our customers.

What You'll Do

• Gather and understand business requirements in the BI context to design data models which convert raw data to meaningful insights.
• Meet regularly with internal and external stakeholders to create and design new reports and optimize existing reports.
• Use Snowflake databases and SQL as the key tool for managing these large datasets
• Create dashboards and visual interactive reports using Power BI and other tools.
• Identify KPIs with clear objectives and monitor them consistently.
• Analyze data and present it through reports that can help in decision-making.
• Design, develop, and deploy Power BI scripts and perform efficient detailed analysis.
• Perform DAX queries and functions in Power BI.
• Create charts and document data with equations, parameters, models, and relations explanations.
• Contribute towards the continuous improvement of the current ETL and relational database.
  
  

Experience

• Minimum 2-4 years related experience in report development and analysis.
• Strong Power BI skills.
• Strong skills in Excel with experience
• Strong skills in SQL / TSQL, particularly with SnowSQL.
• Knowledge of database fundamentals such as multidimensional database design, relational database design, and more.
• Experience creating data models
• Excellent communication skills to explain problems and solutions.
• Strong outcome focus.
• Comfort in operating in a dynamic, high-change environment