Senior Data Engineer

We are always seeking talented, motivated, growth-minded, and creative individuals. Our firm is committed to providing employee support and advancement, while embracing inclusion and innovation as keys to a stronger future. We invite you to explore the position below and to submit your application to join our team! The Senior Data Engineer is responsible for analyzing, validating, cleansing, and performing ETL of enterprise data into the firm’s finance applications, as well as creating validation reports utilizing database technologies and financial software. The Senior Data Engineer will build and maintain small, curated datasets and a centralized data lake integrating data from multiple cloud-based applications and Azure databases and will support data retrieval and analysis through Power BI dashboards. Essential Duties and Responsibilities Design, develop, and maintain ETL processes and data structures following best practices. Work with data integration (ETL), data modeling, data quality, data governance, enterprise data warehouse (EDW), and analytical tools. Develop efficient SQL stored procedures, views, and queries with a strong understanding of data structures, data integrity, and indexing. Utilize SSIS, SSRS, and SSMS for ETL, reporting, and analysis of data. Retrieve data from cloud applications using Azure SQL and build a centralized data lake integrating multiple cloud-based applications and Azure databases. Design and develop Power BI dashboards for data analysis and business reporting. Creating Python scripts to automate internal tasks. Creating Power Automate and Power Apps workflows for internal teams/departments. Act as a knowledge resource and facilitator for data retrieval in support of all administrative business units. Identify opportunities to drive innovation, improve data processes, and enhance the accuracy, reliability, and usability of information. Knowledge, Skills and Abilities Strong SQL and data engineering skills. Hands-on experience with Azure, APIs, Microsoft Fabric, SSRS, SSIS, SSAS, Power Apps, Power Automate, Power BI, and Python. Strong analytical and problem-solving skills. Excellent written and oral communication skills. Demonstrated ability to add value, build efficiency, and improve accuracy and reliability of information. Strong awareness of deadlines and commitment to delivering high-quality work on time. High level of discretion and sensitivity to confidential information. Strong organizational skills with the ability to manage multiple priorities in a fast-paced environment. Ability to synthesize information from a wide variety of sources and produce clear, concise, client-ready deliverables. Proficiency with Microsoft Office products and related tools such as Excel, SSRS, Power Apps and PowerShell. Blend of technical and business skills, along with strong interpersonal skills, developed through experience in data analysis, database design, and application development. Education and Experience Bachelors' degree in Computer Science, Management Information Systems, or related field. Minimum of eight (8) years of relevant work experience with ETL, data integration and migration, and strong SQL. Minimum of three (3) years of experience with Datawarehouse technologies, Power BI development and administration, and working with and translating company financial data into executive-level reports and KPI’s. Experience in creating and deploying ETL processes using SSIS required. Hands-on experience to create Python scripts and automate the internal processes required. Experience with Fabric and Aderant preferred. Prior law firm or professional services experience beneficial. #LI-Remote The Firm will comply with any applicable city or state workplace mandates in effect in regards to Covid-19. This position description is intended to describe the general content of and requirements for the performance of the job. The statements contained in the position description are not necessarily all-inclusive and additional duties and responsibilities may be assigned as determined by business needs. This position description does not constitute a written or implied contract of employment. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. By applying for this position, you agree and understand that Troutman Pepper Locke will process your Personal Information pursuant to the terms of our Worker and Applicant Global Privacy Notice. If you have questions about our data handling practices, or you are a resident of California, the United Kingdom, or the European Union and wish to exercise your privacy rights, please contact us at View email address on click.appcast.io. Equal Employment Opportunity Troutman Pepper Locke adheres to a policy of equal opportunity and will make all employment decisions, which include hiring, promotion, transfer, demotion, evaluation, compensation and separation, without regard to race, color, religion, sex, age, sexual orientation, gender identity or expression, national origin, pregnancy, citizenship, disability, genetic information, marital or armed forces status and any other classification as protected by law. Compensation is dependent on several factors, such as position, location, market, education, training, and/or experience. Hiring Salary Range: $120,000.00 - $170,000.00 About Us Your experience is our difference. We aim to make a tangible and lasting difference for you and your business. As a client of our firm, you can expect us to be ahead of the curve in your industry, start closer to the right answer on your issue, and create more value. What drives you, drives us. Troutman Pepper Locke helps clients solve complex legal challenges and achieve their business goals in an ever-changing global economy. As a firm of more than 1,600 attorneys in 35 offices in the U.S., UK, and EU, including the 10 largest U.S. legal markets, we serve clients ranging from multinational companies to new market entrants across all major industry sectors, and offer differentiated experience in energy, financial services, health care and life sciences, insurance and reinsurance, private equity, and real estate. We put clients first. This service ethic manifests itself in everything we do, including through Troutman Plus, our market-leading client value program. Through Troutman Plus, we collaborate with clients to understand their unique needs and deliver customized solutions that add real value to their business. A true service culture thrives on an inclusive environment of mutual support and collaboration — values we emphasize at every level of our firm. Delivering the best service to you depends on a work environment that embraces respect, inclusiveness, and teamwork, empowering every individual to contribute. The best ideas emerge when everyone has a seat at the table. Corporate responsibility is central to our mission as we reach out to the communities we serve in meaningful partnerships and pro bono work. Individuals and groups firmwide contribute time and talent to the civic, cultural, charitable, educational, and professional organizations that matter to them.