Business Intelligence Analytics Engineer

Overview

Cognito Forms is a fast-growing SaaS company empowering users to quickly build forms and form-driven business solutions – by themselves. No developer necessary.

We’re looking for a Business Intelligence (BI) Analytics Engineer to own and evolve the trusted reporting and semantic layer for our SaaS business. In this role, you’ll transform data from source systems into well-structured, governed datasets that power executive decision-making across finance, marketing, and product, while enabling self-service analytics. You’ll work closely with executive stakeholders and Product Management to turn business questions into actionable insights, define accurate and auditable metrics, identify data quality gaps, and deliver reporting that helps the company make faster, more informed decisions.

• Owning and evolving the company’s trusted reporting, semantic, and “gold” data model layer, aligned with a medallion architecture.
• Building governed, reusable datasets and semantic models that ensure consistent, auditable KPIs.
• Translating business questions into clear metric definitions, technical logic, and validated outputs.
• Developing and maintaining dashboards and reports in Power BI.
• Enabling self-service analytics through structured datasets, documentation, and standards.
• Identifying and resolving data quality issues across source systems.
• Partnering with leadership and Product Management to support data-driven decisions.
• Supporting data transformation and reporting workflows using Microsoft Fabric.
• Establishing and promoting BI best practices for governance, documentation, performance, and trust.

• Strong SQL skills for data transformation, modeling, and analysis.
• Experience with data modeling (dimensional modeling, semantic layers, KPI design).
• Hands-on experience with modern business intelligence and data lakehouse tools.
• Experience transforming data using Spark, PySpark, SQL, or similar tools.
• Experience with major cloud platforms such as Azure, AWS, or GCP.
• Experience implementing and developing a medallion architecture.
• Experience building and maintaining ETL/ELT pipelines.
• Strong understanding of data quality, validation, and governance practices.
• Ability to translate business questions into technical solutions.
• Familiarity with C# for integrations, automation, or internal tooling is a plus.

• Health insurance and other benefits
• 401K retirement plan with company match
• Company provided cell phone
• Paid time off
• Hybrid work schedule – a mix of in office and work from home
• A relaxed and flexible work environment
• A great team to work with and learn from