Senior Data Engineer
Rosslyn, VA – hybrid (1-2 days a week onsite)
Active Secret clearance is required
Job Description:
Design, build, and optimize our data infrastructure on AWS. Work closely with the Enterprise Data Architect and cross-functional teams to develop scalable, high-performance data solutions. Ensuring data integrity, availability, and accessibility to support business analytics and decision-making processes with an emphasis on data governance.
Responsibilities:
• Design, develop, and maintain robust data pipelines and ETL processes to ingest, transform, and load data from various sources into our AWS data platform.
• Collaborate with the Enterprise Data Architect to implement and optimize data models, databases, and data warehouses.
• Ensure data quality, integrity, and consistency by implementing comprehensive data validation and cleansing procedures.
• Optimize data storage and retrieval for performance, cost-efficiency, and scalability using AWS services such as Redshift, RDS, S3, Glue, and Athena.
• Develop and implement automation scripts and tools for data processing, monitoring, and maintenance.
• Work closely with data scientists, analysts, and business stakeholders to understand data requirements and deliver efficient data solutions.
• Troubleshoot and resolve data-related issues, ensuring minimal disruption to data operations.
• Implement data security and compliance measures to protect sensitive information and adhere to industry regulations.
• Provide technical guidance and mentorship to junior data engineers and other team members.
Skills:
• Proficiency in designing and implementing ETL processes and data pipelines using AWS services such as Glue, Data Pipeline, and Lambda.
• Extensive experience with SQL and database technologies, including Redshift, RDS, and DynamoDB.
• Strong programming skills in languages such as Python, Java, or Scala.
• Experience with data governance best practices and implementation.
• Knowledge of data modeling, data warehousing, and data architecture principles.
• Experience with big data technologies such as Hadoop, Spark, and Kafka.
• Solid understanding of data security, privacy, and compliance best practices.
#M2
System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.