Senior Data Engineer
Core
Building a dedicated data mart for legal office operations, integrating data from multiple sources for reporting and business analysis.
Role type
Senior Data Engineer
Builds
Data marts, ETL pipelines, and data layers for Power BI reporting
Domain
Legal services / Data Engineering
Required skills
Microsoft SQL Server, T-SQL, SSIS, Oracle, Kafka, JSON/XML/TXT processing, data modeling, query optimization
Preferred skills
Data warehouse design, stakeholder collaboration, production troubleshooting, technical documentation
Technologies
Microsoft SQL Server, T-SQL, SSIS, Oracle, Kafka, Power BI
Responsibilities
Analyze business requirements and collaborate with stakeholders to define data needs; Design and develop data models and data marts; Build and maintain integration and ETL processes from various sources; Integrate data from Oracle, SQL Server, Kafka, and file formats; Transform, map, and validate data to relational models; Create stored procedures, functions, and views; Prepare and maintain data layers for Power BI reports; Optimize data structures and query performance; Diagnose and resolve data processing and quality issues in production environments; Prepare technical documentation.