SQL Data Analyst

Job Description

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 more: 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 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 the end users of Client’s customers within Client’s software application and selected third-parties outside of Client’s software application 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: a. For Labs: Starter / Basic Plan (approximately 5-10 queries). Pro Plan (approximately 10-20 queries). b. 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). Show more Show less