Business Analytics Engineer
Software Finder is seeking a skilled and business-oriented Business Analytics Engineer to bridge the gap between business intelligence and analytics engineering. This role will own dashboards and reporting while developing the semantic and metrics layer needed to maintain consistent, reliable KPI definitions across the organization.
The ideal candidate will combine advanced SQL, data modeling, and dashboard development skills with the ability to understand stakeholder needs and translate complex business questions into clear, scalable analytical solutions.
Key Responsibilities
Design, build, maintain, and improve dashboards and reports for business stakeholders.
Develop and manage the semantic and metrics layer using dbt models or similar technologies.
Establish consistent KPI definitions and ensure business metrics are reused across teams, reports, and dashboards.
Write and optimize complex SQL queries for reporting, data modeling, and ad hoc business analysis.
Gather stakeholder requirements and translate ambiguous requests into clearly defined data models, metrics, and reports.
Partner with Data Engineering to identify upstream data-quality issues, reconcile discrepancies, and improve data reliability.
Investigate and resolve inconsistencies across source systems, data models, dashboards, and stakeholder reports.
Maintain clear documentation covering KPI definitions, data models, reporting logic, and analytical assumptions.
Establish governance practices to prevent inconsistent metric definitions across departments.
Monitor dashboard performance, query execution, data freshness, and associated infrastructure costs.
Optimize data models, queries, and dashboards to improve performance and cost efficiency.
Coordinate access to internal and external data sources and support daily data procurement activities.
Prepare clean, curated, analysis-ready datasets for downstream teams and self-service reporting.
Conduct data validation and quality checks before publishing datasets, metrics, or reports.
Support stakeholders in interpreting business metrics and using dashboards effectively.
Follow version control, testing, documentation, and review standards for analytics development.
Support additional business analytics and data-related initiatives as required.
Requirements
Bachelor’s degree in Data Science, Computer Science, Business Analytics, Statistics, Economics, Information Systems, or a related field.
2–4 years of relevant experience in business intelligence, analytics engineering, data analytics, or a similar role.
Advanced SQL skills, including complex joins, common table expressions, window functions, aggregations, and query optimization.
Hands-on experience developing dashboards and reports using Power BI, Tableau, Looker, or a similar business intelligence platform.
Experience with data modeling and developing reusable analytical datasets.
Working knowledge of dbt or a similar SQL-based data transformation framework.
Understanding of semantic layers, metrics layers, dimensional modeling, and KPI governance.
Experience identifying, investigating, and resolving data-quality issues.
Ability to translate business requirements into scalable data models, reports, and dashboards.
Strong analytical thinking, problem-solving abilities, and attention to detail.
Strong stakeholder management and written and verbal communication skills.
Familiarity with Git and collaborative development workflows.
Experience with cloud data warehouses or analytics platforms such as Amazon Redshift, Snowflake, BigQuery, or Databricks is preferred.
Familiarity with AWS data and analytics services is preferred.
Experience implementing automated data tests, documentation, and lineage using dbt is preferred.
Knowledge of dashboard performance tuning and cloud-query cost optimization is preferred.
Experience using Python for data validation, automation, or analysis is preferred.
Familiarity with data procurement, third-party datasets, APIs, or vendor data management is preferred.
Experience creating curated self-service datasets for business teams is preferred.
Understanding of data governance, access controls, data privacy, and reporting best practices is preferred.
Experience working in a B2B technology, SaaS, marketplace, or data-driven organization is preferred.