What are the responsibilities and job description for the Cleared Onsite Data Analyst (5211) position at ess?
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. **
Application deadline 7-10-2026
#LI-SA
#cjpost
The 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.
The proposed salary for this position is:
$95,600 - $160,700 USD
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).
Salary : $95,600