Sr. Engineer, Data Warehouse
Sr. Engineer, Data Warehouse
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 dynamic 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# 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.
- Bachelors degree in Computer Science or Data Analytics or Software Engineering or Mathematics preferred.
Consilios 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 isan 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.
Required Experience:
Senior IC
Employment Type
Unclear
