Senior Data and Analytics Engineer

Position: Senior Data and Analytics Engineer Organization: Cobalt Service Partners – Alpine Investors Portfolio Company – (https://cobaltsp.com) Location: Flexible (Remote within the U.S.) Reports To: EVP, Transformation Cobalt Service Partners Overview Cobalt Service Partners is a private equity–backed platform building the leading commercial access and security integration business in North America. Our partner companies design, install, and service mission-critical systems including access control, video surveillance, intrusion detection, and related low-voltage infrastructure for enterprise, institutional, and commercial customers. Backed by Alpine Investors, a private equity firm specializing in middle-market companies in the services and software industries with $15B+ in AUM, Cobalt has scaled rapidly since launch. With more than 40 acquisitions completed in a highly fragmented operating environment, Cobalt is building a differentiated, data-driven platform designed to scale through both organic growth and M&A. Cobalt’s Core Values Are • Unwavering stewardship: We believe advancing founders’ legacies is a privilege. We do right by our founders, teams, and customers in good times and in bad. • Excellence in action: We hold ourselves accountable to the highest standards. We’re bold in our pursuits, don’t make excuses, and relentlessly empower each other to get the job done. • Seek and tell the truth: We’re honest with ourselves and others. We do what we say we’ll do, say what needs to be said, and search for the right answer regardless of where it comes from. • Love learning: We’re always learning as individuals, as a team, and as a business. We show up humble, curious, and with the courage to change our minds. • Enjoy the ride: We’re fired up by our mission, love our team, and don’t take either for granted. We show up authentically, assume best intent, and try not to take ourselves too seriously. Position Overview The Senior Data and Analytics Engineer will own the transformation and semantic layer of the company’s enterprise data platform. This role is responsible for designing, building, and maintaining scalable dimensional models and curated datasets within Snowflake that power financial and operational reporting across all operating companies. This is a hands-on engineering role for someone who lives in SQL and dbt, thinks deeply about data grain and business logic, and takes pride in building clean, reliable reporting infrastructure. The role translates business requirements into well-structured data models and ensures that enterprise metrics are accurate, documented, and trusted. Key Responsibilities • Dimensional Modeling & Semantic Layer Ownership: Design and maintain scalable fact and dimension models, define grain, and implement enterprise metric logic using SQL and dbt within Snowflake. • Data Transformation & Quality: Develop, test, and optimize transformation workflows to ensure clean, reliable, and performant datasets that support financial and operational reporting. • Business Logic Translation: Partner with Finance and Operations to translate business requirements into technical models, ensuring metric definitions are accurate and consistently applied. • Validation & Reconciliation: Establish validation checks and reconciliation processes to ensure reporting outputs tie to source systems and financial statements. • BI Enablement: Publish curated datasets and support dashboards in Sigma or Power BI, enabling self-service analytics while maintaining governance standards. • Collaboration with Data Engineering: Work closely with internal or external data engineering resources to define schema expectations, monitor ingestion quality, and resolve upstream data issues. Qualifications • 4+ years of experience in analytics engineering, data engineering, or business intelligence engineering roles • Advanced SQL skills with daily hands-on experience building complex transformations • Strong experience with dbt and modern ELT workflows • Deep understanding of dimensional modeling (fact/dimension design, grain definition, star schemas) • Experience working in Snowflake or similar cloud data warehouse environments • Experience building reporting infrastructure (not primarily ML/data science focused) • Strong understanding of financial and operational reporting concepts • Experience in high-growth, multi-entity, or PE-backed environments preferred Core Competencies • Technical Rigor: Writes clean, efficient SQL and builds well-structured, scalable models • Logical Systems Thinking: Understands data grain, relationships, and how business logic translates into dimensional architecture • Data Quality Discipline: Proactively validates outputs and ensures reporting accuracy • Business Translation: Converts operational and financial requirements into precise, reusable technical logic • Ownership Mentality: Takes responsibility for the reliability and integrity of the semantic layer Compensation and Timing Compensation will be competitive and commensurate with experience. Cobalt offers a comprehensive benefits package including healthcare, 401(k) match, and flexible time off. Cobalt is looking to add this role in the near term as a critical investment in the company’s future. Apply tot his job Apply To this Job