Senior Data Modeler with 8-10 years experience to design and implement relational and dimensional data models using ERWIN. Must write SQL scripts against SQL Server/Oracle, support DW/ODS/ETL processes, collaborate with teams, and possess mandatory investment domain and asset management data expertise.
Company Description
Qualifications
- Senior profile with 8-10 years experience
- Hands on experience on Data Modeling (Relational and Dimensional Data Modeling)
- Working experience on ERWIN
- Should have experience on working on SQL Server/Oracle databases/Creating scripts
- Knowledge of DW/ODS/ETL
- Good communication skills and team player
- Investment Domain knowledge is mandatory.
- Experience with Asset Management data is mandatory .
Similar Jobs
Greentech • Other
Develop and govern enterprise conceptual, logical, and physical data models across business domains. Establish modeling standards, metadata practices, data definitions, and governance processes. Design integration patterns supporting ERP, CRM, cloud, warehouse, data mesh, and data fabric environments. Collaborate with business and technical stakeholders, optimize data structures, document lineage, mentor junior professionals, and ensure model alignment with enterprise architecture and data strategy.
Top Skills:
AlationAWSCollibraCRMData FabricData LakesData MeshData VaultData WarehousesEr/StudioErpErwinGCPMaster Data ManagementAzureOraclePowerdesignerSAPSnowflake
Information Technology • Business Intelligence • Consulting
Designs and maintains conceptual, logical, physical, canonical, conformed, and dimensional data models for enterprise data warehouses, lakehouses, data products, BI, and AI initiatives. Defines facts, dimensions, KPIs, metadata, governance, lineage, and data quality standards. Partners with governance, product, engineering, architecture, and business teams, leading model reviews and translating requirements into reusable data domains and products.
Top Skills:
Ai/MlAlationAWSBi/AnalyticsCanonical Data ModelingCollibraData GovernanceData LineageData MeshData WarehouseDatabricksDimensional ModelingDomain-Driven DesignErwinLakehouseMedallion ArchitectureMetadataSemantic Data LayersSnowflakeSQL
Information Technology • Software • Consulting • Cybersecurity
Lead design and deployment of logical and physical data models for transactional and analytical systems. Perform source analysis, data profiling, and collaborate with DBAs for performance tuning. Support development teams during design and implementation, contribute to modeling processes and guidelines, and participate in business and IT planning for data initiatives.
Top Skills:
Bi ReportingData MartData ProfilingData WarehouseDimensional ModelingErwinMicrosoft Sql Server (Mssql)OltpSybase Powerdesigner
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
