Business Intelligence Analyst

Brooksource; Nashville (TN); Hybrid; USD 52,000 - 62,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401k with company match

Paid time off

Employee Assistance Program (EAP)

Job summary

Brooksource is seeking an experienced Senior BI Analyst to design and deliver Power BI dashboards and analytics solutions. You will partner with stakeholders, data engineers, and technical teams to build robust reporting platforms and actionable insights.

Ideal candidates have extensive Power BI experience, advanced DAX and SQL skills, and hands-on Snowflake work in an enterprise data environment. You will translate business needs into scalable data models and KPI reporting across the

Qualifications

• 7+ years of BI/analytics experience.
• Strong Power BI dashboard development.
• Advanced SQL and Snowflake proficiency.
• Experience translating business needs into reports and metrics.
• Excellent communication with stakeholders across teams.

Responsibilities

• Design, develop, and maintain Power BI dashboards and analytics solutions for leadership.
• Build and maintain Power BI data models, relationships, measures, and DAX calculations.
• Translate business requirements into reporting solutions, KPIs, and data models.
• Write and optimize complex SQL queries for large datasets.
• Work with Snowflake to query, analyze, and validate enterprise data for reporting.
• Collaborate with data engineering to ensure data is accessible for downstream Power BI reporting.
• Perform data validation, mapping, reconciliation, and root-cause analysis across source systems.
• Investigate reporting discrepancies and data quality issues to identify solutions.
• Gather and refine requirements for new dashboards and analytics initiatives.
• Continuously improve performance, scalability, and usability of Power BI solutions.
• Support testing and validation of new datasets and system enhancements.
• Develop and maintain reporting documentation and data definitions.
• Manage multiple projects effectively with business and technical teams.

Skills

Power BI

DAX

SQL

Snowflake

Data modeling

Data visualization

Analytical thinking

Communication

ETL

Education

Bachelor's degree in IT/CS/Analytics

Tools

Snowflake

SAP Business Objects

Job description

Location: Franklin, TN – Hybrid (4 days onsite, 1 day remote)

Employment Type: Long-term, ongoing contract with potential for hire

Start Date: ASAP

Pay Range: $38-45/hr

Job Summary

We are seeking an experienced Senior Business Intelligence Analyst with strong hands-on expertise in Power BI, SQL, and Snowflake. This individual will partner with business stakeholders, data engineering teams, and technical resources to develop reporting and analytics solutions that support business operations and decision-making.

The ideal candidate will have deep experience building Power BI dashboards and reports from the ground up, including advanced DAX, data modeling, and visualization development. This role also requires advanced SQL skills and hands-on experience working with enterprise data in Snowflake.

Responsibilities

• Design, develop, and maintain complex Power BI dashboards, reports, and analytics solutions for business and leadership stakeholders.
• Build and maintain Power BI data models, relationships, measures, calculated columns, and advanced DAX calculations.
• Translate business requirements into effective reporting solutions, KPIs, visualizations, and data models.
• Write and optimize advanced SQL queries to extract, analyze, validate, reconcile, and troubleshoot large datasets.
• Work extensively within Snowflake to query, analyze, and validate enterprise data used for reporting and analytics.
• Partner with data engineering and technical teams to ensure data is properly structured and available for downstream Power BI reporting.
• Perform data validation, mapping, reconciliation, and root-cause analysis across multiple source systems.
• Investigate reporting discrepancies, data quality issues, and performance trends to identify underlying causes and potential solutions.
• Gather and refine requirements for new dashboards, reporting enhancements, and analytics initiatives.
• Continuously improve existing Power BI solutions for performance, scalability, usability, and accuracy.
• Support testing and validation of new datasets, reporting solutions, and system enhancements.
• Develop and maintain reporting documentation, data definitions, and business logic.
• Manage multiple projects and priorities while working effectively with both business and technical teams.

Required Qualifications

• Deep, hands-on Power BI experience, including developing complex dashboards and reports in a professional environment.
• Advanced experience with DAX, Power BI data modeling, relationships, measures, and visualization development.
• Advanced SQL proficiency with the ability to independently write complex queries for reporting, analysis, validation, and troubleshooting.
• Hands-on Snowflake experience within a business intelligence, analytics, or enterprise data environment.
• Experience using Power BI and Snowflake together to develop enterprise reporting and analytics solutions.
• Strong understanding of relational databases, data modeling, and enterprise data warehouse concepts.
• Strong analytical and problem-solving skills with experience investigating complex data and reporting issues.
• Ability to translate business needs into technical reporting and analytics solutions.
• Excellent written and verbal communication skills with the ability to collaborate directly with business stakeholders and technical teams.
• 7+ years of professional experience in business intelligence, analytics, data, or a related field.

Preferred Qualifications

• Experience supporting automotive, manufacturing, supply chain, operations, aftersales, or purchasing environments.
• Experience working with large-scale enterprise datasets and multiple source systems.
• SAP Business Objects experience is a plus.
• Bachelor's degree in Information Technology, Computer Science, Mathematics, Statistics, Analytics, Business Technology, or a related field.

Disclaimer: Brooksource, Medasource, and Calculated Hire are part of the Eight Eleven Group family of companies and operate under Eight Eleven Group, LLC. All employees receive the same benefits, policies, and terms of employment.

EEO:

We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, ancestry, age, disability, genetic information, marital status, military or veteran status, citizenship, pregnancy (including childbirth, lactation, and related conditions), or any other protected status in accordance with applicable federal, state, and local laws.

Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.

Pay Disclaimer: The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.