Column · 2 hours ago
Business Intelligence Engineer
Column is an AI-powered software platform that helps governments, law firms, and media organizations notify the public. They are seeking a skilled Business Intelligence Engineer to own and evolve their analytics and reporting infrastructure, ensuring financial reporting accuracy and operational trust in data.
Software
Responsibilities
Own, maintain, and improve core data systems including dbt, Stitch, and the BigQuery data warehouse sourced from NoSQL datasets (e.g., Firestore)
Develop reliable, well-documented data models, transformations, and ELT pipelines supporting revenue, operational, and financial reporting
Implement and maintain data quality and observability frameworks, including dbt tests, schema-change monitoring, and pipeline alerts
Be the BigQuery export to apply version control, documentation, naming conventions, and workflow best practices for long-term maintainability
Build, maintain, and optimize Google Looker Studio dashboards, ensuring accuracy and usability
Perform ongoing dashboard maintenance, enhancements, and metric updates as business needs evolve
Apply visualization best practices to help business teams quickly interpret performance, trends, and operational bottlenecks
Support adhoc custom internal and external (partner-facing) reporting requirements
Build and maintain recurring operational reports, including those used for enterprise customer audits and sales pipelines
Own the accuracy and maintenance of reports and data pipelines used for financial decision-making, such as revenue, margin, capture rate, and fee-based metrics
Ensure consistency and QA across datasets/ models, dashboards, and downstream financial models or outputs
Partner closely with Finance, Operations, and Customer-facing teams to translate business needs into actionable analytics and data workflows
Act as a steward of core business KPIs, owning overall accuracy and maintainability
Proactively identify discrepancies and communicate changes that could impact key reporting or financial outcomes
Communicate insights, changes, and recommendations clearly to non-technical audiences
Qualification
Required
2–3 years of hands-on experience in data analysis or analytics engineering
Strong SQL skills and proficiency with dbt and BigQuery
Experience with ETL tools (Stitch or similar) and NoSQL datastores (e.g., Firestore)
Demonstrated experience building and maintaining dashboards in Google Looker Studio or comparable BI tools
Experience supporting revenue, financial, or compensation-impacting analytics
Ability to own end-to-end analytics work end-to-end, from raw data to stakeholder-facing outputs
Strong attention to detail, data accuracy and QA
Comfortable managing and communicating on multiple priorities
Preferred
Experience working with CRM data (e.g. HubSpot), financial and sales pipeline analytics
Familiarity with operational, marketplace, or workflow efficiency metrics
Experience with scheduling/orchestration tools (e.g., dbt Cloud, cron)
Exposure to data governance concepts such as access controls, retention policies, and prior success rolling out standardized naming conventions
Benefits
Comprehensive health coverage
Flexible PTO
Remote-first culture
Company
Column
Column is a public benefit corporation building technology to help media, governments and legal services work together to notify the public.
H1B Sponsorship
Column has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2021 (5)
2020 (9)
Funding
Current Stage
Growth StageTotal Funding
$30MKey Investors
Lux Capital
2022-08-06Series A· $30M
Recent News
vcnewsdaily.com
2025-12-12
2025-10-17
2025-08-13
Company data provided by crunchbase