Business Intelligence Analyst II (SQL)

Location: Louisville, KY, United States

Salary: $75,500–$113,000 per year

Company

hirify.global operates a large fulfillment network and uses trusted metrics, reporting, and analysis to improve operational performance and the customer experience.

What you will do

• Own operational metrics, dashboards, recurring reports, and analytical workstreams from requirements through delivery, adoption, and maintenance.
• Develop advanced SQL queries, analysis-ready datasets, and repeatable workflows using multiple data sources.
• Monitor reporting data, investigate anomalies, and lead quality control and testing for metrics, dashboards, and analytical deliverables.
• Perform deep-dive analysis on large datasets, apply statistical methods, identify root causes, quantify opportunities, and recommend actions.
• Partner with Operations, Analytics, Data Science, and Technology teams to clarify requirements and design decision-ready analytical solutions.
• Create reusable frameworks, review analytical work, and mentor less experienced analysts in SQL, visualization, validation, documentation, and communication.

Requirements

• Bachelor’s degree in analytics, business, economics, engineering, information systems, mathematics, statistics, supply chain, or a related field, or equivalent practical experience.
• 2–4 years of relevant experience in business intelligence, data analytics, operations analytics, or a related role.
• Advanced SQL skills, including complex joins, common table expressions, window functions, data transformation, troubleshooting, and performance-conscious query design.
• Experience with data modeling and large, multi-source datasets in Snowflake or a comparable data warehouse.
• Experience building dashboards or reporting products in Tableau, Power BI, or a comparable platform, as well as using ETL or ELT processes.
• Ability to apply statistical techniques, clarify ambiguous operational questions, manage analytical projects, communicate findings, and mentor peers.

Nice to have

• Experience in fulfillment, supply chain, logistics, retail operations, or another large process-driven network.
• Familiarity with dbt or another governed SQL transformation framework.
• Python or R experience for analysis, automation, statistical modeling, or data validation.
• Experience with operational experiments, forecasting, capacity planning, labor planning, or continuous improvement.

Culture & Benefits

• Medical, prescription, vision, dental, life, disability, hospital indemnity, critical illness, and accident insurance.
• 401(k), equity grants, parental leave, family services, backup dependent care, flexible spending accounts, and telemedicine.
• Unlimited PTO for exempt salary team members, subject to manager approval, plus six paid holidays per year.
• Pet adoption reimbursement, employee assistance programs, pet insurance discounts, and discounts at hirify.global.com.