Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in Bengaluru
>
Consilio
>
Sr. Engineer, Data Warehouse

Sr. Engineer, Data Warehouse

Consilio

5 - 10 years

7 - 8 Lacs

Bengaluru

Posted:2 days ago| Platform:

Apply

Skills Required

Computer science Development Manager SSRS Consulting Flex Informatica SSIS microsoft SDLC SQL

Work Mode

Work from Office

Job Type

Full Time

Job Description

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# 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.
Bachelors 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.

More Jobs at Consilio

Senior Analyst, Data Operations

Gurugram

3 - 7 yrs

INR 4 - 8 Lacs

Admin,BH

Bengaluru

2 - 7 yrs

INR 2 - 5 Lacs

Concierge Partner

Gurugram

2 - 3 yrs

INR 4 - 8 Lacs

DB - Engineer

Bengaluru

2 - 4 yrs

INR 3 - 7 Lacs

Docusign Developer

Pune

4.0 - 8.0 yrs

INR 10 - 18 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Consilio

Legal Services & Technology

Roseville

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Sr. Engineer, Data Warehouse