Cleared Onsite Data Analyst (5211)

遠鉄システムサービス（株）; Washington (District of Columbia); On-site; USD 95,600 - 160,700; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement

Job summary

遠鉄システムサービス（株） is seeking a motivated and detail-oriented Data Analyst to join their team in Washington, D.C. This full-time position focuses on creating efficient data processing systems to support strategic decision-making.

The ideal candidate will collaborate with cross-functional teams and requires an active Top-Secret clearance, ensuring seamless operations with a strong focus on reliability and scalability in data solutions.

Compensation ranges from $95,600 to $160,700, along with comprehensive benefits and development opportunities.

Qualifications

• 6+ years of data analysis experience.
• Proficiency in SQL and a strong understanding of database systems.
• Experience with ETL and data orchestration tools.

Responsibilities

• Design, develop, and maintain data pipelines for reliable processing.
• Implement ETL processes using various tools.
• Manage and optimize database operations with SQL.

Skills

SQL

Data processing

ETL processes

Data integration

Cloud platforms (AWS)

Database systems

Education

Bachelor’s degree in Statistics, Mathematics, Computer Science, or Business Analytics

Tools

Apache Airflow

AWS Glue

Informatica

AWS Redshift

Job description

SMX is seeking a motivated and detail-oriented Data Analyst to join our team. This role focuses on creating and maintaining efficient data processing systems and pipelines to support strategic decision‑making and business operations. The ideal candidate will work closely with cross‑functional teams to deliver reliable and scalable back‑end data solutions. This is a full‑time position requiring on‑site work four days a week at a client’s office in Washington, D.C. An active Top‑Secret clearance is mandatory.

Key Responsibilities

• Design, develop, and maintain data pipelines, integrating data from various sources to ensure reliable and efficient processing.
• Implement ETL (Extract, Transform, Load) processes using tools such as Apache Airflow, AWS Glue, Informatica, or similar technologies.
• Manage and optimize database operations, leveraging SQL and working with modern data warehousing platforms such as AWS Redshift.
• Collaborate with data analysts and other stakeholders to understand data requirements and translate them into robust back‑end solutions.
• Create scalable and efficient data architectures, ensuring performance optimization and data integrity.
• Conduct thorough testing and validation of data processes to maintain high data quality and reliability.
• Troubleshoot and resolve data‑related issues to ensure uninterrupted business operations.
• Document data processes, workflows, and solutions for knowledge sharing and team collaboration.
• Stay updated with emerging technologies and best practices in data engineering and development.

Required Qualifications

• 6+ years of data analysis experience
• Proficiency in SQL and a strong understanding of database systems.
• Experience with ETL and data orchestration tools such as Apache Airflow, AWS Glue, or Informatica.
• Familiarity with cloud platforms and services, particularly AWS.
• Knowledge of data warehousing and data integration techniques.
• Strong understanding of data processing and performance optimization.

Preferred Qualifications

• Bachelor’s degree in a related field such as Statistics, Mathematics, Computer Science, or Business Analytics.
• Experience with federal data modernization or analytics programs.

This position requires four days a week on site at customer location in Washington DC.

Salary: $95,600 – $160,700 USD

SMX salary determination process takes into account a number of factors, including but not limited to, geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education and certifications. At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.

SMX is an Equal Opportunity employer including disabilities and veterans.

Selected applicant may be subject to a background investigation and/or education verification.

SMX does not sponsor a new applicant for employment authorization or immigration related support for this position (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, E-2, E-3, L-1 and O-1, or any EADs or other forms of work authorization that require immigration support from an employer).