Business Intelligence Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Column · 20 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
check
H1B Sponsor Likelynote

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

SQLDbtBigQueryGoogle Looker StudioETL toolsNoSQL datastoresData analysisAttention to detailCommunication skillsCross-functional collaboration

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

twittertwittertwitter
company-logo
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 Stage
Total Funding
$30M
Key Investors
Lux Capital
2022-08-06Series A· $30M

Leadership Team

J
Jake Seaton
Founder & CEO
linkedin
Company data provided by crunchbase