Data Engineer Job at HG Solutions, San Jose, CA

a1U1V3k1S1dWQ1c5Z0xJZEtUMTFFYURROVE9PQ==
  • HG Solutions
  • San Jose, CA

Job Description

Role : Data Engineer
Location : San Jose CA ( Onsite)
Experience: 10 Years
Key Skills : Power BI ETL Azure Python


We are seeking a skilled data expert to transform complex raw data into actionable business insights. This role focuses on designing building and maintaining scalable data pipelines using Azure Fabric and SSIS ensuring our Sales (SFDC) Finance (NAV/BC) and Product (MSC) data is unified and ready for advanced reporting in Power BI.



Skill Set & Expertise Requirements

Data Engineering: SSIS Azure Data Factory Azure Fabric (Pipelines Medallion Architecture)
Design end-to-end Medallion Architecture manage complex data migrations

Languages: Advanced SQL Python (Pandas/NumPy)
Proficiency in performance tuning indexing and complex Python-based data manipulation

Big Data: Apache Spark Azure Fabric Notebooks
Experience in distributed processing and PySpark-based notebook development.

Data Modelling: Kimball Methodology (Facts/Dimensions)
Deep understanding of dimensional modeling for BI performance.

BI & Reporting: Power BI DAX Power Query
Ability to create complex DAX measures and professional-grade storytelling dashboards.

Platforms: Gainsight SFDC NAV/BC Jira
Hands-on experience integrating these diverse data sources into a central warehouse.

Tools: Git (Version Control) MSPO
Essential for collaborative development and environment management.

Key Responsibilities
Data Engineering & ETL

Pipeline Development: Design and deploy end-to-end ETL/ELT processes using Azure Data Factory and Azure Fabric (Notebooks & Pipelines).
Architecture Management: Implement and maintain Medallion Architecture (Bronze/Silver/Gold) and Kimball Methodology (Star Schemas) to ensure high-performing Data Warehousing.

Legacy Maintenance: Manage existing SSIS packages to ensure seamless data flow from on-prem and cloud sources.
Reporting & Analytics

Dashboarding: Build sophisticated Power BI reports using Power Query for data transformation and DAX for complex calculations.
Platform Management: Administer the Power BI Service and manage data integration with Gainsight to drive Customer Success initiatives.

Source Integration: Extract and sync data from diverse sources including SFDC NAV/BC Jira and product usage data (MSC).
Database & Collaboration

SQL Optimization: Write and optimize complex Stored Procedures Views and Indexes for efficient data retrieval.
Version Control: Maintain codebase integrity using Git for version control and collaborative development.

Job Tags

Full time

Similar Jobs

Global Connect Technologies

Automotive Technician Job at Global Connect Technologies

 ...and evaluation. Minimum Qualifications High school diploma or GED required; Associate degree or technical certification in Automotive Technology, Diesel Technology, Agricultural Equipment Technology, or a related field preferred. Minimum of 2 years of experience... 

UMass Memorial Health

Sr EPIC Applications Systems Analyst EPIC OrdersResearchClinDoc Job at UMass Memorial Health

 ...implementation testing documentation maintenance and adoption of application software to effectively meet clinical or business information...  .../Education: Required: 1. High school diploma or GED. 2. Epic/Workday/Application certification(s) or ability to achieve as required... 

Twingate

Create your own role Job at Twingate

 ...SaaS, and on-prem resources. Twingate isbacked byleading investors such as BOND, WndrCo, 8VC, Green Bay Ventures, SignalFire, and Dropbox founders Drew Houston and Arash Ferdowsi. Our investors share our belief that in a world where workforces are becoming increasingly... 

Motion Recruitment

Global Brand Manager Job at Motion Recruitment

 ...offering a full benefits package ** Required Skills & Experience ~ Bachelors degree ~5+ years of experience working in theatrical/brand marketing ~ Experience working for entertainment/streaming/film clients ~ Experience working on print, social and retail ~... 

Neighborhood LTC Pharmacy Inc

Pharmacist [Full-time or Part-time] Job at Neighborhood LTC Pharmacy Inc

Description: Full-time or Part-time PharmacistsOklahoma City, OK Staff Pharmacist | Oklahoma City, OK | Full-Time or Part-Time | 100% Employee-Owned (ESOP)| WHY THIS ISN'T JUST ANOTHER PHARMACY JOB At Neighborhood LTC Pharmacy, you won't be counting by 5s in a retail...