Data Analyst with ERP, Data Modeling, GCP, and SQL Experience | New Jersey, NJ(onsite)

Job Title: Data Analyst with ERP, Data Modeling, GCP, and SQL Experience Location: New Jersey, NJ(onsite) Duration: Long Term Note: Data Analyst with ERP, Data Modeling, GCP, and SQL Experienc e Job Descriptio n:Key Responsibiliti • esRequirement Gathering & Mapping: Partner with Sales, Finance, and Operations SMEs to understand business requirements, identify critical data elements, and document source-to-target mappings (STTM) for the GCP Data Lak • e.Canonical Data Modeling: Collaborate with SMEs and data architects to define and document the enterprise canonical model, ensuring standard definitions, naming conventions, and data types across different domain • s.Technical Specifications: Translate business logic and KPIs into rigorous technical requirements, user stories, and acceptance criteria for the GCP Data Engineering tea • m.Gap & Impact Analysis: Profile source data to identify data quality issues, anomalies, and structural gaps between legacy sources and the target canonical mode • l.KPI & Data Validation: Define the testing and validation criteria to ensure that migrated data accurately populates downstream business KPIs. Perform UAT (User Acceptance Testing) to sign off on engineered data pipeline • s.Data Governance & Documentation: Maintain the data dictionary, business glossary, and lineage metadata within our data catalog tool (e.g., GCP Dataple • x)Required Skills & Qualificatio • nsExperience: 4+ years of experience as a Data Analyst, Business Systems Analyst, or Data Product Owner, with a proven track record in Data Lake, Data Warehouse, or MDM (Master Data Management) implementation • s.Domain Knowledge: Proven experience working with data domains in Sales (e.g., CRM, pipelines), Finance (e.g., ERP, general ledger), and/or Operation • s.Technical Skill • s:Advanced SQL: Ability to write complex queries to profile data, analyze schemas, and validate pipeline output • s.Data Modeling: Solid understanding of data modeling concepts (e.g., Star Schema, Snowflake, Inmon vs. Kimball, and Canonical/Universal modeling • ).Cloud Exposure: Familiarity with cloud data concepts. Direct experience with Google Cloud Platform (BigQuery, Cloud Storage, Dataplex) is highly preferre d.