Senior Data and Solutions Engineer

SIQ-MN-Minneapolis / 80 S 8th St / IDS Center, Suite 1850 / Minneapolis, MN 55402, USA

SitelogIQ is a rapidly growing energy and facility services company. We provide planning, design, and management solutions for organizations who want efficient and sustainable building environments that are healthier and safer for their occupants. We offer a highly competitive salary, comprehensive benefits including medical and dental, vision, disability and life insurance, 401K, PTO, tuition reimbursement, and the ability to add value to an exciting mission!

The Senior Data and Solutions Engineer will support Sitelog

IQ’s transition from fragmented reporting to a structured and scalable data and analytics environment. This hands‑on role is responsible for building and maintaining data pipelines, developing governed datasets, and delivering high-quality reporting and insights.

Working closely with the Director of Business Systems, this role contributes to the implementation of a modern data platform and partners with business stakeholders to improve data quality, reporting consistency, and access to actionable insights.

The salary range is $100,000‑$130,000
. The salary may vary within the range based on factors such as location of the role, and a candidate’s experience, knowledge, skills, and abilities.

• Develop, and manage robust data pipelines (ETL/ELT) to seamlessly integrate core enterprise systems such as ERP, CRM, HRIS, and project management platforms.
• Drive the creation and enhancement of a centralized analytical data layer (lake/lakehouse) to support scalable reporting and advanced analytics.
• Leverage Azure tools for efficient data ingestion, orchestration, and pipeline automation, including monitoring and optimizing performance for reliability and scalability.
• Proactively monitor, troubleshoot, and resolve issues in data pipelines to ensure high data availability and quality across all business units.

• Implement, and maintain enterprise data models and semantic layers using best practices for OLTP and OLAP architectures (star/snowflake modeling).
• Develop and optimize Power BI datasets and dashboards to deliver actionable insights and facilitate self‑service analytics for stakeholders.
• Champion the standardization of KPIs and reporting frameworks to ensure consistency and reliability across the organization.
• Translate complex business requirements into scalable and flexible data solutions that empower decision‑making.

• Consolidate fragmented reporting into governed datasets, ensuring data integrity and compliance with enterprise standards.
• Lead Power BI governance, workspace management, and implementation of best practices for security and access controls.
• Enable and support self‑service reporting for business users through robust governance and training, ensuring responsible data usage.

• Establish and enforce data validation, quality checks, and data governance policies to maintain high data standards.
• Document comprehensive data definitions, lineage, and metadata to enhance transparency and traceability throughout the data lifecycle.
• Maintain and promote consistent data standards, naming conventions, and best practices across all projects and systems.

• Engage proactively with business stakeholders to gather requirements, understand reporting needs, and deliver tailored data solutions.
• Drive adoption and continuous improvement of standardized analytics and reporting, providing guidance and support for business users.

• Bachelor’s degree in Information Systems, Computer Science, Data Science, or related field.
• 5+ experience in data engineering, analytics, or enterprise data architecture roles; demonstrable leadership of cross‑system programs.
• Hands‑on experience with Microsoft Dataverse and Microsoft Power Platform; proven experience designing and deploying analytical data layers using Azure data services (Synapse, Data Lake Storage, Fabric or equivalent).
• Strong understanding of both OLTP and OLAP architectures, data…