Technical Business Analyst

w3r Consulting; Columbus (OH); On-site; USD 120,000 - 180,000; Full time

Job summary

w3r Consulting seeks a senior data analytics professional to develop advanced reporting, data models, and executive dashboards. You will collaborate with cross-functional teams to translate business needs into actionable insights.

You will optimize SQL queries, build data warehouses, and use Python for transformation, automation, and analytics, delivering executive-ready Power BI dashboards and guiding strategic data initiatives.

Qualifications

• 10+ years of experience in Supply Chain, Procurement, Fleet, Operations, IT, or related field.
• Ability to develop and optimize complex SQL queries across multiple data sources.
• Experience building executive-ready dashboards and data models.

Responsibilities

• Develop and optimize complex SQL queries across multiple data sources.
• Build and maintain data warehouse tables and data models.
• Use Python for data transformation, automation, and analytics.
• Leverage AI tools to improve data analysis and reporting.
• Build executive-ready Power BI dashboards and reports.
• Analyze data to identify trends, anomalies, and business opportunities.
• Partner with stakeholders and lead cross-functional initiatives.
• Provide guidance, mentoring, and subject matter expertise.

Skills

SQL

Python

Power BI

Data Modeling

Data Warehousing

AI/Analytics

Job description

We are looking for a senior data analytics professional to develop advanced reporting, data models, and executive dashboards. This role will work closely with cross-functional teams to turn business needs into actionable insights and provide strategic data expertise.

Key Responsibilities:

• Develop and optimize complex SQL queries across multiple data sources.
• Build and maintain data warehouse tables and data models.
• Use Python for data transformation, automation, and analytics.
• Leverage AI tools to improve data analysis and reporting.
• Build executive-ready Power BI dashboards and reports.
• Analyze data to identify trends, anomalies, and business opportunities.
• Partner with stakeholders and lead cross-functional initiatives.
• Provide guidance, mentoring, and subject matter expertise.

Experience: 10+ years in Supply Chain, Procurement, Fleet, Operations, IT, or a related field.

Key Skills:

SQL | Python | Power BI | Data Modeling | Data Warehousing | AI/Analytics