Data Analyst

Socket.dev; Hagåtña (GU); On-site; USD 55,000 - 75,000; Full time

Job summary

Socket.dev in Guam is hiring a Data Analyst (Internal Designation – Data Analyst I) to design, build, and maintain end-to-end data solutions. You will handle data collection, validation, automation, and reporting across departments.

Responsibilities include creating dashboards for timely insights, collaborating with stakeholders, and ensuring data governance and security. Requires strong SQL, R, JavaScript, HTML skills and a degree in a relevant field.

Qualifications

• Bachelor’s degree or equivalent in a quantitative field.
• Proficiency in SQL, R, JavaScript, and HTML; Python a plus.
• Excel/Google Sheets proficiency including automation (VBA/Apps Script).
• Familiarity with relational databases, data governance and dashboards.
• Experience creating data dashboards (Looker Studio or PowerBI).
• Strong analytic and communication skills for stakeholder insights.

Responsibilities

• Design, build, and maintain end-to-end data solutions.
• Collect, validate, automate, analyze, and report data.
• Create and manage dashboards for timely insights.
• Collaborate with stakeholders to tailor data systems.
• Ensure data governance and secure access controls.
• Prepare executive summaries and reports for decision making.

Skills

SQL

R

JavaScript

HTML

Python

Education

Bachelor’s degree in Data Science, Mathematics, Business Administration, Management or a related field

Tools

Looker Studio

PowerBI

Job description

Job Title: Data Analyst (Internal Designation – Data Analyst I)
Status:Full-time

Department: Business Process Management and Data Analytics
Reports To: Business Process Manager
Location: Guam

Summary/Objective

Pacific Federal Management (PFM) is seeking a highly motivated and detail-oriented Data Analyst to join the Business Process Management and Data Analytics Department.

As the Data Analyst, you will be responsible for designing, building, and maintaining end‑to‑end data solutions that drive continuous improvement across the organization. Your primary responsibilities will include data collection, validation, automation, analysis and report generation for various departments as well as streamlining databases and creating and managing dashboards to ensure that stakeholders have accurate and timely insights to inform business decisions. This role demands close collaboration with the Business Process Manager and other analysts on the team to streamline data workflows, safeguard sensitive information, and deliver accurate reports.

Essential Functions

• Researches, develops, and/or constructs a variety of data management systems.
• Builds the entire data handling lifecycle, defining end‑to‑end workflows for data ingestion, processing, storage, access and reporting.
• Conducts periodic comprehensive data audits and system assessments and monitors system performance and user feedback to identify gaps, inconsistencies, and opportunities for automation and efficiency.
• Prepares and presents reports and submits recommendations regarding future courses of action and the development of systems and programs.
• Presents reports on analytical findings to include executive summaries, charts, tables, and graphs to aid in decision making, strategic planning, and continuous process improvement.
• Collaborates with department stakeholders to gather requirements and tailor data handling systems that reconcile departmental needs with company objectives.
• Streamlines data collection methods, analyzes collected data and builds dashboards to organize gathered data and make it accessible to relevant stakeholders.
• Maintains comprehensive data governance policies, metadata standards, and process documentation.
• Ensures data security and confidentiality by defining access controls and anonymization workflows for sensitive datasets.
• Designs and uses relational database structures to integrate data across multiple systems and departments.
• Performs other duties as assigned.

Competencies and Basic Requirements

• Bachelor’s degree in Data Science, Mathematics, Business Administration, Management or a related field

• Proficiency in SQL, R, JavaScript, and HTML; Python experience a plus
• Proficiency in Excel/Google Sheets (including VBA or Google Apps Scripts for automation)
• Familiarity with database management concepts (relational databases, normalization, indexing, partitioning)
• Practical experience with process mapping and workflow modeling techniques
• Experience in data dashboard creation (Looker Studio or PowerBI) a plus
• Strong analytical mindset with the ability to translate complex data into actionable insights
• Strong communication and presentation skills, capable of explaining technical concepts to all levels of stakeholders
• Ability to work effectively in a team environment and collaborate with cross-functional teams
• Self-motivated and eager to learn new technologies and tools

Supervisory Responsibility

This position does not have direct reporting/supervisory responsibilities.

Work Environment

• Prolonged periods of sitting at a desk and working on a computer.
• Must be able to lift 15 pounds at times.
• Frequent travel to other work sites.

Travel

No travel is expected for this position.