Data Analytics Engineer II

Who We Are

OpenEye, the cloud video platform company, provides solutions for video security, business intelligence and loss prevention. For over 20 years, OpenEye has been committed to developing an easy-to-use, comprehensive video management system backed by Heroic Customer Service® and support. Our on-site and cloud-based products can be found protecting schools, hospitals, banks, retail stores, and other facilities around the world. OpenEye’s solutions are available globally through a trusted network of certified service providers. OpenEye is a subsidiary of Alarm.com. Learn more at www.openeye.net.

Job Summary

OpenEye is seeking an Analytics Engineer II to join our Data Platform Team, a group dedicated to ensuring that enterprise data is accurate, reliable, and usable for AI, analytics, and business decision-making.

Working as a core member of the Data Platform Team, the Analytics Engineer will champion data cleanliness, modeling, and accessibility across the organization. You will transform complex, raw data into structured, business‑ready datasets that power everything from AI‑enabled features to product analytics and Customer Success insights. This work includes investigating and resolving data anomalies, restructuring or labeling data as needed, identifying and driving the capture of missing data points, and preparing AI‑ready datasets to support prompt engineering and model optimization.

In addition to core analytics engineering responsibilities, this position plays an important role in facilitating the data and analysis needs of the Customer Success organization, supporting high‑value reporting and analytics initiatives that ensure the enterprise operates from consistent, trusted, and well‑structured data.

Role And Responsibilities

• Design, build, and maintain analytics‑ready data models that support AI, product, and reporting needs
• Apply consistent business logic, definitions, and transformations to ensure a single source of truth
• Optimize data transformations for performance, scalability, and maintainability
• Create and maintain documentation for datasets, models, and transformation logic
• Ensure the accuracy, completeness, and reliability of key datasets across the enterprise
• Collaborate with Database Engineers on schema design, indexing strategies, and governance standards
• Implement and maintain data quality checks, validation rules, and monitoring processes
• Work with engineering, product, AI, and business teams to understand requirements and deliver high‑value datasets
• Partner with Customer Success, Product, and analytics stakeholders to ensure datasets meet operational and strategic needs
• Support the AI Engineering and Enablement team by preparing AI‑ready datasets for copilots, agents, prompt engineering, and other AI solutions
• Enhance ingestion pipelines and collaborate on data integration projects to improve data availability and quality
• Support teams using Power BI, including designing optimized datasets and collaborating on semantic model design to ensure consistent metrics and reporting
• Contribute to the ongoing evolution of Data Platform Team practices, tools, and standards
• Stay current with industry trends in analytics engineering, integration, semantic modeling, and AI data readiness
• Identify opportunities to improve data workflows, reduce technical debt, and accelerate time‑to‑insight
• Other duties as assigned.  

Qualifications

• Bachelor's degree in Computer Science, Data Engineering, Analytics, or a related field
• 2–5 years of professional experience
• Advanced SQL skills and experience with relational databases such as MySQL, PostgreSQL, or MSSQL
• Proven experience in building and maintaining analytics ready data models and transformations
• Hands-on experience with BI tools such as PowerBI or Tableau
• Ability to quickly learn new technologies and practices
• Excellent critical thinking and problem-solving skills
• Strong quality ethic and test-first attitude
• Great communication and teamwork skills

Please note that sponsorship of new applicants for employment authorization, or any other immigration-related support, is not available for this position at this time.

The Perks!

• The pay range for this opportunity is $90,000 - $125,000 annually. In addition, this position is eligible for an annual discretionary bonus. 
• Employees are eligible to purchase company stock at a discounted rate
• Collaborative, fun, creative culture where idea sharing is encouraged
• Casual dress (Jeans are welcome!)
• Medical, dental, vision & prescription benefits starting day 1! Generous medical plan subsidy and health savings account option with company contribution helps keep your costs low.
• Up to $5,000 annual company match for 401k
• Company paid short-term/long-term disability, AD&D and life insurance
• Paid maternity and paternity leave
• 15 Days of Paid Vacation accrued per year (increases after year 3)
• 7 Paid Sick/Wellness days per year
• 9 Paid Holidays per year
• This position is eligible for a flexible hybrid work schedule
• Educational Assistance Program covering non-degree support, undergraduate and graduate degrees
• Employee Equipment Program – Free Alarm.com system for your home!

OpenEye is an Equal Opportunity Employer

In connection with your application, we collect information that identifies, reasonably relates to or describes you (“Personal Information”). The categories of Personal Information that we may collect include your name, government-issued identification number(s), email address, mailing address, other contact information, emergency contact information, employment history, educational history, criminal record, and demographic information.  We collect and use those categories of Personal Information about you for human resources and other business management purposes, including identifying and evaluating you as a candidate for potential or future employment or future positions, recordkeeping in relation to recruiting and hiring, conducting criminal background checks as permitted by law, conducting analytics, and ensuring compliance with applicable legal requirements and Company policies.  By submitting your application, you acknowledge that we may retain some of the personal data that you provide in your application for our internal operations such as managing our recruitment system and ensuring that we comply with labor laws and regulations even after we have made our employment decision.

Notice To Third Party Agencies:

Alarm.com understands the value of professional recruiting services.  However, we are not accepting resumes from recruiters or employment agencies for this position. In the event we receive a resume or candidate referral for this position from a third-party recruiter or agency without a previously signed agreement, we reserve the right to pursue and hire those candidate(s) without any financial obligation to you. If you are interested in working with Alarm.com, please email your company information and standard agreement to RecruitingPartnerships@Alarm.com.

Jr105380

#Li-Rc1

#Li-Hybrid

The salary range of this opportunity is listed below and is determined within a range based on factors including qualifications, location and experience.  This allows opportunity for growth and development within the role.  The salary offered is part of a total compensation package.  

Pay Range$90,000—$125,000 USD