Senior Data and Solutions Engineer

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 SitelogIQ’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. 

Senior Data and Solutions Engineer Responsibilities: 

Data Engineering & Integration 

• 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. 

Data Modeling & Analytics 

• 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. 

Reporting & BI Governance 

• 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. 

Data Quality & Governance Support 

• 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. 

Stakeholder Collaboration 

• 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. 

Senior Data and Solutions Engineer Qualifications: 

• 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 modeling (star/snowflake), and best practices for handling structured and unstructured data. 

• Experience implementing data governance, metadata/catalog solutions, and data lineage. 

• Familiarity integrating ERP (Acumatica), project systems (Procore), CRM (Pipedrive), HRIS (UKG), or equivalent enterprise systems preferred. 

• Experience with modern ETL/ELT tooling, data orchestration (e.g., Azure Data Factory, Synapse pipelines, or equivalents), and pipeline monitoring. 

• Excellent stakeholder management and communication skills—able to partner with executives and technically lead engineering teams. 

No agencies please 

Benefits 

We offer a highly competitive salary, and comprehensive benefits, including: 

• Medical, dental, and vision insurance 

• Disability and life insurance 

• 401K 

• Flex time off 

• 12 paid holidays 

• Tuition reimbursement 

• Opportunities to drive our DE&I efforts by joining our affinity groups, Veterans and Allies Leadership Organization or Women Inspiring & Strengthening Everyone 

• Opportunities to give back to our local communities through organized events or fundraisers 

More About SitelogIQ 

At SitelogIQ, we’re focused on creating a great environment for our team first so that it is more energizing and rewarding to focus on creating a great customer experience. That’s what we call a win-win.  

We partner with clients in K-12, higher ed, government, healthcare, multifamily housing, and industry to optimize energy efficiency, improve indoor air quality, address lighting, and improve the customer experience. With offices across the country, it’s rewarding to make a difference in the communities where our teammates live and work. 

SitelogIQ is an Equal Opportunity Employer and participates in E-Verify. 

#LI-JH1