Remote Business Intelligence Analyst (Senior) – Full‑Time – Cedar Rapids, Iowa – Tableau, Power BI, Snowflake, SQL – $110k‑$130k salary range

TITLE:Remote Business Intelligence Analyst (Senior) – Full‑Time – Cedar Rapids, Iowa – Tableau, Power BI, Snowflake, SQL – $110k‑$130k salary range --- We’re the data‑driven product team behind a suite of SaaS tools that help mid‑market companies turn messy sales pipelines into clean revenue forecasts. Over the past 18 months we’ve added three new product lines, doubled our annual recurring revenue, and hired a dozen engineers—all while keeping our core promise: give every customer a single source of truth, no matter how many data silos they have.Why this role exists now? The new product line launched in February introduced a series of usage‑based pricing packages. Our finance and go‑to‑market leaders told us the existing dashboards can’t keep up with the volume or the granularity they need. They want a near‑real‑time view of churn risk, upsell opportunity, and product adoption, all built on a modern data stack. That’s why we’re looking for a senior Business Intelligence analyst who can design, ship, and maintain the end‑to‑end analytics pipeline, and who can do it from wherever they live—provided they’re based in Cedar Rapids, Iowa (our legal employer address).### What you’ll be doing - Own the analytics roadmap for the new pricing engine. That means gathering requirements from product managers, sales ops, and finance, then translating them into data models, ETL jobs, and visualizations. - Design and build dashboards in Tableau and Power BI that surface key metrics like Monthly Recurring Revenue (MRR), Net Revenue Retention, and Customer Lifetime Value. We expect a first‑release dashboard within 6 weeks, then iterative improvements every sprint. - Write production‑grade SQL (PostgreSQL, Snowflake, Redshift) and Python scripts to clean, aggregate, and enrich raw event logs.You’ll be hands‑on, not just a spec writer. - Maintain data pipelines in dbt and Airflow, ensuring they meet our 2‑hour SLA for data freshness. Our current pipeline runs on a 3‑node Redshift cluster, but we’re planning to shift workloads to Snowflake in Q2. - Create documentation in Confluence and version control everything in Git. We’ve seen too many “black‑box” reports that no one can edit without breaking something, so we value transparent, reusable code. - Partner with the customer success team (5 members) to embed analytics into their weekly workflow.They’ll ask, “Can we see a churn risk score for this account?” and you’ll deliver a self‑service view within the same report. - Mentor junior analysts (currently 2) on best practices for data modelling, storytelling with charts, and performance tuning. You’ll hold a weekly “BI office hour” where the team can drop in with questions. - Monitor data quality using Monte Carlo alerts and custom sanity checks. If a metric deviates more than 5 % from its baseline, you’ll own the post‑mortem and fix the upstream issue.### A day in the life (yes, even remote work has a rhythm) 8:00 am – Join the stand‑up on Zoom (our team is spread across the US, but we keep the core hours synced to Pacific). You’ll give a quick update on the pipeline health and any dashboard blockers. 8:30 am – Dive into the raw event tables in Snowflake. Yesterday’s data ingestion job failed on a schema change, so you’ll write a temporary dbt macro to back‑fill the missing rows, then push a permanent fix. 10:00 am – Review the latest stakeholder feedback.Maya, a senior product manager, left a comment in JIRA: “The churn risk heat map looks great, but we need a drill‑down by industry segment.” You’ll sketch a quick wireframe in Figma, then update the Tableau workbook. 12:00 pm – Lunch break. You might step away from the screen, walk the dog, or catch up on a podcast about data ethics. 1:00 pm – Pair‑program with a junior analyst on a new Python‑based data quality check. You’ll walk them through the Airflow DAG, explaining why the task retries are set to two.2:30 pm – Write a 1‑page executive summary of the latest quarterly revenue trend. This goes into the finance leadership deck and will be emailed to the CFO by 4 pm. 4:00 pm – Attend the “Customer Success Metrics” sync. The team shares how they used the new “Adoption Funnel” report to identify 12 accounts that have slipped below the usage threshold, leading to a proactive outreach campaign. 5:00 pm – Close out the day by committing code, updating the data dictionary, and queuing a nightly dbt run. You’ll also set a reminder to review the Snowflake credit usage report next week; we’re targeting a 10 % cost reduction by the end of Q3.###The tools we live with (you’ll be comfortable with most of them) 1. Tableau – for visual storytelling, published to Tableau Server. 2. Power BI – for ad‑hoc analysis, especially for the finance team. 3. Snowflake – our cloud data warehouse, scaling compute on demand. 4. Redshift – legacy data store, still used for some high‑volume event logs. 5. dbt – our transformation layer, version‑controlled in Git. 6. Airflow – orchestrates the nightly ETL jobs. 7. SQL (PostgreSQL dialect) – the lingua franca of our data queries.8. Python (pandas, sqlalchemy) – for data preparation and custom checks. 9. GitHub – source control and code review workflow. 10. JIRA & Confluence – track work, store documentation, keep the team aligned. 11. Slack – the heartbeat of our remote culture; you’ll have a #bi‑alerts channel. 12. Excel – still the go‑to for quick ad‑hoc calculations and what‑if modelling. ### Who we’re looking for - 5+ years of hands‑on BI experience building production dashboards for SaaS or subscription businesses. -Advanced SQL proficiency (Snowflake or Redshift) and the ability to write clear, performant queries.- Proficiency in Tableau and Power BI—you can design a dashboard that tells a story without a thousand tooltips. - Experience with modern data stacks (dbt, Airflow, Snowflake) and a solid grasp of ELT vs. ETL concepts. - Python coding skills (pandas, numpy) for data cleaning and automation. - Track record of collaborating cross‑functionally (product, finance, sales ops) and translating vague business questions into concrete metrics. - Strong communication – you can write a JIRA ticket as clearly as you can present a board‑room deck.- Mentorship mindset – you enjoy lifting up junior teammates, giving constructive feedback, and sharing best practices. #### Nice‑to‑have (but not a deal‑breaker) - Exposure to Monte Carlo or other data observability platforms. - Familiarity with Looker or Mode (helps when we experiment with new reporting layers). - Experience in customer‑facing analytics – building self‑service portals that external users can query. - Knowledge of statistical modelling (A/B testing, churn prediction) using R or Python.- A certification in Tableau or Power BI that shows you’ve passed the exam (we’ll reimburse it). ### What you’ll get from us -Salary in the $110k‑$130k range, paid bi‑weekly, with a 10 % annual bonus tied to company OKRs. - Equity – 0.05 % of the fully‑diluted pool, vesting over four years with a one‑year cliff. - Remote‑first policy – you work from anywhere, but we require a legal address in Cedar Rapids, Iowa for payroll and tax purposes. - Health, dental, vision with 100 % premium coverage for the employee; dependents at a 50 % discount.- 401(k) matching up to 4 % of your salary, with a company‑wide profit‑sharing contribution once a year. - Learning budget of $2 500 per year for conferences, courses, or certifications. - Quarterly “BI Hack Days” – 24‑hour sprint where you can build any data‑related project you’re passionate about, with a $500 prize for the most impactful prototype. - Generous PTO – 20 days plus public holidays, plus an additional “mental health” day each quarter. ###Our culture in a nutshell We’re a small team (15 engineers, 8 analysts, 5 product managers) that meets daily on Zoom, but we also celebrate wins in person.Twice a year we travel to the Cedar Rapids office for a three‑day “off‑site” where we do retrospectives, brainstorms, and a little fun (board games, pizza, a hike in the nearby hills). Here’s a moment that sticks with me: > “When I first saw Maya’s churn‑risk heat map after the ‘pivot’ she requested, I thought, ‘Wow, this actually tells a story.’ It wasn’t just numbers; it showed a clear path for the sales team to intervene.” – Maya Patel,Senior Product Manager That quote captures what we try to do every day: turn raw data into an actionable narrative that someone, somewhere, can act on.### 1. Submit your resume and a short cover letter (max 300 words) that explains why you’re excited about shaping the analytics for a fast‑growing SaaS business. 2. Upload a portfolio of 2–3 dashboards you’ve built (Tableau, Power BI, or any other tool). Include a brief note on the business problem each solved. 3. Complete a short take‑home exercise (we’ll send it after the initial screen). It’s a 90‑minute task that asks you to write a SQL query against a synthetic Snowflake dataset and visualize the result in Tableau.4. Phone screen with our Lead Engineer (30 min) – we’ll talk about data pipelines, performance tuning, and your approach to debugging. 5. Final interview with the Head of Data (45 min) – we’ll dive deeper into your experience with dbt, Airflow, and mentorship. You’ll also get a chance to ask any questions about the team, roadmap, or company culture. We aim to move candidates through this process within two weeks, because we respect your time and we know the market moves fast. --- If you love turning chaotic data streams into clear, business‑critical insights, and you’re ready to own the end‑to‑end BI function for a high‑growth SaaS product—all while working remotely from Cedar Rapids, Iowa—we’d love to hear from you.Let’s build something that actually matters. Apply tot his job