Business Intelligence Coordinator

Job Title: Business Intelligence & Market Insights Coordinator

Location: Overland Park, KS (66210)

Schedule: Monday-Friday (On-site)

Pay: $70,000 - $90,000

Duration: Direct Hire

***DO NOT APPLY IF YOU DO NOT HAVE DIRECT EXPERIENCE WITH UTILITIES, ENERGY, POWER DELIVERY, TRANSMISSION & DISTRIBUTION, SUBSTATIONS, OR EPC INDUSTRIES***

About the Role

This role sits at the intersection of business operations, market intelligence, forecasting, and analytics support. The ideal candidate will bring prior experience within the utilities, power delivery, transmission & distribution (T&D), or energy infrastructure industries and possess strong organizational and analytical capabilities.

This position supports the Market Strategy and Sales teams by researching, tracking, and maintaining assigned regional data and documentation. This role focuses on data quality, CRM hygiene, pipeline coordination, and basic reporting support. The Coordinator builds strong working relationships across the organization and ensures information flows smoothly so the team can make timely, informed decisions.

Key Responsibilities

• Develop, maintain, and deliver data inputs that accurately feed dashboards, reports, and trackers owned by the BI Manager or Analyst.
• Serve as a collaborative business partner, building strong working relationships with stakeholders across Sales, Operations, and Market Strategy.
• Partner with Sales to capture opportunity updates, next steps, contacts, and activities; ensure pipeline data accuracy and timeliness in the CRM.
• Facilitate recurring pipeline review prep (agendas, action logs, follow‑ups) and complete timely CRM updates, ensuring clear ownership and documentation of next steps.
• Act as a liaison for information flow between Market Strategy and Sales, ensuring market intel and status updates are clearly tracked and organized.
• Monitor RTO/ISO sources (e.g., website postings, queues, schedules) to collect and catalog relevant documents and updates for review by the Analyst/Manager.
• Summarize basic findings (what changed, links, dates) for handoff to the Analyst/Manager to interpret and convert into insights.
• Use Excel to perform data entry, cleaning, formatting, lookups, and basic pivot tables to support pipeline and market trackers.
• Maintain trackers and libraries (SharePoint/Teams/Drive) to ensure version control, naming conventions, and accessibility.
• Support simple market research tasks (e.g., pulling schedules, compiling contacts, logging events) for growth initiatives and key accounts.
• Perform quality checks for data accuracy, consistency, and completeness across assigned reporting inputs.
• Support preparation of basic summaries or lists for leadership readouts (the BI Manager/Analyst will synthesize and present insights).
• Proactively identify process improvements to make updates faster, cleaner, and more reliable.

Required Qualifications

• Proficiency with Excel (sorting, filtering, basic formulas, data cleaning; pivot tables a plus).
• Hands‑on experience with a CRM (Salesforce, Microsoft Dynamics, or HubSpot) for data entry, updates, and pipeline hygiene.
• Strong organization and attention to detail; comfortable managing trackers, versions, and documentation.
• Clear, professional communication and dependable follow‑through across teams.
• Growth mindset with the ability to take ownership, learn quickly, and navigate a large, matrixed organization.
• Interest in BI/market strategy and willingness to learn RTO/ISO basics over time.

Preferred Qualifications

• Exposure to Power BI or similar visualization tools (viewing and refreshing reports; advanced build skills not required).
• Experience supporting Sales, Operations, or Strategy teams.
• Familiarity with RTO/ISO planning processes (PJM, MISO, SPP, ERCOT, CAISO, NYISO, ISO‑NE) or a desire to learn quickly.
• Ability to manage multiple tasks and deadlines in a fast‑paced environment.

Compensation & Benefits

• Competitive Compensation
• 401(k) Retirement Plan
• Holiday Pay
• Paid Time Off (PTO)
• Comprehensive Health Coverage
• Pet Insurance
• Employee Assistance Program (EAP)
• Professional Development
• Tuition Assistance
• Employee Discount Program