Summary:
The Senior Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support the enterprise analytics and reporting platform. This role plays a critical part in transforming raw data into trusted, high-quality datasets that power business intelligence, data science, and operational systems. The ideal candidate is a hands-on technologist with deep expertise in SQL, data modeling, and modern data platforms (e.g. Microsoft Fabric).
Duties & 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.
Qualifications:
- College degree is strongly preferred, ideally in Computer Science, Data Science, Information Systems, or a related technical discipline.
- Appropriate technical certification(s) are preferred.
- 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.
Status: Exempt
Reports To: Data & Analytics Portfolio Manager
Workplace Type: Remote
Salary range is $115,000 – $184,000 depending on candidate location and experience.
Candidates hired for staff positions with a minimum work schedule of 30 hours per week are eligible for a comprehensive benefits package, including healthcare insurance. Learn more about benefits at Covington: https://www.cov.com/en/careers/staff/benefits
View Covington job applicant privacy notice here: https://www.cov.com/en/job-applicant-privacy-notice
Covington & Burling LLP is an equal opportunity employer and does not discriminate in any aspect of employment, including hiring, salary, promotion, discipline, termination, and benefits, on the basis of race, color, ethnicity, religion, national origin, gender, gender identity or expression, age, marital status, sexual orientation, family responsibility, disability (including physical handicap), or any other improper criterion.
California Applicants Only: Covington will consider qualified applicants with arrest or conviction records for employment in accordance with applicable laws, including the California Fair Chance Act, the Los Angeles Fair Chance Initiative for Hiring Fair Chance Ordinance, the Los Angeles County Fair Chance Ordinance, and the San Francisco Fair Chance Ordinance.