Apache Calcite Consultant
Vaco | |
$70.00 - $80.00 / hr | |
United States, Ohio, Columbus | |
Nov 19, 2024 | |
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 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.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco depends upon a wide array of factors including but not limited to:
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. |