Senior Data Analyst

Bloom Consulting Services; Dublin (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Bloom Consulting Services in Dublin, OH is seeking a Senior Data Analyst for a full-time, hybrid role. You will design and maintain Power BI dashboards across operations, finance, and sales, building semantic data models with DAX and implementing RLS to secure data access.

You will write complex SQL against Azure SQL, collaborate with data engineers, and translate business questions into measurable data products while guiding stakeholders through data-driven decisions.

Qualifications

• Bachelor's degree or equivalent experience in a quantitative field.
• 4+ years of professional experience accepted in lieu of degree.
• Industry background in transportation or logistics is a strong plus.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports for operations, finance, sales, and executives.
• Develop semantic data models in Power BI using DAX, including measures, calculated columns, and RLS.
• Analyze and tune reports to improve load times and reliability; establish self-service BI standards.
• Collaborate with data engineers to define data requirements, validate pipeline outputs, and ensure data quality upstream of reporting.
• Partner with department leaders to translate business questions into measurable data products; lead requirements sessions.
• Communicate findings clearly to non-technical audiences; contribute to data-driven strategy.

Skills

Power BI

DAX

RLS

Data modeling

Stakeholder communication

Problem-solving

Adaptability

Education

Bachelor's degree preferred (quantitative field)

Equivalent professional experience (4 years) accepted

Logistics/ transportation industry background a strong plus

Tools

Azure DevOps

Azure SQL

Microsoft Fabric

Power BI deployment pipelines

Job description

Hiring Senior Data Analyst, for a fast paced logistics client of mine. This is a full time, salaried position currently hybrid work environment based in Dublin, Oh. Ideal candidates have strong power BI experience with a passion for data and looking to grow into data engineering / Azure to solve complex problems.

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

• Expert-level Power BI — semantic modeling, DAX (measures vs. calculated columns), RLS, gateways, and deployment pipelines.
• Strong T-SQL — complex queries, CTEs, window functions, query optimization; experience with Azure SQL Database.

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.