Lead Data Analyst

Everything runs on a single Rails app and one Postgres database, deployed on Heroku. Customers who call us usually reach someone who wrote the code they are asking about.

Job summary

Troutcast Software is hiring for the Lead Data Analyst role to answer business questions with data and turn the answers into reports people actually use. We work hybrid out of Cape Coral, usually three days in, two days remote.

Main duties

• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Track sales, inventory or service levels against targets and flag misses early
• Investigate data quality issues and work with data engineering to fix them at the source
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Write SQL queries against the data warehouse to pull and join data for analysis
• Support A/B test readouts with basic statistical checks
• Field ad hoc requests through a ticket queue and prioritize them with your manager

You'll need

• 7+ years of experience in a data or reporting analyst role
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Basic statistics: averages vs. medians, distributions, significance
• Able to juggle several requests and say when a deadline isn't realistic
• Bachelor's degree in statistics, economics, business, math or a related field

Nice to have

• Google Analytics 4 or Adobe Analytics
• Tableau Desktop Specialist or Microsoft PL-300 certification

Perks and benefits

Salary range: $116,000 - $140,000 annually

• 401(k) with 4% match
• Short- and long-term disability
• Life insurance
• Vision insurance
• Health insurance
• 401(k) with company match

We are unable to sponsor visas for this position.

No agencies or third-party recruiters, please.

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Troutcast Software LLC.