Who we are

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

Who you are

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.

What you will be responsible for

• Owning and evolving the company’s trusted reporting, semantic, and “gold” data model layer, aligned with 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.

What you should bring to the table

• 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.

What you can expect in return

• A competitive salary
• Health insurance and other benefits
• 401k retirement plan with company match
• Company provided cell phone
• 24 paid days off as a new employee
• 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
• Team outings and planned get-togethers
• A fun and functional office in the heart of Columbia’s arts and technology district