SMX is seeking a Data Analyst to create and maintain efficient data processing systems and pipelines to support strategic decision-making and business operations.
Requirements
- 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.
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.
Other
- This is a full-time position requiring on-site work five days a week at a client’s office in Washington, D.C.
- An active Top Secret clearance is mandatory.
- 2+ years experience working as a data analyst
- 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
