Qureos Mentor

veritis group inc

Position - Project Director and Lead Research ConsultantLocation - 25 W. 43rd Street, Suite 1000, New York, NY 10036 (College Satellite Location)Duration: 560 hours for this position.Term &ndash; one (1) calendar year to commence after the issuance of a Purchase Order from the College to the Contractor.Key Activities/Deliverables and Services to be Performed:Working in close collaboration with AAARI leadership and project partners, the Consultant&rsquo;s key activities and deliverables will include, but are not limited to, the following:<ul><li>Serve as Project Director overseeing overall project coordination, workflow, and execution of the statewide AAPI report.</li><li>Manage day-to-day project operations, including timelines, milestones, and deliverables, to ensure compliance with contractual obligations.</li><li>Recruit, coordinate, and support chapter authors and subject-matter experts contributing to the report.</li><li>Conduct, oversee, and synthesize comprehensive literature reviews relevant to AAPI populations in New York State.</li><li>Draft, co-write, and edit selected sections of the report to ensure clarity, consistency, and analytical rigor.</li><li>Oversee data acquisition needs and collaborate closely with the project&rsquo;s data analyst to ensure accurate and appropriate use of quantitative and qualitative data.</li><li>Coordinate with the editor and designer to ensure high editorial quality, visual coherence, and accessibility of the final report.</li><li>Ensure adherence to established research standards, reporting requirements, and project timelines mandated by the New York State AAPI Commission.</li><li>Support final production, review, and submission of the completed statewide report.</li></ul>Qualifications:Individual must meet the following minimum qualifications to be considered for the position:<ul><li>The contractor must possess at least a Master&rsquo;s degree in a relevant field such as public policy, urban planning, public administration, economics, sociology, public health, Asian American studies, or a closely related discipline.</li><li>The contractor must have a minimum of seven (7) years of professional experience in applied research, policy analysis, organizational leadership, or program evaluation related to social equity, population studies, or community-based research.</li></ul>The contractor must also demonstrate experience in the following areas:<ul><li>Leading or directing complex, multi-stakeholder research or policy initiatives, including multi author reports</li><li>Managing organizational or project operations, timelines, and deliverables</li><li>Conducting and synthesizing literature reviews and qualitative and quantitative research</li><li>Drafting and editing written materials for public, policy, and academic audiences</li><li>Coordinating across partners such as academic experts, government agencies, and community organizations</li><li>Equivalent experience may include senior leadership roles in nonprofit organizations, government advisory bodies, or advocacy organizations with demonstrated responsibility for research, policy development, and public reporting.</li></ul>The successful candidate will demonstrate a knowledge of and have practical experience utilizing best practices in research. Contractor must demonstrate excellent communication, critical thinking, problem solving, and multi-tasking are essential skills necessary for this position.Job Type: ContractPay: $50.00 - $70.00 per hourExpected hours: 40 per weekWork Location: In person

Project Director and Lead Research

Exp Level: Min 10+ Years<ul><li>Expert-level proficiency in PySpark and Databricks, DB development tasks (PostgreSQL and Oracle PL/SQL)</li></ul>Primary Skill Focus: PySpark, Databricks, Oracle to PostgreSQL MigrationResponsibilities:1. Database Design &amp; Development:<ul><li>Design and develop robust database solutions that meet data storage and retrieval requirements.</li><li>Create scripts and procedures to automate routine database tasks.</li></ul>2. Migration &amp; Implementation:<ul><li>Lead the migration process from Oracle to PostgreSQL, ensuring data integrity and minimal downtime.</li></ul><ul><li>Develop comprehensive migration plans and execute them proficiently.</li></ul>3. Support &amp; Maintenance:<ul><li>Monitor database performance and implement necessary improvements.</li></ul>4. Reporting &amp; Analytics:<ul><li>Develop and maintain Databricks jobs for generating business reports and analytics.</li></ul><ul><li>Provide insights from data analysis to support decision-making.</li></ul>Skills Required:1. RDBMS Expertise:<ul><li>Strong hands-on experience with Oracle and PostgreSQL databases.</li><li>Deep understanding of database architecture, design, indexing, and performance tuning.</li><li>Expert-level SQL skills: queries, stored procedures, functions, triggers, and views.</li></ul>2. Database Migration<ul><li>Proven experience in end-to-end database migration projects (preferred: Oracle &rarr; PostgreSQL).</li><li>Strong ability to perform data mapping, transformation, validation, and reconciliation.</li><li>Experience using migration tools, scripts, and automation frameworks.</li></ul>3. Data Engineering &amp; Analysis<ul><li>Advanced proficiency in Databricks for large-scale data processing.</li><li>Expert in PySpark and Python for data transformation and analytics.</li><li>Ability to build, enhance, and optimize complex ETL/ELT data pipelines.</li></ul>4. Job Scheduling &amp; Automation<ul><li>Experience creating and maintaining Databricks jobs for scheduled reporting.</li><li>Familiarity with workflow orchestration tools (Airflow, ADF, Step Functions, etc.).</li></ul>5. Performance Optimization<ul><li>Strong background in performance tuning for Oracle and PostgreSQL.</li><li>Experience with index strategies, query optimization, execution plan analysis, and caching.</li></ul>6. Cloud PlatformsGood understanding of AWS Cloud, including RDS, S3, EMR, Lambda, Glue, or similar servicesJob Type: ContractPay: $60.00 - $65.00 per hourExpected hours: 40 per weekWork Location: Hybrid remote in Alpharetta, GA

Database Developer (PySpark + Databricks + Oracle to PostgreSQL Migration

Join veritis group inc and explore 2   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

veritis group inc

ABOUT_COMPANY

Project Director and Lead Research

Database Developer (PySpark + Databricks + Oracle to PostgreSQL Migration