Data Analyst Junior

Socket.dev; San Antonio (TX); On-site; USD 65,000 - 85,000; Full time

Job summary

Socket.dev is seeking a Junior Data Analyst to support data-driven decision making in a regulated government environment. You will leverage an enterprise analytics platform to uncover trends and translate datasets into dashboards and metrics.

You will integrate data from multiple systems, apply exploratory analytics and basic predictive techniques, validate results, and help optimize data pipelines. Collaboration with stakeholders and documentation of methods are important.

Qualifications

• Associates degree in a quantitative, business, or technology field; bachelor's preferred for progression.
• Typically 1–3 years of hands-on data analysis, reporting, or business intelligence in enterprise/government settings.
• Proficiency with SQL for querying, joining, and aggregating across multiple sources.
• Experience building reports or dashboards in Power BI, Tableau, Qlik, or similar.
• Ability to apply basic statistics and exploratory data analysis to assess trends.
• Active Secret clearance or ability to obtain one; U.S. citizenship required.

Responsibilities

• Apply exploratory data analysis, statistics, and basic predictive modeling to large, multi-source datasets.
• Use SQL to extract, join, and aggregate data from enterprise data lakes and systems.
• Design and maintain interactive dashboards and reports to track performance, cost, usage, and customer satisfaction.
• Implement data cleaning and validation to improve data quality and governance conformance.
• Collaborate with senior analysts and data engineers to optimize data models and pipelines.
• Document methodologies, data dictionaries, and business rules for reproducibility.
• Provide user support and training for self-service analytics and dashboards.
• Evaluate and integrate new analytics tools and reusable templates for common questions.

Skills

SQL

Data analysis

BI reporting

Education

Associates degree in a quantitative, business, or technology-related field

Bachelor's degree preferred for long-term progression

Tools

Power BI

Tableau

Qlik

Job description

Position Overview

The Junior Data Analyst supports data‑driven decision‑making by leveraging an enterprise data and analytics platform to uncover trends, patterns, and actionable insights for mission‑critical operations in a highly regulated government environment. They partner with business and technical stakeholders to refine analytical requirements, ensure alignment with data governance standards, and translate complex datasets into clear reports, dashboards, and performance metrics.

This role focuses on integrating data from multiple business systems, applying exploratory and basic predictive techniques, and validating results to monitor costs, usage, and customer experience. The analyst also helps optimize data pipelines and analytical workflows, contributes to reusable analytic components, and assists in evaluating and deploying new analytics and visualization tools across the organization.

Key Responsibilities

• Apply exploratory data analysis, statistical techniques, and basic predictive modeling to large, multi‑source datasets to identify trends, correlations, and outliers that support operational and financial decisions.


• Use SQL and similar query tools to extract, join, and aggregate data from enterprise data lakes and business systems, ensuring accurate filters, joins, and calculated fields for reports and dashboards.


• Design, build, and maintain interactive dashboards and recurring reports in common business intelligence (BI) tools to track performance, cost, usage, and customer satisfaction metrics with automated refresh and clear visual storytelling.


• Implement data cleaning, transformation, and validation routines to improve data quality, reconcile conflicting records, and ensure conformance with established data governance and stewardship standards.


• Collaborate with senior analysts, data engineers, and system owners to understand source system structures, optimize data models, and enhance data pipelines for analytics use in mission‑critical environments.


• Document analytical methodologies, data dictionaries, business rules, and recurring report logic to support transparency, reproducibility, and efficient onboarding of new team members and stakeholders.


• Assist in evaluating, configuring, and integrating new analytics and visualization tools, including prototyping reusable templates, components, and query patterns for common business questions.


• Provide user support and training for stakeholders on self‑service analytics capabilities, including explaining metric definitions, data limitations, and best practices for interpreting dashboards and reports.

Required Qualifications

• Associates degree in a quantitative, business, or technology‑related field, or equivalent relevant experience; bachelors degree preferred for long‑term progression into the standard Data Analyst role.


• Typically 1–3 years of hands‑on experience in data analysis, reporting, or business intelligence within enterprise or government environments.


• Demonstrated proficiency with SQL for querying, joining, and aggregating data across multiple tables and data sources.


• Experience building reports or dashboards in at least one BI or reporting tool (such as Power BI, Tableau, Qlik, or similar).


• Ability to apply basic statistical concepts and exploratory data analysis techniques to assess trends, distributions, and anomalies.


• Active Secret clearance (or the ability to obtain and maintain a Secret clearance as required by the client).


• U.S. citizenship required to support a highly regulated government environment.

Preferred Qualifications

• Experience working with defense or other highly regulated federal data environments and associated governance standards.


• Familiarity with one or more major BI platforms (e.g., Power BI, Tableau, or Qlik) including use of calculated fields and parameters.


• Exposure to Python or R for data wrangling, automation, or basic analytics beyond point‑and‑click tools.


• Prior experience supporting mission‑critical analytics use cases related to cost, usage, performance, or customer satisfaction in an enterprise setting.

Compensation Ranges

Compensation ranges for ASM Research positions vary depending on multiple factors; including but not limited to, location, skill set, level of education, certifications, client requirements, contract‑specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM's overall compensation and benefits package for employees.

EEO Requirements

It is the policy of ASM that an individual's race, color, religion, sex, disability, age, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.

All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, disability or age. All decisions on employment are made to abide by the principle of equal employment.

Physical Requirements

The physical requirements described in \"Knowledge, Skills and Abilities\" above are representative of those which must be met by an employee to successfully perform the primary functions of this job. (For example, \"light office duties' or \"lifting up to 50 pounds\" or \"some travel\" required.) Reasonable accommodations may be made to enable individuals with qualifying disabilities, who are otherwise qualified, to perform the primary functions.

Disclaimer

The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.