Overview Consilio stands as the global leader in eDiscovery document review flexible legal talent and legal advisory transformation consulting services With its Consilio Complete suite of capabilities the company empowers multinational law firms and corporations using innovative software cost-effective managed services and deep legal and regulatory industry expertise Why Join Us Be part of a collaborative and innovative work environment Opportunity for professional growth and development Competitive salary and benefits package Contribute to shaping the future of our software development processes About the Role Join a energetic team that designs builds and supports the new Enterprise Data Warehouse EDW Delivering clean consistent data to leaders of the Consilio eDiscovery business The EDW engineer will work within the Microsoft Stack building ETL workflows data marts data quality scripts dimensions fact tables aligning with the star schema methodology This role will report to the Lead data engineer in India as a member of the data warehouse team and will work closely with business analysts and other project team members The right candidate will be an energetic self-starter Someone who understands database designs ETL processes and experience design building a data warehouse that is modern scalable maintainable and high performing Responsibilities Data Warehousing design and implementation to support data reporting analytic initiatives and BI platforms tools Develop Extract Transform and Load ETL workflows using SQL Server Integration Services SSIS or other languages such as C and Net to extract data from transactional databases and cloud APIs Analyze and evaluate the data source and data targets required for the ETL mapping Design build and support Data marts using SQL Server Build data quality scripts and notifications either custom or using third party tools Design build and support dimensions fact tables and cubes Design and implement scalable and high-performance data and BI solutions Qualifications 5 years hands experience in SSIS or other ETL tools like Informatica 5 years of data warehouse development hands on experience using SSAS for tabular cube modeling Experience in designing working with star schemas facts dimensions including SCDs Strong database development skills in SQL Server SQL procedures functions etc Experience with Power BI and or SSRS Experience in development tools such as Red Gate and Github a plus Experience creating and maintaining EDW artifacts documentation guides etc a plus Experience in DAX or MDX a plus Possess excellent communication skills both written and verbal Thorough knowledge of SDLC Bachelor s degree in Computer Science or Data Analytics or Software Engineering or Mathematics preferred Consilio s True North Values Excellence - We strive to make every client our advocate Passion - We DO because we CARE Collaboration - We win together through teamwork and communication Agility - We flex adapt and embrace change People - We value respect and invest in our teammates Vision - We create clarity of purpose and a clear path forward Consilio LLC is an EEO Affirmative Action Employer and does not discriminate on the basis of race color religion sex sexual orientation gender identity national origin protected veteran status disability or any other legally protected status

📌 Sr. Engineer, Data Warehouse (Bengaluru)
🏢 Consilio
📍 Bengaluru