Data & Reporting Analyst — QuickBase​/Power BI

Location: Hartford, CT / Remote within the U.S.

Work Hours: Primarily aligned with U.S. Central business hours

Employment Type: Contract
Position Summary

We are seeking a hands-on Quick Base expert to support Clinical Vendor Governance in building a new, user-friendly Quick Base vendor lifecycle management platform . The ideal candidate will have strong hands-on Quick Base development/configuration experience, along with Power BI reporting and data remediation skills.

The solution will serve as an end-to-end system of record for the clinical vendor lifecycle, covering vendor intake, governance, contracting, performance tracking, workflow, reporting, and renewals .

The resource will also support the cleanup and migration of information for approximately 800 vendors from the existing Quick Base environment into the newly designed solution.

Key Responsibilities

• Design and build a new Quick Base application supporting the complete clinical vendor lifecycle.

• Configure tables, relationships, forms, fields, roles, permissions, reports, views, and dashboards .

• Build the Vendor Profile as the central record for vendor lifecycle management.

• Develop vendor taxonomy, categorization, tagging, and standardized data structures.

• Create workflows, automations, notifications, and status triggers.

• Connect and integrate with other Quick Base applications where required.

• Explore automation of Microsoft Forms/RFI information into Quick Base .

• Develop administrative documentation, SOPs, and Quick Base runbooks.

• Develop and maintain Power BI dashboards and reports using Quick Base and related data sources.

• Build reporting for vendor pipeline, lifecycle stages, contracting status, governance readiness, and preferred vendor tracking.

• Create data models, DAX measures, visualizations, and scheduled refreshes.

• Improve existing reporting and reduce dependency on manually maintained reports.

• Use Power BI when Quick Base reporting capabilities are insufficient.

• Ensure reporting definitions and metrics are consistent across stakeholders.

• Review and assess existing vendor data for approximately 800 vendors .

• Identify and resolve duplicate records, incomplete information, inconsistent naming, and data-quality issues.

• Clean, standardize, validate, and prepare data for migration.

• Support migration from the existing Quick Base environment to the rebuilt application.

• Perform pre- and post-migration validation and reconciliation.

• Reconcile vendor information across multiple business inventories and sources.

• Establish ongoing data quality, audit, and maintenance processes.

• Create Quick Base user guides, reference materials, and process documentation.

• Maintain data dictionaries, taxonomy definitions, and reporting logic documentation.

• Provide troubleshooting and day-to-day support to business users.

• Gather business requirements and translate them into technical solutions.

• Provide regular status updates and communicate issues or blockers proactively.

Required Skills & Qualifications

• 3 years of experience in data analysis, business intelligence, reporting, application configuration, or a related field.

• Strong hands-on Quick Base experience is mandatory.

• Experience designing and configuring:

• Quick Base tables and relationships

• Forms and fields

• Roles and permissions

• Reports and dashboards

• Automations and workflows

• Hands-on Power BI experience.

• Strong knowledge of DAX, data modeling, visualization, and scheduled refreshes .

• Advanced Microsoft Excel skills, including Pivot Tables, lookups, large datasets, and data validation.

• Strong experience with data cleansing, de-duplication, standardization, and migration preparation .

• Ability to translate business…