What does a Looker freelancer do?
A Looker freelancer builds analytics solutions by writing LookML code to define data models and creating interactive dashboards for business users. This role translates raw database tables into governed dimensions and measures that non-technical stakeholders can explore safely. The freelancer manages the full lifecycle of content from development in a sandbox environment to production deployment via version control systems.
- Authors LookML model and view files to define dimensions, measures, and query behavior for specific business metrics. This work establishes the single source of truth for data analysis by mapping database columns to user-friendly fields within the Looker IDE. The freelancer writes these definitions in .lkml files to ensure consistent calculations across all reports and dashboards used by the organization.
- Builds and maintains Looks and dashboards using the Looker Explore interface or LookML dashboard definitions. These visualizations allow users to filter, drill down, and analyze trends without writing SQL queries manually. The freelancer organizes this content into folders and sets permissions so that only authorized teams can view sensitive financial or operational data.
- Manages the deployment process by developing changes in Development Mode and pushing validated updates to Production Mode. This workflow often involves connecting Looker to a Git repository to track changes and collaborate with other developers on the same project. The freelancer tests model logic with LookML data tests before merging code to prevent broken reports from reaching end users.
- Configures scheduled deliveries for dashboards and Looks to automate recurring reporting tasks for stakeholders. This setup uses the Looker Scheduler or ScheduledPlan API to send rendered reports via email, Slack, or cloud storage services like S3 and SFTP. The freelancer defines cron schedules or datagroup triggers to ensure recipients receive fresh data at the correct intervals without manual intervention.
How to hire a Looker freelancer on Upwork
Step 1: Post a job
Define your analytics needs by listing specific LookML modeling and dashboarding requirements. The Job Post Generator powered by Uma™, Upwork's Mindful AI drafts a complete post from a few sentences about your data goals. You can write a new post, update a saved draft, or reuse an existing post to start hiring.
- Specify whether the freelancer must build new LookML models or maintain existing views and dimensions.
- List required deliverables such as Looks, dashboards, or scheduled report configurations.
- Clarify if the role involves Development Mode testing or Production Mode deployment via Git.
Step 2: Evaluate candidates
Review portfolios for evidence of complex LookML projects and clean dashboard designs. Uma runs instant video interviews and builds shortlists with side-by-side comparisons to help you assess technical fit quickly.
- Check for examples of LookML dashboard definitions and organized content folders.
- Look for proof of experience with Scheduled Plans or recurring delivery setups.
- Verify familiarity with data tests and version control workflows in Looker.
Step 3: Interview your top choices
Discuss their approach to modeling data and handling query performance issues. Schedule interviews within Upwork Messages to receive an immediate transcript and summary after each conversation.
- Ask how they structure LookML views to support reusable dimensions and measures.
- Request examples of how they troubleshoot SQL generation errors in Explore.
- Inquire about their process for migrating changes from Development to Production Mode.
Step 4: Agree on scope and begin work
Set clear milestones for model creation, dashboard builds, and testing phases. Use Upwork Messages and the contract workroom for communication and project management, plus identity verification, payment protection, hourly tracking, and project funds for security.
- Define specific LookML files and dashboard components for each milestone.
- Agree on acceptance criteria for data tests and visual accuracy checks.
- Confirm the schedule for automated deliveries and recipient permissions.
Upwork is not affiliated with and does not sponsor or endorse any of the tools or services discussed in this article. These tools and services are provided only as potential options, and each reader and company should take the time needed to adequately analyze and determine the tools or services that would best fit their specific needs and situation.
The rates and information provided in this article are based on current data and industry sources available at the time of publication. Freelance rates can vary depending on factors such as experience, location, project scope, and market conditions. Readers are encouraged to conduct their own research to confirm current rates and trends, as this information may change over time.