Senior Data Analyst

EASE LOGISTICS SERVICES LLC; Dublin (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

EASE LOGISTICS SERVICES LLC in Dublin, OH is seeking an experienced BI Analyst to design and optimize Power BI dashboards for operations, finance and executive leadership.

You will build semantic data models in DAX, write complex T-SQL against Azure SQL, collaborate with data engineers to ensure data quality, and translate business questions into measurable data products for timely reporting.

Qualifications

• 4+ years in BI, data analytics, or reporting.
• Expert Power BI with semantic modeling and DAX.
• Strong T-SQL skills with Azure SQL Database.
• Experience with multi-source operational data and data quality.

Responsibilities

• Design, build, and maintain Power BI dashboards for operations, finance, sales, and executives.
• Develop semantic data models in Power BI using DAX and implement RLS.
• Tune reports for performance and reliability; document standards.
• Collaborate with data engineers to define data requirements and validate pipelines.
• Partner with leaders to translate questions into measurable data products.
• Participate in sprint planning and analytics tooling workflows.

Skills

Power BI

DAX

RLS

T-SQL

Azure SQL

Azure Synapse

Microsoft Fabric

Python

Git

Azure DevOps

Data modeling

Education

Bachelor's degree preferred in a quantitative field

Equivalent professional experience accepted

Tools

Azure DevOps

Git

Microsoft Fabric

Job description

Job Details

Level: Experienced

Job Location: CMH Operations Terminal - Dublin, OH 43016

Position Type: Full Time

Essential Duties

Reporting & Dashboard Development

• Design, build, and maintain Power BI dashboards and reports for operations, finance, sales, and executive stakeholders.
• Develop and manage semantic data models in Power BI using DAX, including measures, calculated columns, and row-level security (RLS).
• Analyze and tune underperforming reports and queries to improve load times and reliability.
• Establish and document self-service BI standards and a shared metrics catalog.

Data & SQL

• Write complex T-SQL queries, CTEs, window functions, multi-table joins against Azure SQL and Microsoft Fabric.
• Collaborate with data engineers to define data requirements, validate pipeline outputs, and ensure data quality upstream of reporting.
• Identify data anomalies and inconsistencies; work upstream to resolve at the source rather than patching in reports.

Stakeholder Collaboration

• Partner with department leaders across operations, finance, and customer experience to translate business questions into measurable data products.
• Lead requirements-gathering sessions and translate ambiguous requests into defined scopes with clear deliverables and timelines.
• Communicate findings clearly to non-technical audiences - written, visual, and verbal.
• Contribute to special projects, operational improvement initiatives, and data-driven strategy efforts.

Team & Process

• Recommend and implement process improvements within the analytics function.
• Uphold data governance, security, and confidentiality standards across all reporting environments.
• Participate in sprint planning and contribute to team workflows using Azure DevOps or equivalent tooling.

Qualifications

Education

• Bachelor's degree preferred in a quantitative field (Computer Science, Statistics, Mathematics, Information Systems).
• Equivalent professional experience (4+ years) accepted in lieu of degree.
• Transportation or logistics industry background is a strong plus.

Experience

• Required- 4+ years of hands-on experience in a BI, data analytics, or reporting analyst role.
• Required- Expert-level Power BI - semantic modeling, DAX (measures vs. calculated columns), RLS, gateways, and deployment pipelines.
• Required- Strong T-SQL - complex queries, CTEs, window functions, query optimization; experience with Azure SQL Database.
• Required - Proven ability to work with messy, multi-source operational data - not just clean, pre-modeled datasets.
• Preferred - Experience with Microsoft Fabric, Azure Synapse Analytics, OneLake architecture and Fabric lakehouses or warehouses or comparable cloud data platform.
• Preferred - Direct experience with McLeod TMS data preferred (orders, loads, lanes, drivers, invoicing).
• Preferred - Experience in logistics, transportation, supply chain, or a similarly operations-heavy industry.

Knowledge, Skills, & Abilities

• Ability to communicate complex data findings to non-technical stakeholders clearly and confidently.
• Ability to adapt and work in a fast-paced, operations-heavy environment.
• Strong problem-solving skills; comfortable working with ambiguous or incomplete requirements.
• Experience with ADF or analytics engineering practices for building and testing data models preferred.
• Python or R for exploratory analysis and data prep preferred.
• Azure DevOps or Git-based version control for BI asset deployment preferred.
• Power BI Premium / Fabric capacity management, workspace governance, and admin experience preferred.