Business Intelligence Analyst

Brooksource; Nashville (TN); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Brooksource in Nashville, TN is seeking a senior BI/Analytics Engineer to design data models and deliver reporting solutions using enterprise data warehouse resources.

The role requires 7+ years in BI/data analytics, expertise with Snowflake and SAP Business Objects, and strong SQL skills. Hybrid work arrangement: 4 days on-site, 1 day remote.

Qualifications

• Advanced analytical and problem-solving skills.
• Strong understanding of enterprise data warehouse concepts.
• Experience writing SQL scripts to troubleshoot reporting and query issues.
• Excellent written and verbal communication skills.

Responsibilities

• Translate end-user needs into data models, visuals, and reports.
• Collaborate with cross-functional teams on strategic design.
• Use SQL, Snowflake, SAP Business Objects to extract and analyze data.
• Lead end-user testing and develop queries to troubleshoot issues.
• Support iterative development to improve reporting and analytics.
• Refine requirements for enhancements to reporting systems.
• Create and maintain data dictionaries and glossaries.
• Validate and reconcile data across multiple source systems.
• Manage multiple projects and priorities.
• Audit and reconcile monthly billing data from partners.

Skills

Advanced analytical skills

Enterprise data warehouse concepts

SQL scripting

Communication skills

Education

Bachelor's degree in IT/CS/Math/Analytics

Master's degree preferred

Tools

Snowflake

SAP Business Objects

Excel

Job description

Hybrid in Nashville, TN (4 days on-site, 1 day remote)

Responsibilities

• Collaborate with business stakeholders to design and deliver technical solutions that align with functional needs by translating end-user requirements into effective data models, visualizations, and reporting solutions using enterprise data warehouse resources.
• Participate in strategic planning and solution design with cross-functional teams.
• Utilize SQL, Snowflake, SAP Business Objects, and other business intelligence tools to extract, validate, analyze, and report on data from enterprise data platforms and approved data sources.
• Lead end-user testing efforts, develop database queries to evaluate system behavior, identify root causes, and resolve data or reporting issues.
• Support an iterative development process to continuously improve reporting and analytics solutions.
• Gather and refine requirements for enhancements to existing reporting systems, with a focus on improving operational efficiency and streamlining business processes.
• Develop and maintain process documentation, data dictionaries, and business glossaries to promote data consistency and transparency.
• Perform data validation, mapping, reconciliation, and analysis across multiple source systems.
• Manage multiple projects and priorities while working effectively both independently and within a collaborative team environment.
• Collect, audit, and reconcile monthly business billing data from third-party partners, process files into the required format, and submit them into enterprise billing systems.
• Partner with internal business teams to audit and maintain ongoing operational data accuracy.
• Perform other related duties as assigned.

Required Qualifications

Technical Skills:

• Advanced analytical and problem-solving skills.
• Strong understanding of enterprise data warehouse concepts.
• Experience writing SQL scripts to troubleshoot reporting and query issues.
• Excellent written and verbal communication skills.

Experience

• Experience designing data visualizations and working with business intelligence and data mining tools.
• Solid understanding of relational database design and modeling.
• Experience with Snowflake and SAP Business Objects preferred.
• Web development experience is a plus.
• 5+ years of database experience.
• 7+ years of professional experience in business intelligence, analytics, data engineering, or a related field.
• Experience supporting supply chain, operations, manufacturing, aftersales, or purchasing environments is preferred.
• Experience working with technical product or parts data is beneficial.

Education

• Bachelor s degree in Information Technology, Computer Science, Mathematics, Statistics, Analytics, Business Technology, or a related field.
• Master s degree preferred.

Additional Skills

• Intermediate proficiency with Microsoft Excel, Access, Word, and PowerPoint.
• Experience working with enterprise applications and legacy systems to troubleshoot complex issues.
• Technical or programming experience is preferred.

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 0s 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.