Senior Business Intelligence Analyst

The Senior Business Intelligence Analyst plays a critical role in enabling data-driven decision making across manufacturing, commercial, and go-to-market operations. This role is responsible for transforming complex enterprise data—spanning sales, pricing, customer, operations, and supply chain—into trusted insights that improve sales effectiveness, operational performance, and business execution. Partnering closely with Sales Effectiveness, Commercial Operations, Manufacturing, Finance, and IT, this role designs and delivers scalable analytics solutions using the Microsoft Fabric and Power Platform ecosystem. The ideal candidate combines strong analytical and data modeling expertise with a deep understanding of how analytics support revenue growth, margin optimization, forecasting accuracy, and execution discipline in a manufacturing environment. This position is hands-on, business-facing, and outcome-oriented, with accountability for building governed semantic models, delivering executive-ready reporting, and enabling self-service analytics across the enterprise. Key Responsibilities: Enterprise & Commercial Analytics: • Design, develop, and maintain enterprise-grade dashboards and reports in Power BI that support Sales Effectiveness, Commercial Operations, Manufacturing, and Executive Leadership • Translate business questions related to sales performance, pipeline health, pricing, customer behavior, demand planning, and operational efficiency into scalable analytics solutions • Perform advanced analysis to identify performance drivers, trends, risks, and opportunities across revenue, margin, and operational KPIs • Support Sales Effectiveness initiatives including CRM analytics, pipeline reporting, quota and performance tracking, customer segmentation, and GTM execution insights Data Modeling & Microsoft Fabric: • Build and maintain semantic models using dimensional modeling best practices (star • schemas, fact/dimension design) to support consistent enterprise reporting • Develop and optimize DAX measures and calculations for accuracy, scalability, and performance • Design and manage data pipelines using Microsoft Fabric components such as Lakehouse, Dataflows Gen2, and related Fabric services • Partner with Data Engineering and IT to align BI solutions with the enterprise data architecture and roadmap AI & Advanced Analytics Enablement: • Design AI-ready datasets and semantic models • Support AI integration within Microsoft Fabric and Power Platform • Promote responsible AI usage and data traceability • Identify opportunities for AI-driven insights and automation Data Governance, Quality & Performance: • Ensure data quality, reliability, and consistency through validation, testing, monitoring, and issue resolution • Implement and support Power BI and Power Platform governance standards, including workspace design, security, and deployment practices • Optimize Power BI reports and models for performance, usability, and scalability in a large, multi-domain enterprise environment • Document datasets, business logic, KPIs, and reporting definitions to promote transparency, adoption, and long-term maintainability Collaboration & Leadership: • Act as a trusted analytics partner to business stakeholders, bridging technical solutions with operational and commercial needs • Collaborate cross-functionally with Sales Effectiveness, Manufacturing, Finance, Supply Chain, and Digital teams • Provide guidance, coaching, and informal mentorship to junior analysts or BI developers as needed • Contribute to the evolution of enterprise analytics maturity, standards, and best practices Qualifications Required: • Bachelor’s or Master’s degree in Data Analytics, Information Systems, Computer Science, • Statistics, Business Analytics, or a related field • Strong proficiency in SQL for querying, transforming, and analyzing large datasets • Extensive hands-on experience developing Power BI reports and dashboards • Advanced experience writing and optimizing DAX measures • Proven experience designing dimensional and semantic data models • Solid understanding of ETL / ELT processes and modern data pipeline concepts • Experience working with enterprise data platforms (Microsoft Fabric, Azure data services, or modern data warehouses) • Strong analytical and problem-solving skills with the ability to translate business problems into structured analytics • Ability to clearly communicate insights to both technical and non-technical audiences • High attention to detail with a strong focus on data quality, governance, and accuracy Preferred: • Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Dataflows Gen2, Notebooks) • Experience supporting or implementing Power BI / Power Platform governance, including security models and deployment pipelines • Experience in manufacturing, medical device, dental, or industrial environments • Experience supporting sales, commercial operations, pricing, or revenue analytics • Familiarity with Azure services such as Azure Synapse, Azure Data Factory, or Azure Data Lake • Experience using Python, R, or similar languages for advanced analytics • Experience working in Agile or analytics engineering teams • Familiarity with version control, CI/CD, or BI deployment processes Technology Environment: • Microsoft Fabric • Power BI • Power Platform • SQL • DAX • Enterprise Data Warehousing • Dimensional & Semantic Data Modeling • AI-enabled analytics Salary/Rate: $50-$65/HR (depends on experience level). This is a contract position with candidates expected to work 40 hours/ week. About The Company Peterson Technology Partners (PTP) is an Equal Opportunity Employer committed to creating a transparent, inclusive, and human-centered hiring experience. For more than 28 years, PTP has operated as one of the top IT staffing and recruiting firms in the USA—built on trust, long-term partnerships, and technical excellence. Based in the Chicago suburb of Park Ridge, IL, our team of more than 500 employees and consultants is dedicated to: Helping every client make the best hiring decisions possible Matching professionals with the right IT jobs and career opportunities As part of that commitment, we believe in providing clear information about how our hiring technologies work and how your data is used. The following section outlines our AI-assisted interview process and your rights as a candidate. AI-Assisted Interview Experience (Pete & Gabi – Rebecca) To provide a consistent, fair, and flexible experience for all candidates, we use AI-assisted tools to support parts of the interview process. This includes our proprietary AI platform Pete & Gabi, which includes AI recruiter Rebecca. These AI hiring tools help us: • Transcribe interviews • Summarize candidate responses • Generate job-related insights • Streamline communication and scheduling Please note that: The AI does NOT make hiring decisions; all decisions are made by our human recruiters, hiring managers, or client partners. The AI does not evaluate facial expressions, emotions, or physical traits; it is used only to support fairness, consistency, and efficiency. If you prefer a non-AI interview format, we will gladly provide an alternative. Technical or Case Interviews (Role-Dependent): When applying for certain tech jobs, you may participate in: • A technical interview • A coding challenge • A case study • A client-specific assessment We will always explain what to expect in advance so you can prepare with confidence. Human Review & Selection: Every candidate's profile—including interviews, conversations, and assessments—is reviewed by experienced recruiters and hiring leaders. AI insights may assist with organization and evaluation, but final decisions are always human-driven. Your Rights as a Candidate: At PTP, every candidate has the right to: Request a non-AI interview path Ask how your data is being used Request access to transcripts or interview recordings Request deletion of your AI-recorded interview Receive clear, timely communication Our goal is to ensure you feel respected, informed, and supported throughout your experience. Our Commitment: For more than 28 years, PTP has focused on putting people first—candidates, consultants, employees, and clients. We're committed to a hiring process that is: • Transparent • Compliant • Equitable • Powered by innovative technology that enhances—not replaces—human judgment Welcome to the future of hiring at Peterson Technology Partners. We're excited to learn more about you. Equal Employment Opportunity: Peterson Technology Partners is an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, national origin, gender identity, sexual orientation, disability, veteran status, or any other protected characteristic.