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
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
Fintech
Design and deliver enterprise conceptual, logical, and physical data models across multiple platforms. Lead data strategy, create source-to-target mappings, DDL/DML scripts, and ETL/design documentation. Collaborate with architects, engineers, and business stakeholders to implement scalable Snowflake/AWS data warehouses, lakes, and reporting solutions; mentor junior modelers and advise senior leadership.
Top Skills:
AWSData LakeData WarehouseDdlDmlErwinETLHadoopMdmMicrosoft Sql ServerOdsOltpOraclePostgresPythonSap Power DesignerSnowflakeSQLSql DeveloperToad
.png)
Healthtech
Design and document conceptual, logical, and physical data models (relational, dimensional, NoSQL). Support data architecture and governance, produce DDL/SQL, design Snowflake Silver/Gold analytical layers, mentor other modelers, and map healthcare sources to FHIR resources when applicable.
Top Skills:
DdlDimensional ModelingEr ModelingErstudioHl7 FhirNoSQLSnowflakeSQL
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
