Business Intelligence & AI Analyst

Cin7; Denver (CO); Remote; USD 85,000 - 100,000; Full time

Benefits offered by this job

Medical, dental, vision

401k match program

Flexible PTO

Remote work flexibility

Company-sponsored events

Job summary

Cin7 is a fast-growing global software company delivering inventory and order management solutions. This role owns Power BI dashboards end to end, tracing data from source systems through Azure Data Factory into Fabric, building semantic models and DAX measures, and integrating AI to streamline reporting.

You will partner with cross‑functional teams, ensure data accuracy, document models, and push automation to reduce manual work, while maintaining governance and quality for leadership insights.

Qualifications

• 2–3 years hands-on Power BI experience building datasets and data models.
• Strong SQL knowledge for data validation and joins.
• AI-native fluency: integrate AI into BI workflows with validated outputs.

Responsibilities

• Design, build, and maintain Power BI datasets and dashboards with underlying models and measures.
• Explain data flow from source systems through Azure Data Factory into Fabric and Power BI.
• Partner with stakeholders to gather requirements and translate them into technical specs.
• Own data accuracy and troubleshoot reporting issues across outputs.
• Document data models and reporting logic for team continuity.
• Identify AI-assisted improvements to automate manual reporting and enhance self-service analytics.

Skills

Power BI

SQL

AI in BI

Education

Bachelor's degree in a relevant field

Tools

Microsoft Fabric

Azure Data Factory

Job description

Cin7 is a fast-growing global software company that provides solutions for modern-day product sellers. We help these sellers connect and simplify their operations, keep track of their inventory at scale, and help them sell their products across multiple sales channels around the world.

Cin7 is expanding very quickly with a mission to empower product sellers to thrive by making selling as easy as buying. We are committed to this mission to become the leading Inventory Management Software brand in the world.

Serving over 8,000 customers globally, processing more than 125 million orders per year, and supporting over $35B of Gross Merchandise Value, Cin7 has been rated best overall in inventory management software in 2024 by Forbes Advisor.

How you'll make an impact:

Owning Power BI dashboards and datasets end to end means tracing data from source systems through Azure Data Factory into Fabric, building the semantic models and DAX measures behind self-service reporting, and making sure what leadership sees is accurate. This is a build-and-maintain role first and ad hoc analysis second, and it calls for sound judgment on AI: knowing where automation genuinely improves a reporting workflow and where it doesn’t.

What you'll do:

• Design, build, and maintain Power BI datasets, data models, and dashboards — not just visuals, but the relationships and measures underneath them
• Understand and be able to explain how data flows from source systems through Azure Data Factory into Fabric and into Power BI, well enough to diagnose issues independently rather than escalating every anomaly
• Partner with stakeholders across departments to gather requirements and translate them into technical specs
• Own data accuracy and quality for reporting outputs — troubleshoot and resolve issues as they surface, not just flag them for someone else
• Document data models, datasets, and reporting logic for team continuity and QA
• Actively build AI into the daily workflow — using AI tools to draft queries, DAX/Power Query logic, and documentation, and proactively identifying where AI or automation can replace manual reporting steps — while independently validating correctness before anything reaches a stakeholder
• Identify and build AI-powered automation for manual reporting workflows, expanding self-service analytics and offsetting capacity constraints without added headcount
• Grow into Cin7’s broader Customer Operations systems over time — ChurnZero, Salesforce, ZenDesk — with training provided as needed. Not an immediate priority for this role, but baseline ChurnZero configuration is expected of every Customer Ops team member, given how central it is to the function.

What you'll bring:

• Bachelor's degree in a relevant field (information systems, computer science, business analytics, or similar) — or demonstrated equivalent experience with a track record in BI-specific roles
• 2–3 years of hands‑on Power BI experience: building datasets and data models, not just consuming or lightly editing existing dashboards — relationships, DAX measures, Power Query
• Working knowledge of SQL, framed as a diagnostic/conceptual skill (reading and validating data, understanding joins/keys/grain) rather than daily production querying
• Demonstrated ability to explain what data means and where it comes from, not just how to reproduce a report
• AI-native fluency, demonstrated rather than claimed: able to build AI tools into daily BI workflows (query drafting, DAX/Power Query, documentation, automation), independently validate their output before it reaches a stakeholder, and bring a practical sense of what these tools are and aren't good at

It's a nice to have if you bring:

• Direct exposure to Microsoft Fabric (lakehouses, dataflows) or Azure Data Factory
• Experience owning a BI dataset/model end-to-end at a prior job, not just building on top of one someone else designed

In return, we offer:

• Competitive benefits include medical, dental, vision, and a 401k company match program.
• A flexible PTO policy, allowing you the time you need to recharge.
• A diverse team, where everyone helps each other and inclusion is a core value.
• Remote work flexibility allows you to maintain a work-life balance in a way that suits your needs.
• Frequent company-sponsored events so you can get to know your coworkers.

$85,000 - $100,000 a year

Why CIN7?

CIN7 is a leader in one of the most exciting software verticals right now, and we're growing exponentially. We're looking to add people to our team who are passionate about working with a fast growth tech company.

At CIN7, we make great products available to everyone. Every month, millions of sales orders flow through our platform reducing the cost, effort and time for product sellers so they can quickly get products to customers and build their brands without worrying about their operations. We pride ourselves on providing Inventory Management and Supply Chain software to help medium-large product businesses thrive in a highly competitive, digital world. CIN7 centrally manages inventory across multiple locations and channels, connecting 500+ systems to support receiving, selling and shipping stock.

We value diversity at Cin7, and bring people into the heart of everything we do. We hire, recruit, and promote without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, pregnancy or maternity, veteran status or any other status protected by applicable law. We understand the importance of creating a safe and comfortable work environment and encourage individualism and authenticity in every member of our team

In accordance with the Colorado Equal Pay for Equal Work Act, the approximate annual base compensation range is listed above. The actual offer, reflecting the total compensation package and benefits, will be determined by a number of factors including the applicant's experience, knowledge, skills, and abilities, as well as internal equity among our team.