Junior Biostatistician

Jobtailor; California (MO); On-site; USD 70,000 - 90,000; Full time

Job summary

Jobtailor is looking for a data analytics professional to join the team in the United States. The role focuses on building scalable data pipelines, preparing analysis-ready datasets, and delivering actionable insights for mission-driven readiness analytics.

You will design ETL/ELT processes, work with SQL Server and Databricks, and develop dashboards in Power BI. Collaboration across teams and strong data storytelling are essential for success.

Qualifications

• Bachelor’s degree with 1–2 years’ experience in quantitative or related field.
• Proficient with Word, Excel, Access (Microsoft Office).
• Working knowledge of SQL Server (SQL/T‑SQL) and relational schemas.
• Hands‑on experience with Databricks and Apache Spark (PySpark).
• Foundational programming in Python or R for analysis and ML workflows.
• Understanding of ETL/ELT, data modeling, and version control (Git).
• Experience building visuals in Power BI (reports, datasets, semantic models).
• Familiarity with Power Apps (Canvas and Model‑Driven) and Power Automate.
• Basic NLP and LLM familiarity for text data use cases.
• Ability to translate mission needs into data requirements and analytics outputs.
• Experience with HTML, CSS, JavaScript, React; backend exposure to Django or ASP.NET Core.
• Advanced Spark/Databricks patterns and MLOps concepts.

Responsibilities

• Acquire, integrate, and prepare data from multiple sources for reporting and analytics.
• Design and implement ETL/ELT pipelines with SQL Server and Databricks (PySpark).
• Develop curated datasets with data quality and lineage considerations.
• Optimize performance, partitioning, and job scheduling; monitor workloads.
• Apply statistics, data mining, and ML for forecasts and ready analytics.
• Create dashboards and semantic models in Power BI for consistent metrics.
• Support Power Platform integration (Power Apps, Power Automate).
• Handle unstructured data prep and labeling for NLP use cases.
• Familiar with LLMs and prompt patterns; assist seniors in deployments.
• Document sources, transformations, and methodologies for transparency.

Skills

SQL Server

PySpark

Python

Data Modeling

Power BI

Git

Databricks

ETL/ELT

HTML/CSS/JS/React

MLOps basics

Education

Bachelor’s degree

Tools

Databricks

Spark

Power Platform

Django/ASP.NET Core

Job description

Responsibilities

• Acquire, integrate, and prepare data from multiple sources to enable operational reporting, readiness analytics, and decision support.
• Design and implement ETL/ELT pipelines using SQL Server and Databricks leveraging Apache Spark (PySpark) for scalable batch processing and data transformation.
• Develop and maintain curated, analysis-ready datasets (e.g., dimensional models, governed reporting tables) with attention to data quality, lineage, and repeatability.
• Optimize data processing performance (partitioning strategies, efficient joins, job tuning) and contribute to reliable scheduling/orchestration and monitoring of recurring workloads.
• Apply statistical methods, data mining, and machine learning to generate actionable insights, forecasts, and predictive analytics relevant to military missions and readiness.
• Create dashboards and analytical products using Power BI, including semantic modeling and measures to support consistent metrics and reporting.
• Support low-code solutions by integrating data products into Power Apps (Canvas and Model-Driven) and automations using Power Automate.
• Contribute to text and language-focused use cases by preparing and analyzing unstructured data (basic NLP preprocessing, labeling/curation, feature creation).
• Demonstrate familiarity with LLMs and agent concepts (prompting patterns, retrieval‑style workflows, evaluation considerations) and assist senior team members in implementing these capabilities where appropriate.
• Document data sources, transformations, assumptions, and analytical methodologies to ensure transparency and operational continuity.

Requirements

• Bachelor’s degree with one to two (1‑2) years’ experience in quantitative science, social science or related discipline.
• Proficient with the suite of Microsoft Office programs, including Word, Excel and Access.
• Working knowledge of SQL Server (SQL/T‑SQL), including querying, joins, indexing basics, and working with relational schemas.
• Hands‑on experience or strong exposure to Databricks and Apache Spark (preferably PySpark) or comparable systems for scalable data preparation.
• Foundational programming skills in Python or R for analysis, data manipulation, and ML workflows.
• Possess an understanding of data engineering concepts: ETL/ELT, data modeling basics, data quality checks, reproducible pipelines, and version control (Git).
• Experience building visual analytics with Power BI (reports, datasets/semantic models, DAX fundamentals preferred).
• Familiarity with the Power Platform: Power Apps (Canvas and Model‑Driven) and Power Automate for workflow integration.
• Basic familiarity with NLP and Large Language Models, including typical use cases and data requirements (text preparation, evaluation datasets, governance considerations).
• Ability to communicate clearly with stakeholders and translate mission needs into data requirements and analytical outputs.
• Experience with web application development technologies: HTML, CSS, JavaScript, React, plus backend exposure to Django or ASP.NET Core.
• Experience with advanced Spark/Databricks patterns (Delta tables, incremental loads, job/workflow scheduling, performance tuning).
• Familiarity with deploying analytics/ML into applications (APIs, dashboards, or integrated workflows) and basic MLOps concepts.