Business Intelligence Engineer
About the role
Position Summary
What You'll Do
- Write and maintain SQL queries, data models, and transformations that power dashboards and recurring reports.
- Build and maintain repeatable, scripted pipelines for extracting and transforming data, avoiding one-off manual steps that can't be rerun or audited.
- Build and maintain dashboards and reports for business stakeholders.
- Translate business questions into clear technical requirements, working with analysts, engineers, and product partners.
- Reconcile data across sources and document discrepancies rather than silently choosing one.
- Validate data accuracy, investigate discrepancies, and monitor data quality over time.
- Treat missing or failed data as unknown and flag it, so a gap is never reported as a confirmed zero or "none found."
- Record provenance, metric definitions, and confidence levels so stakeholders can tell verified figures from inferred ones.
- Test pipelines under realistic conditions (volume, rate limits, source failures) before committing to a design.
- Support ad hoc analysis requests and help prioritize them alongside planned work.
- Contribute to team standards for code review, version control, and documentation.
- Grow your skills on with a path toward owning datasets end to end.
- Proactively communicate to business stakeholders or request owner to make sure the outcomes deliver on time and on quality.
What You Should Have
- Experience in computer science, data science, statistics, information systems, business analytics, or a related field.
- Working proficiency in SQL, including joins, aggregations, and window functions.
- Understanding of core data modeling concepts such as dimensional modeling and star schemas, gained through coursework, projects, or internships.
- Familiarity with at least one data visualization tool.
- Ability to verify outputs against independent sources and to explain how you checked your work.
- Comfort working with source systems that are poorly documented or change without notice, such as inspecting web application behavior or undocumented APIs.
- Experience using AI tools in analysis work while independently validating their output.
- Strong analytical and problem-solving skills, with attention to detail.
- Clear written and verbal communication skills, including the ability to explain data findings to non-technical audiences.
What Will Make You Stand Out
- Internship or project experience building dashboards, reports, or data pipelines.
- Python scripting for data extraction, validation, or automation.
- Exposure to data quality checks, testing, or audit-trail practices.
- Exposure to cloud data warehouses (such as Snowflake, BigQuery, or Redshift) or transformation tools (such as dbt or Airflow).
- Interest in cybersecurity, cloud, or AI products and the data they generate.
What We Offer You
You're important to us. What matters to you, matters to us too. TrendAI provides benefit options for you and your family.
- Comprehensive medical, dental and vision insurance
- Life insurance
- Short & Long Term Disability
- Pre-partum, maternity, parental and medical leave
- Mental Health Wellness Program
- Adoption Assistance
- Wellness Incentive
- Pet Insurance
- 401(k) with company match
- Paid Time Off
- 14 Annual Holidays
- Tuition Assistance
- Employee Resource Groups
We offer competitive compensation with bonus opportunity tied to company performance, along with room to enhance your skills through ongoing learning and broad technological opportunities. Achieving work-life balance is a priority, complemented by team activities, fostering an environment rooted in equity, inclusion, and collaboration, that is reflected in both our culture and our work.
This position does not offer sponsorship for work permit applications or renewals, either now or in the future.
Not included in the source posting: about the role, qualifications.
Skills
Who can apply
The employer didn't state any visa, work authorization, citizenship or clearance requirements in this posting. Confirm with the employer before applying.
Read automatically from the employer's posting text. Always confirm with the employer — requirements can change after a job is published.