Business Data Analyst

Job summary

Collect, clean, structure, and model operational data from multiple systems, then build and optimize interactive dashboards and automated reports using BI tools. Analyze trends and KPIs, maintain data quality through SQL and database work, communicate findings to business stakeholders, and train users on dashboard tools.

Job details

About Hirevantis LLC Hirevantis LLC is a leading IT staffing, technology consulting, and talent solutions provider. We bridge the gap between exceptional professional talent and top-tier cross-functional teams throughout North America. As we expand our presence across Canada, we are seeking a results-driven Business Data Analyst to turn data into actionable intelligence and drive commercial success for our enterprise business clients. Position Overview We are looking for a Business Data Analyst with 3 years of professional experience who thrives at the intersection of business strategy and technical data analytics. In this role, you will collaborate with cross-functional stakeholders to collect, clean, and model complex datasets, building interactive tracking tools and dashboards that directly guide business decisions. Key Responsibilities Data Synthesis & Visualization: Collect, structure, and clean raw operational data from multiple disparate production systems to create reliable truth metrics. Dashboard & Report Engineering: Design, build, and optimize interactive business dashboards and automated reports using Tableau or Power BI. Stakeholder Collaboration: Act as the primary liaison between technical teams and business units to translate complex analytical findings into clear, actionable corporate strategies. Statistical Performance Analysis: Perform continuous trend evaluation, key performance indicator (KPI) monitoring, and data mining to identify operational bottlenecks and growth avenues. Database Management: Write and refine advanced SQL queries, handling database scripts, triggers, and basic data governance metrics to ensure validation accuracy. End-User Training: Train internal teams and client partners on navigating newly deployed dashboard tools to drive data culture autonomy. Required Qualifications & Skills Education: Bachelor’s degree in Computer Science, Statistics, Mathematics, Business Administration, Data Management, or a related quantitative field. Experience: Exactly 3+ years of direct experience working as a Data Analyst or Business Data Analyst. Technical Mastery: Exceptional proficiency in SQL for relational database querying. Proven expertise with BI reporting software (Power BI, Tableau, or Looker). Practical coding familiarity with scripting languages like Python or R for data wrangling. Advanced command of MS Excel (including Power Query, pivot tables, and macro-modeling). Core Competencies: Strong analytical, problem-solving, and critical thinking capabilities with an unwavering attention to detail. Communication: Excellent verbal and written English communication skills, with a proven ability to present data-driven narratives to senior management. Preferred Attributes Prior experience working within an Agile / Scrum framework. Familiarity with Canadian market metrics or working within distributed North American consulting networks. Certifications such as the Google Data Analytics Professional Certificate or Certified Analytics Professional (CAP). What We Offer Competitive Canadian market salary commensurate with mid-level technical expertise. Flexible work schedules (remote/hybrid flexibility matching local provincial standard time zones). Extended health, dental, and professional development support pipelines.

What you’ll do

Collect, clean, structure, and model operational data from multiple systems, then build and optimize interactive dashboards and automated reports using BI tools. Analyze trends and KPIs, maintain data quality through SQL and database work, communicate findings to business stakeholders, and train users on dashboard tools.

Requirements

Requires a bachelor’s degree in a quantitative or related field and at least three years of direct Data Analyst or Business Data Analyst experience. Candidates should have strong SQL, BI reporting, Python or R, and advanced Excel skills, along with analytical ability and excellent English communication skills.

Benefits

• Competitive Salary
• Flexible Work Schedules
• Extended Health Benefits
• Dental Benefits
• Professional Development Support

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• SQL · Preferred
• Tableau · Preferred
• Microsoft Excel · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Power BI
• Tableau
• Looker
• Python
• R
• Microsoft Excel
• Power Query
• Data Wrangling
• Data Cleaning
• Data Modeling
• Dashboard Development
• Statistical Analysis
• KPI Monitoring
• Data Visualization
• Stakeholder Communication

Job areas

• Data & Analytics
• Technology
• Consulting

More jobs from Hirevantis LLC