Database System Engineer

Full Time
Newport Beach, CA 92659
Posted
Job description

Altura, LLC is a professional services firm focused on improving energy, environmental, and financial performance across all levels of our clients’ organizations. Altura has deep expertise in deriving value from building control systems, scaling from individual buildings to real estate portfolios. We leverage core skills in control system design and programming, engineering, project implementation, data analytics, commissioning, and financial analysis to identify and implement control project optimization at scale in order to achieve meaningful results for our clients.

Altura is actively seeking an individual to join our data analytics team, who will specifically focus on maintaining ontology compliance and databases in our computing environment.

Scope & Responsibilities

  • Work with stakeholders and subject matter experts to codify and maintain tagging ontologies for Altura’s workflows,

  • Enforce tagging ontology compliance on Altura’s databases by:

    • Performing database review and remediation operations to maintain up-to-date tagging,

    • Assisting in designing and deploying ontology management solutions,

    • Providing training to Associates in applying Altura’s tagging ontology,

    • Reviewing and updating strategies to maintain ontology on Altura’s databases,

    • Recognizing and reporting ontology issues to the appropriate stakeholders and subject matter experts.

  • Stay up to date with changes made to popular building tagging ontologies (Brick, Project Haystack, RealEstateCore, Google Digital Buildings, COBIE, etc.)

  • Manage the SkySpark database lifecycle according to best practices:

    • Initial provisioning, stand-up and configuration,

    • Periodic QA reviews (after major milestones and recurring automated reviews)

    • Close-out and archiving

  • Review existing database deployments to flag and/or remediate issues with data connectivity, data outliers, program/rule failures, and inconsistent application of ontologies and other data quality issues.

  • Perform root cause analysis on data quality issues, and work with internal teams to resolve.

  • Develop, test, and train others on database and data quality standards and compliance tools. Assist users on appropriately and consistently deploying databases to meet quality standards.

  • Monitor data quality metrics over time and implement workflow and tooling improvements to meet quality standards. Generate and maintain data quality reports for internal and external audiences. Assist in the development and testing of new applications and features for data quality monitoring, reporting and remediation.

Required Qualifications:

  • 3 years of database engineering experience with NoSQL/Document type databases

  • Strong data analysis skills working with large datasets

  • Working knowledge of one or more of the following ontologies:

    • BrickSchema

    • Project Haystack 3 or 4

    • ASHRAE Standard 223P

    • COBIE

    • RealEstateCore

    • Google Digital Buildings

    • Or similar industries that require tagging-based data models (document or NoSQL databases)

  • Excellent customer service attitude (internal users, external clients, and third parties).

  • Critical thinker and problem-solver.

  • Effective working in a collaborative team environment.

  • Self-starter with natural intellectual curiosity.

  • Strong listening, communication, and writing skills.

Desired Qualifications:

  • Working knowledge of the SkySpark Folio database.

  • Experience with time series trend data

  • Experience in building facilities maintenance or building automation controls software

Location:

Newport Beach (Preferred), or a hybrid or remote (within the U.S.) candidate will be considered.

About Altura:

Altura is proud to offer a generous total compensation package that includes base salary, bonus potential, and a comprehensive benefit package that includes health benefits (medical and dental plans), paid time off (vacation, sick and holiday), financial benefits (retirement plan with both match and annual company contribution, life insurance, short- and long-term disability, and commuter benefits).

Additional benefits include fitness reimbursement, healthcare and dependent care pre-tax spending plans, tuition reimbursement, back-up daycare and family support benefits, EAP, work life assistance and a holiday contribution program. Base salaries will be determined by factors such as geographic location, education, skills, experience, and market considerations. For this role the annual base salary range is $100,000 - $135,000.

We pride ourselves on our company’s unique entrepreneurial, high-energy culture and flat organizational structure which empowers employees to take action and achieve results for our clients.

#LI-Hybrid

jackharris.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jackharris.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jackharris.com is the ideal place to find your next job.

Intrested in this job?

Related Jobs

All Related Listed jobs