Data Analyst (R2) (Pipeline)

Lucayan Technology Solutions LLC; Fort Cavazos Motorcycle and POV Campus (TX); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Join a mission-focused environment

Priority consideration for upcoming openings

Collaborative team environment

Job summary

Lucayan Technology Solutions LLC is seeking a Data Analyst to collect, clean, analyze, and visualize operational data at Fort Cavazos, Texas. The role includes responsibilities for producing reports and dashboards, ensuring data quality, and supporting stakeholder requirements. Candidates should have a Bachelor's in a relevant field and 2+ years of experience in data wrangling and analytics. Proficiency in SQL and tools like Power BI is required. The position is full-time and on-site, needing a security clearance.

Qualifications

• 2+ years hands-on experience with data wrangling, descriptive/diagnostic analytics, and dashboarding.
• Proficiency with SQL and one or more tools: Power BI, Tableau, Excel, or Python.

Responsibilities

• Acquire and validate data from Army systems; maintain data quality.
• Build queries, metrics, and dashboards that track readiness trends.
• Produce weekly/monthly reports and maintain version control.
• Work with Government leads to refine requirements and brief findings.
• Recommend methods to improve data quality and automation.
• Safeguard sensitive data and follow security procedures.

Skills

Data wrangling

Descriptive/diagnostic analytics

Dashboarding

Briefing and writing skills

SQL

Power BI

Tableau

Excel (Power Query/Pivot)

Python (pandas)

Education

Bachelor’s in Data Science, Statistics, Analytics, Information Systems, or related field

Tools

Power BI

Tableau

Excel

Python

Job description

At Lucayan Technology Solutions LLC, we deliver secure, innovative solutions in support of national defense and intelligence missions. As a trusted government contracting partner, we provide top-tier intelligence and technology services that safeguard our nation. Our team is mission‑driven, and we are committed to building careers that matter.

Location: Fort Cavazos (Killeen), Texas
Clearance: Secret (must be able to obtain and maintain)
Employment Type: Full-time, on-site

Job Summary

This non‑personal services role collects, cleans, analyzes, and visualizes operational and personnel/readiness data to inform commanders and stakeholders. The analyst will produce recurring and ad‑hoc reports and dashboards, ensure data quality and protection of sensitive information, and meet PWS deliverable standards and timelines.

Key Responsibilities

• Data intake & quality control: Acquire data from Army systems and approved sources; validate, normalize, and document datasets; maintain data dictionaries and lineage.
• Analysis & visualization: Build repeatable queries, metrics, and dashboards (e.g., Power BI/ Tableau/ Excel) that track readiness trends, leading indicators, and unit performance.
• Reporting & deliverables: Produce weekly/monthly PWS‑required reports, briefs, and trip/meeting notes; submit products in MS Office formats and maintain version control.
• Stakeholder support: Work with Government leads to refine requirements; translate findings into decision‑ready products and brief results to leadership.
• Process improvement: Recommend methods to improve data quality, automation, and cycle time; develop/update SOPs for data management and reporting.
• Compliance & protection: Safeguard sensitive/FOUO/Privacy Act data; follow Army/DoD information security, records, and configuration‑management procedures.

Required Qualifications

• Bachelor’s in Data Science, Statistics, Analytics, Information Systems, or related field (or equivalent experience).
• 2+ years hands‑on experience with data wrangling, descriptive/diagnostic analytics, and dashboarding.
• Proficiency withSQLand one or more tools:Power BI, Tableau, Excel (Power Query/Pivot), or Python (pandas).
• Strong briefing and writing skills; ability to meet firm deadlines and quality thresholds defined in the PWS.

Required Security Clearances & Trainings

• Clearance: CAC eligibility and successful background check for installation access.
• Mandatory trainings (within 30 days of start; annual refreshers):
• Cyber Awareness / Information Assurance
• iWATCH Army installation awareness
• Completion of any additional command‑directed security or records‑handling training relevant to Privacy Act/PII.

Preferred Qualifications

• Experience supporting Army HQ, IMCOM, Corps, Division, or G‑staff analytics.
• Familiarity with Army data environments (e.g., authoritative readiness/maintenance/manpower systems) and tasker workflows.
• Experience automating ETL pipelines; DAX/Power Query/M, Python, or R for repeatable products.
• Practical knowledge of Privacy Act, FOUO/CUI handling, and DoD records management.
• On‑site at Fort Cavazos during Government operating hours (Mon‑Fri, 0800-1700), with occasional surge or after‑hours support for deadlines, exercises, or inspections.
• Collaborative, mixed military/civilian/contractor team environment.
• Government‑furnished workspace, network access (with CAC), and approved software; products delivered in MS Office formats per PWS.

Why Join Our Pipeline?

• Be first in line for upcoming openings aligned with your experience and career goals.
• Stay connected with Lucayan’s recruiting team for priority consideration.
• Join a mission‑focused environment where your expertise makes a tangible impact.