Want to know if this job is worth applying to?
Philadelphia, Pennsylvania, United States
Onsite
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.
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 privacy@troutman.com.
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.
Hiring Salary Range:
