Sr. Engineer, Data Warehouse

2 days ago


Bengaluru, India Consilio LLC Full time

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# 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, 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, 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. Data Engineer

    1 week ago


    Bengaluru, Bhopal, Jaipur, India CODERS BRAIN Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Description: Sr. Data Engineer About the team: As a Data Engineer in the Data Warehouse team you will be relied on to independently develop and deliver high-quality features and finish tasks to a high standard. Youll be part of an emerging team, focussing on building and improving our innovative BNL Data Warehouse offerings applying marketing suites....

  • Sr Data Engineer

    3 days ago


    Bengaluru, Karnataka, India Nam Info Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Dear Candidate,Hope you are doing well.Greeting from NAM Info INC.NAM Info Inc. is a technology-forward talent management organization dedicated to bridging the gap between industry leaders and exceptional human resources. They pride themselves on delivering quality candidates, deep industry coverage, and knowledge-based training for consultants. Their...


  • Bengaluru, India Consilio LLC Full time

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


  • Bengaluru, Karnataka, India Consilio LLC Full time ₹ 20,00,000 - ₹ 25,00,000 per year

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


  • Bengaluru, India Consilio LLC Full time

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

  • Data Engineer

    6 days ago


    Bengaluru, Karnataka, India Data Analytics Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Get to Know the Team Grab has been expanding into multiple lines of businesses. The Grab Data Warehouse team builds business intelligence systems using data from all business lines to provide insights to key stakeholders across the company. Get to Know the Role We are looking for a Lead Data Engineer to lead the design and enhancement of our data...

  • Sr. Data Science

    2 weeks ago


    Bengaluru, India NTT DATA, Inc. Full time

    We are currently seeking a Sr. Data Science & AIML, GenAI Lead/Engineer to join our team in Bangalore, Karntaka (IN-KA), India (IN). Job Duties: Job Title: Data Science & AIML, GenAI Lead/Engineer Key Responsibilities: Develop and implement traditional machine learning algorithms. Deploy at least one model in a production environment. Write and maintain...

  • Sr. Data Engineer

    2 days ago


    Bengaluru, India NTT DATA Full time

    Job Description Req ID:     NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Sr. Data Engineer to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Primary...

  • Sr. Data Engineer

    2 days ago


    Bengaluru, India NTT DATA Full time

    Job Description Req ID:     NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Sr. Data Engineer to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Primary...

  • Sr Data Engineer

    3 days ago


    Bengaluru, Karnataka, India NTT DATA Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Req ID: 340286NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Sr Data Engineer (Life and Annuity) to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Job Duties: At...