Business Intelligence Analyst

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.

Benefits & Perks: 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.