SQL Data Analyst at Confident LIMS

Emma de Torre; Ciudad de México; A distancia; USD 20,000 - 50,000; Jornada completa

Descripción de la vacante

A leading company is seeking an SQL Data Analyst to build innovative data models and dashboards that empower labs globally. This remote position offers a competitive salary ranging from $20K to $50K per year, depending on experience. The role requires expertise in SQL and data analytics, with a focus on delivering high-quality work independently within a remote team.

Formación

• 3+ years of experience as data analyst/data scientist using SQL.
• Expert in building high performance SQL queries and data models.

Responsabilidades

• Lead and execute the development of various data models and dashboards.
• Build new data analytics dashboards in Metabase for authenticated customers.

Conocimientos

data analytics

PostgreSQL

SQL

AWS

cloud computing

Metabase

English

Descripción del empleo

I’m helping Confident LIMS find a top candidate to join their team as an SQL Data Analyst with a flexible type of job.

This is a cool job because you will build cutting edge data models and dashboards to power labs worldwide with precision and impact.

Compensation: USD 20K - 50K/year.

Location: Remote (anywhere).

Mission of Confident LIMS: Empower analytical labs to thrive by making complex workflows simple, seamless, and client focused.

What makes you a strong candidate:

• You are expert in data analytics, PostgreSQL, and SQL.
• You are proficient in AWS, cloud computing, and Metabase.
• English - Conversational.

Responsibilities and requirements:

• 3+ years of experience as data analyst/data scientist using SQL.
• Expert in building high performance and efficient SQL queries and data models in Metabase.
• Excellent attention to detail, consistently produces high-quality work delivered on time.
• Comfortable working independently and asynchronously on a remote team to meet deadlines with minimal management oversight.
• Conversational in written English.

General responsibilities:

Lead and execute the development of various data models, databases, and data analytics dashboards to be made available to end users of Client’s customers within Client’s software application and selected third parties, using Client’s current technology infrastructure (AWS, PostgreSQL, Metabase, and React).

Scope of work outline:

• Build new “Simplified Models” (or tables, TBD) to query using Metabase.
• Build new Basic and Pro plan data analytics dashboards in Metabase querying the new Simplified Models for only the authenticated customers’ data:
• For Labs: Starter / Basic Plan (approximately 5-10 queries), Pro Plan (approximately 10-20 queries).
• For Clients: Basic Plan (approximately 5-10 queries), Pro Plan (approximately 10-20 queries).
• Build new “Public Database” with aggregated and anonymized data from the new simplified models for use in new Premium Plan Metabase queries and to be made available to select third-party researchers on a case-by-case basis.
• Build new Premium plan data analytics dashboards in Metabase joining specific customers’ data from the new Simplified Models and the new Public Database that allows authenticated users to join and concurrently display their organization’s data from the Simplified Models with the “benchmark data” from the Public Database (approximately 10-20 queries).