Senior Data Engineer IT Application Solutions Department 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. Apply Qualifications College degree is strongly preferred ideally in Computer Science Data Science Information Systems or a related technical discipline. Appropriate technical certifications 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 starsnowflake schemas data lakes and data governance. Proficiency in Python Scala or similar languages for data processing. Experience with version control e.g. Git and CICD pipelines. Strong service orientation and an understanding of the importance of developing effective working relationships with users and organizational stakeholders of all levels. Duties and Responsibilities Design and implement robust scalable ETLELT 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 CICD 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 andor confidential firm and client information to which this position will have access. Status Exempt Reports To Data & Analytics Portfolio Manager Workplace Type Remote Salary range is 115000 - 184000 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. httpswww.cov.comencareersstaffbenefits View Covington job applicant privacy notice here httpswww.cov.comenjob-applicant-privacy -notice 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. Covington & Burling LLP is an equal opportunity employer and does not discriminate in any aspect of employment including hir ing salary promotion discipline termination and benefits on the basis of race color ethnicity religion national origin g ender gender identity or expression age marital status sexual orientation family responsibility disability including physical handicap or any other improper criterion. Covington will consider qualified applicants with arrest or conviction records for employment in accordance with applicable l aws including the California Fair Chance Act the Los Angeles Fair Chance Initiative for Hiring Fair Chance Ordinance the Los Ang eles County Fair Chance Ordinance and the San Francisco Fair Chance Ordinance.