Senior BI Analyst

Description:

Davis Furniture is a family-owned high-end furniture manufacturer who is a leader in contemporary contract furniture. With 325 employees across manufacturing, design, sales and distribution, we are proud of our collaborative culture and commitment to excellence. We have been in business for over 80 years, and we put a strong focus on new product introductions because design is a choice.

We are seeking a Senior Business Intelligence Analyst who will be responsible for designing, developing, and maintaining the data infrastructure and analytical solutions that enable data-driven decision-making across the company. This role serves as the bridge between technical data systems and business stakeholders, transforming raw data into actionable insights that drive operational excellence and strategic initiatives.

The position encompasses both the technical engineering of robust data solutions and the analytical interpretation of complex business data. The Senior BI Analyst will write and optimize complex SQL queries, design and maintain ETL/ELT processes, develop reusable data models, and create compelling visualizations and reports that inform business strategy. This role is critical to ensuring data quality, accessibility, and consistency across the organization while empowering business leaders to make informed decisions based on accurate, timely information.

Requirements:

Data Infrastructure & Engineering

• Write, modify, and optimize complex SQL queries to extract, transform, and analyze data from enterprise databases
• Design, develop, and maintain ETL/ELT processes to integrate data from multiple source systems into the enterprise data warehouse
• Contribute to data warehouse design and implementation that supports scalable analytics and reporting capabilities
• Develop and maintain data models, schemas, and database objects that optimize query performance and data accessibility
• Develop and maintain analytical scripts and programs using Python, R, or similar languages for data transformation, statistical analysis, and automation of analytical processes
• Troubleshoot and resolve query performance issues through query optimization, indexing strategies, and data model refinements
• Implement data quality frameworks and validation processes to ensure accuracy and consistency of enterprise data
• Create and maintain technical documentation for data processes, models, and SQL code
• Coordinate version control, release management and deployment processes for BI solutions, ensuring proper testing and validation
• Administer cloud-based reporting platforms (Azure, AWS, or similar) including user access, resource management, and cost optimization

Required Technical Skills

• SQL Proficiency: Advanced SQL skills including complex queries, joins, subqueries, CTEs, window functions, and query optimization techniques
• Query Optimization: Ability to analyze query execution plans, identify performance bottlenecks, and implement optimization strategies
• ETL/ELT Development: Hands-on experience designing and implementing data integration processes and workflows
• Data Warehousing: Strong understanding of data warehouse concepts, dimensional modeling, star/snowflake schemas, and fact/dimension tables
• Power BI: Demonstrated expertise in Power BI including DAX, Power Query M, data modeling, and dashboard development
• Scripting Languages: Proficiency in Python, R, or similar languages for data manipulation, automation, and statistical analysis
• Data Analysis: Strong analytical skills with ability to interpret complex datasets and extract meaningful insights

Minimum Qualifications

Education

• Bachelor's degree in computer science, Information Systems, Data Analytics, Business Analytics, Statistics, Finance, or related field required; OR,
• Equivalent combination of education and experience may be considered

Experience

• Minimum 3-5 years of experience in business intelligence, data analytics, or data engineering role; 5-7 years of experience strongly preferred
• Demonstrated experience writing complex SQL queries and optimizing query performance; demonstrated experience writing DAX formulas analytical scripts in Python, R or similar languages for business intelligence solutions
• Proven track record of designing and implementing ETL processes and working with data warehouse solutions
• Experience developing reports and dashboards using Power BI or similar tools is required
• Experience analyzing financial data and creating financial reports is required
• Manufacturing industry experience preferred
• Experience working with ERP systems is preferred

Benefits:

401(k)

Profit Sharing

Excellent health insurance

Dental and vision plans

Life insurance

Short-term disability

Referral program

Paid holidays

Onsite Clinic

Schedule:

Onsite Monday-Friday

Davis provides an excellent, drug free working environment and is an EOE/including disability/vets employer.