Role overview

Qualifications

Extensive experience designing, developing, and maintaining Operational Data Warehouses (OEDW)
Experience integrating multiple data sources (Oracle NetSuite, Salesforce, ServiceNow, Workday) and Azure Cloud repositories using tools like Fivetran, DBT, and Databricks
Strong data transformation, data quality, and data governance skills
Proficiency with BI tools (Power BI) and data security/compliance practices

Responsibilities

Lead design, development, and maintenance of the Operational Data Warehouse (OEDW) aligned with business goals and data model architecture.
Integrate data from multiple source systems (Oracle NetSuite, Salesforce, ServiceNow, Workday) and Azure Cloud repositories using tools like Fivetran, DBT, and Databricks; ensure data quality and governance.
Ensure security, compliance, data encryption, access controls, auditing, and performance optimization of the OEDW.
Contribute to the BI repository (Power BI) with documentation, vendor collaboration, and mentoring junior team members.

Key facts

Remote from: India
Full time
Business Data Analyst
English

Other skills

Problem Reporting
Communication
Mentorship

About the company

PradeepIT Consulting Services Pvt Ltd

Join PradeepIT: Innovating Information Technology and Solutions We pride ourselves on delivering exceptional results in the digital era of Information and Technology. With a track record of successful projects across offshore, nearshore, and onshore locations, we've built a clientele spanning 3 continents and 100+ companies. Our 380+ successful projects reflect our commitment to excellence. At PradeepIT, we prioritize the satisfaction of our resources, followed closely by meeting the needs of our clients and partner companies. Our service offerings include Outsourcing, Managed Services, Recruitment Process Outsourcing, Customer Relationship Management, Web Designing & Development, Content Development, and E-commerce Management. We specialize in SAP S/4 HANA, SAP Customer Data Cloud (Gigya), SAP CPQ (Calliduscloud), SAP Customer Experience, Mobility, Android, iOS & Hybrid development for native application developments. Our core value of "Join As Employee With Us And Grow Up As Entrepreneur" drives our mission. We proudly introduce our venture companies: 1. HG Infotech Pvt Ltd 2. Beli Brother Consulting Pvt Ltd 3. Involvemind 4. Stackglobe 5. Prastuti Consulting 6. Khahara Consulting 7. Thinkhigh And many more to come in the near future. We invite you to be part of our clients' success stories by adopting the latest technology and continually improving processes. If you'd like to learn more about us or have specific questions, visit www.pradeepit.com, call us at 08047363377, or email info@in.pradeepit.com. Let's work together on your next project!

Company details

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Job Description:

Timing: 12 PM to 8PM

Rounds of Interviews: 3 to 4

Position Overview:

As a Senior Data Warehouse Expert, you will play a critical role in the development and implementation of an Operational Data Warehouse (OEDW) system for our client. This initiative aims to create a Single Source of Truth (SSOT) for their diverse data sources, ensuring data symmetry, scalability, and security, and serving as both an Operational Data Store and a Business Intelligence (BI) repository. You will work closely with our client's Data Management department, leveraging your expertise in data warehousing and BI platforms to drive the success of this project.

Key Responsibilities:

Data Warehouse Development: Lead the design, development, and maintenance of the Operational Data Warehouse (OEDW) system, ensuring it aligns with the client's business goals and data model architecture provided by the Data Management department.

Data Integration: Collaborate with cross-functional teams to integrate data from various source systems, including Oracle NetSuite, Salesforce, ServiceNow (SNOW), Workday, and Azure Cloud repositories (Fivetran, DBT, Databricks).

Data Transformation: Implement data transformation processes to ensure data quality, consistency, and accuracy within the OEDW, utilizing best practices and industry standards.

Security and Compliance: Ensure data security and compliance with relevant regulations and industry standards, including data encryption, access controls, and auditing.

Performance Optimization: Monitor and optimize the OEDW's performance, identifying and addressing bottlenecks and inefficiencies.

BI Repository: Act as a key contributor to the OEDW's role as a Business Intelligence (BI) repository, enabling data visualization and reporting using tools such as Microsoft Power BI.

Documentation: Maintain comprehensive documentation of data warehouse processes, data lineage, and configurations.

Vendor Interaction: Collaborate with vendors and external partners to ensure seamless integration and support for BI and data warehouse platforms.

Team Collaboration: Mentor and guide junior team members, fostering a collaborative and knowledge-sharing environment.