Senior Data Modeler

McClure Engineering Co.
New York, NY, United States
about 1 month ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
1 year minimum
Compensation
$114,400.0 - $124,800.0
Working hours
Regular working hours
Job source

Tech stack

Data Architecture Data Vault Modeling Data Warehousing Database Design Dimensional Modeling PostgreSQL Microsoft SQL Server SQL Azure Oracle (Applications) Oracle SQL Developer PowerDesigner Standard Sql
+5 more
Azure Data Factory Snowflake Physical Data Models Azure Synapse Analytics Databricks

Requirements

  • 8+ years of Data Modeling experience.
  • Strong Data Architecture and Dimensional Data Modeling skills.
  • Hands-on experience with ERwin, ER/Studio, PowerDesigner, or similar tools.
  • Strong SQL and database design expertise.
  • Experience with Oracle, SQL Server, Snowflake, Azure SQL, or PostgreSQL.
  • Strong Oracle PL/SQL experience - Mandatory.
  • Knowledge of Data Warehousing, Data Vault, and Dimensional Modeling.
  • Finance domain experience with:
  • General Ledger (GL)
  • Accounts Payable/Receivable (AP/AR)
  • Financial Reporting
  • Treasury
  • Regulatory & Risk Reporting

Nice to Have

  • Azure Databricks, Azure Data Factory, Synapse, or Snowflake.
  • Banking, Capital Markets, or Financial Services experience.
  • Knowledge of IFRS, US GAAP, or Basel regulations.
  • Strong communication, collaboration, and mentoring skills., * Data Modeler designing Conceptual: 7 years (Required)
  • Erwin, ER/Studio: 1 year (Required)
  • Finance Domain: 1 year (Required)

Work Location: Hybrid remote in New York, NY 10040

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…