Analyze, validate, cleanse, and perform ETL of enterprise data into the firm’s finance applications
Create validation reports utilizing database technologies and financial software
Build and maintain small, curated datasets and a centralized data lake integrating data from multiple cloud-based applications and Azure databases
Support data retrieval and analysis through Power BI dashboards
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
Create Python scripts to automate internal tasks
Create 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.

Bachelor's 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 KPIs
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

Senior Data Engineer

Key skills