Senior Data Engineer

Covington & Burling LLP is seeking a Senior Data Engineer who will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure. This role is critical in transforming raw data into high-quality datasets to support enterprise analytics and reporting.

Responsibilities:

• Design and implement robust, scalable ETL/ELT pipelines across multiple SQL Server environments and cloud platforms
• Collaborate with architects, analysts, and business stakeholders to understand data requirements and translate them into technical solutions
• Optimize data workflows for performance, reliability, and cost-efficiency
• Ensure data quality, integrity, and security through validation, monitoring, and governance practices
• Maintain and evolve data models, schemas, and metadata for analytics and reporting
• Automate data ingestion, transformation, and deployment using CI/CD and orchestration tools (e.g., Airflow, Azure Data Factory)
• Troubleshoot and resolve data issues, ensuring high availability and performance of data systems
• Mentor junior engineers and contribute to best practices and standards
• Perform other duties as assigned by Firm management
• Uphold high standards of confidentiality, discretion, and integrity, particularly with respect to all sensitive and/or confidential firm and client information to which this position will have access

Requirements:

• 5+ years of experience in data engineering or related roles
• Strong proficiency in SQL, data warehousing, and performance tuning
• Experience with ETL tools and frameworks (e.g., SSIS, dbt, Apache Spark, Azure Data Factory)
• Familiarity with cloud data platforms (e.g., Azure, AWS, GCP)
• Knowledge of data modeling (star/snowflake schemas), data lakes, and data governance
• Proficiency in Python, Scala, or similar languages for data processing
• Experience with version control (e.g., Git) and CI/CD pipelines
• Strong service orientation, and an understanding of the importance of developing effective working relationships with users and organizational stakeholders of all levels
• Ability to effectively communicate and interact with a wide range of users with different levels of technical expertise
• Attention to detail and accountable for delivering quality work
• Must be highly motivated, analytical, organized, and efficient
• Excellent problem solving, design, coding, and debugging skills
• Ability to work well under pressure
• Ability to work well independently, as well as part of a team
• Position requires access to equipment, software, or technology that is subject to U.S. export controls. To be granted access pursuant to US Export Control laws, candidate must be either (a) a United States citizen or national; (b) a person lawfully admitted for permanent residence of the United States (i.e., “Green Card” holder); or (c) an INS-approved refugee or asylum holder who has applied for naturalization within six months of the date the individual first became eligible; and if not yet naturalized, is still actively pursuing naturalization if 2 years have passed since the date of application to be granted access pursuant to US Export Control laws. Candidates will be required to submit appropriate documentation to determine whether access can be granted before proceeding further through the application process
• College degree is strongly preferred, ideally in Computer Science, Data Science, Information Systems, or a related technical discipline
• Appropriate technical certification(s) are preferred