Data Analysis & Analytics Specialist

Summary

Our mission is to find and reveal the truth. Through analytics, automation, and optimization, our small, high-performing team brings transparency and foresight to Trimark operations.

We are seeking a skilled professional with a background in business intelligence development and predictive analytics and an eye for elegant UI/UX.

If you are an active listener, creative problem solver, and critical thinker with a penchant for making aesthetic and intuitive tools, we want to hear from you.

Key Responsibilities

Power BI Development & Data Analytics

• Develop clean and compact ETL pipelines using SQL, PowerQuery (M), and DAX to support nimble data modeling.
• Design, build, and optimize Power BI reports and dashboards for various business units.
• Optimize datasets, query folding, relationships, and incremental refresh strategies.
• Troubleshoot and fix existing reports while improving performance and usability.
• Train business users in effective report usage and self-service analytics.

API and Data Flows

• Manage data imports, transformations, and integrations between ERP, HR, Task Tracking, and Time Tracking.

• Leverage Microsoft LogicApps and Azure Data Factory to integrate data across platforms.

Required Qualifications

• 3+ years of hands-on Power BI expertise
• Robust knowledge of SQL, M, DAX and HTML.
• Experience building data models, managing relationships, and implementing best practices for report performance.
• Strong anticipatory problem-solving, analytical, and communication skills.
• Ability to work cross-functionally and interdepartmentally with accounting, operations, and business stakeholders.
• Can translate what people say into what they really need.
• Can see the big picture and the details simultaneously.
• A listen first, talk second mindset.
• Self-starter.

Preferred Qualifications

• Languages
  • Python
  • JavaScript
• Tools
  • SSIS
  • Azure Data Factory
  • Azure AI Document Intelligence
  • Microsoft Logic Apps
  • RAG-based AI (LlamaIndex/LangChain)
  • RESTful services
• An interest in exploring the data visualization space for market leading ML/AI tools