Apache Calcite Consultant at Vaco, LLC
Columbus, OH
About the Job
Apache Calcite Consultant
Columbus, OH (100% remote)
Contract
Pay Range: $70-$80/hr
Project Overview
This project aims to implement a semantic layer over multiple disparate data sources—Epicor, Shop Floor Connect, and Visibility—by leveraging Apache Calcite's schema discovery capabilities
The semantic layer will provide a unified, business-friendly view of the data, simplifying data access for end-users such as sales representatives, managers, and analysts.
Project Objectives
• Automatic Detection of Data Structures: Utilize Apache Calcite's schema
discovery to automatically understand the structure of the underlying databases,
reducing manual ePort.
• Unified View of Disparate Systems: Create a unified logical schema that integrates data from Epicor, Shop Floor Connect, and Visibility.
• Mapping Business Concepts to Data: Map business concepts onto the underlying technical data structures to build a semantic layer.
• Simplifying Query Creation and Optimization: Provide an easy-to-use interface for querying data without needing technical knowledge.
• Federated Queries Across Multiple Data Sources: Enable retrieval and joining of
data from different databases in a single query.
• Enhancing Flexibility and Scalability: Ensure the semantic layer adapts dynamically to changes in the underlying data schemas.
Project Scope
• Data Sources:
o Epicor: Sales and financial data.
o Shop Floor Connect: Production data.
o Visibility: Business intelligence and reporting data.
• Technologies: Apache Calcite, database connectors, and ETL tools as needed.
• Deliverables: Operational semantic layer, documentation, training materials, and
deployment plans.Vaco values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco LLC and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals
As part of this commitment, Vaco LLC and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations
If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact
Vaco also wants all applicants to know their rights that workplace discrimination is illegal
By submitting to this position, you agree that you will be giving Vaco the exclusive right to present your as a candidate for the foregoing employment opportunity
You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications
You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application
In exchange, Vaco agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco LLC and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco”) respects your privacy and are committed to providing transparent notice of our policies
California residents may access Vaco’s HR Notice at Collection for California Applicants and Employees here.
Virginia residents may access our state specific policies here.
Residents of all other states may access our policies here
Canadian residents may access our policies in English here and in French here.
Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco depends upon a wide array of factors including but not limited to:
the individual’s skill sets, experience and training;
licensure and certification requirements;
office location and other geographic considerations;
other business and organizational needs.
With that said, as required by local law, Vaco believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure
The individual may also be eligible for discretionary bonuses.
Columbus, OH (100% remote)
Contract
Pay Range: $70-$80/hr
Project Overview
This project aims to implement a semantic layer over multiple disparate data sources—Epicor, Shop Floor Connect, and Visibility—by leveraging Apache Calcite's schema discovery capabilities
The semantic layer will provide a unified, business-friendly view of the data, simplifying data access for end-users such as sales representatives, managers, and analysts.
Project Objectives
• Automatic Detection of Data Structures: Utilize Apache Calcite's schema
discovery to automatically understand the structure of the underlying databases,
reducing manual ePort.
• Unified View of Disparate Systems: Create a unified logical schema that integrates data from Epicor, Shop Floor Connect, and Visibility.
• Mapping Business Concepts to Data: Map business concepts onto the underlying technical data structures to build a semantic layer.
• Simplifying Query Creation and Optimization: Provide an easy-to-use interface for querying data without needing technical knowledge.
• Federated Queries Across Multiple Data Sources: Enable retrieval and joining of
data from different databases in a single query.
• Enhancing Flexibility and Scalability: Ensure the semantic layer adapts dynamically to changes in the underlying data schemas.
Project Scope
• Data Sources:
o Epicor: Sales and financial data.
o Shop Floor Connect: Production data.
o Visibility: Business intelligence and reporting data.
• Technologies: Apache Calcite, database connectors, and ETL tools as needed.
• Deliverables: Operational semantic layer, documentation, training materials, and
deployment plans.Vaco values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco LLC and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals
As part of this commitment, Vaco LLC and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations
If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact
HR@vaco.com
.Vaco also wants all applicants to know their rights that workplace discrimination is illegal
By submitting to this position, you agree that you will be giving Vaco the exclusive right to present your as a candidate for the foregoing employment opportunity
You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications
You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application
In exchange, Vaco agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco LLC and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco”) respects your privacy and are committed to providing transparent notice of our policies
California residents may access Vaco’s HR Notice at Collection for California Applicants and Employees here.
Virginia residents may access our state specific policies here.
Residents of all other states may access our policies here
Canadian residents may access our policies in English here and in French here.
Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco depends upon a wide array of factors including but not limited to:
the individual’s skill sets, experience and training;
licensure and certification requirements;
office location and other geographic considerations;
other business and organizational needs.
With that said, as required by local law, Vaco believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure
The individual may also be eligible for discretionary bonuses.
