Monday, February 9, 2026

Remote: Data Management ODS Consultant (Power BI, SQL, SSIS) for Emeryville, CA.

Hi,

Hope you are doing well!!

I have an urgent requirement with one of my clients. Please find the job details below and forward me your updated resume along with your contact details at Rewa.s@noviainfotech.com.

 

Job Title: Data Management ODS Consultant (Power BI, SQL, SSIS)

Location: Emeryville, CA (Remote)

Job Type: Contract

 

Job Description:

We are seeking an experienced Data Management / ODS to design, implement, and manage a secure, scalable Operational Data Store (ODS) that supports enterprise reporting and data-driven decision making.

This role requires strong hands-on expertise in SQL, SSIS, Power BI, and cloud platforms (AWS/Azure), along with excellent requirements gathering, documentation, and data architecture skills. The ideal candidate will collaborate closely with cross-functional teams to deliver high-quality reporting and dashboarding solutions.


Key Responsibilities

ODS & Data Architecture

  • Strategize, design, implement, and manage ODS environments and jobs
  • Ensure high availability, scalability, and performance of ODS solutions
  • Design data models to support enterprise reporting and analytics

Data Engineering & Processing

  • Analyze raw data and perform data cleansing, transformation, and processing using SQL
  • Build and maintain SSIS packages, SQL queries, databases, and reports
  • Retrieve and aggregate data from multiple data sources into actionable formats
  • Monitor and optimize daily, weekly, and monthly SQL jobs

Reporting & Power BI Delivery

  • Deliver Power BI dashboards and reporting solutions
  • Document Power BI project requirements, roadmap planning, and reporting delivery
  • Enable effective decision-making through clear, accurate, and actionable reporting

Cloud & Platform Support

  • Support cloud-based data solutions using AWS and/or Azure
  • Document cloud architecture, configurations, and processes
  • Support cloud migration and modernization initiatives
  • Maintain backup and disaster recovery strategies

Collaboration & Governance

  • Collaborate with development and business teams on data management projects
  • Conduct performance testing and ensure data reliability
  • Maintain strong documentation and data governance practices

Required Skills & Qualifications (Must Have)

  • Strong hands-on experience with:
    • MS SQL Server
    • SSIS
    • Power BI
    • MongoDB
  • Experience with Cloud services (AWS and/or Azure)
  • Strong requirements gathering and documentation skills
  • Solid data architecture and ODS design experience
  • Proven ability to deliver reporting and dashboarding projects

Preferred Skills & Qualifications

  • 5+ years of experience in Data Management / BI / Reporting
  • Experience with ODS planning, reporting, and data requirement management
  • Strong project management and stakeholder coordination skills
  • Automation experience in data processing and reporting workflows

Key Competencies

  • Data Management & ODS Architecture
  • SQL & SSIS Development
  • Power BI Reporting & Dashboards
  • Cloud Data Platforms (AWS / Azure)
  • Data Cleansing, Transformation & Optimization
  • Documentation & Stakeholder Collaboration

--
You received this message because you are subscribed to the Google Groups "NoviaJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noviajobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/noviajobs/CAJQxN35wi%2B0a2ya3fXA9xrhr4xQLYmu_dsVyrMisc3H80YcOmg%40mail.gmail.com.

No comments:

Post a Comment

Senior Java Backend Engineer – AWS / Microservices (Palantir) for San Francisco, CA

Role: Senior Java Backend Engineer – AWS / Microservices (Palantir) Location : San Francisco, CA Duration: 12 months Experience Requi...