AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
All Filters
38 Consilio Jobs
Sr Data Warehouse Engineer
Consilio
posted 2mon ago
Job Role Insights
Fixed timing
Key skills for the job
Job Description
Data Warehouse Analyst Responsibilities Qualifications
Join a dynamic team that designs, builds, and supports the Enterprise Data Warehouse (EDW). Our mission is to deliver consistent, reliable data and reporting solutions that revolutionize the business intelligence capabilities for the organization. Delivering, clean, consistent data to leaders of the Consilio eDiscovery business!
The ideal Data Warehouse Analyst will be able to work with stakeholders and engineers without skipping a beat. This person should have a passion for data quality, reliable reporting, and creating robust solutions.
As most of the Data Warehouse stakeholders are in the U.S. working U.S. hours is necessary.
- Data Intelligence & Analysis :
- Study and understand the company s business processes and applications, including their effect on data and reporting, and apply the knowledge gained in designing data warehouse objects and reports.
- Building reports, adding new fields, creating Business Objects filters, measures, and other solutions . Leveraging MS SQL Server and PowerBI .
- Dimensional modeling for new solutions that meet the business needs .
- Creating dashboard proof-of-concepts that elevate data and business intelligence using either PowerBI or Excel.
- Collaboration:
- Driving the technical requirement gathering process by working with stakeholders.
- A ssist data warehouse users with leveraging the various solutions available .
- Working with peers to find the right solution to any data challenge.
- Occasionally responsible for:
- Supporting ETL processes that involves error and reconciliation handling, utilizing Microsoft SQL Server Integration Services (SSIS).
- Performs capacity planning, supporting, troubleshooting, and ETL /procedure performance modification.
Skills & abilities this individual should possess :
- B.A./B.S. in Computer Science or related field.
- 8 + years of experience working with relational databases in a business intelligence capacity .
- 5+ years with traditional Data Warehouse, data modelling / data mart development.
- Strong SQL skills, T-SQL preferred .
- PowerBI e xperience , particularly building data visualizations to describe business constructs .
- Technical writing skill s, supporting both engineering and user facing documentation .
- Data analysis skills with a proven ability to identify business trends and insights as well as data inconsistencies and patterns.
- Proficiency with Git Hub , JIRA , and Change Management.
- Experience with SnapLogic or other integration tools a plus.
- Strong ability to collaborate and build effective relationships with your colleagues
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Data Warehouse Engineer roles with real interview advice
Top Consilio Data Warehouse Engineer Interview Questions
Q1. What are the concepts of Object-Oriented Programming (OOP), specifically method overloading and method overriding?
asked in
Software Associate interview
Q2. What technology stack is utilized, and why was this specific stack selected?
asked in
Software Associate interview
What people at Consilio are saying
What Consilio employees are saying about work life
based on 159 employees
Strict timing
Monday to Friday
No travel
Day Shift
Consilio Benefits
View more benefits
Compare Consilio with
Ernst & Young
Compare
KPMG India
Compare
PwC
Compare
Deloitte
Compare
Accenture
Compare
TCS
Compare
Wipro
Compare
Infosys
Compare
HCLTech
Compare
Aparajitha Corporate Services
Compare
Integreon
Compare
UnitedLex
Compare
Y-Axis Overseas Careers
Compare
Quislex Legal Services
Compare
Online Legal India
Compare
EPIQ Systems
Compare
Clifford Chance
Compare
Vakilsearch
Compare
Egniol Services Private Limited
Compare
Mindcrest
Compare
Similar Jobs for you
Director, Data Operations
14-19 Yrs
Gurgaon / Gurugram, Bangalore / Bengaluru
Share an Interview