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.
Company Description
Sarian Solutions Inc.
Trusted Partner for your all IT Needs.
Job DescriptionTitle: Sr. Data Modeler (ERWIN or Sybase power designer)
Location: Charlotte, NC
Type: Full-Time
Required Skills/Experience:
- Minimum 10 years of experience in design and deployment of logical and physical structures preferably Banking Risk Area (Counterparty Credit Risk Data Domain knowledge)
- Minimum 5 years of Experience with Erwin data modeling tools
- Minimum 5 years of Experience with development and deployments MSSQL platform
- Experience with large, high volume databases is preferred.
- Experience performing data profiling
- Experience in Data Mart, Dimensional Modeling, Data Warehouse modeling
- Ability to work successfully with technical and non-technical groups, and manage multiple tasks at a time
- Strong analytical, problem-solving and communication skills
- In-depth understanding of both Relational and Domain Modeling techniques
- Understanding about BI Reporting
Responsibilities :
- Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems.
- Understand database performance factors and trends pertaining to very large database design and collaborate with DBAs to implement mitigating physical modeling solutions.
- Perform source data analysis, data discovery and data profiling.
- Provide data structures optimized for information entry and retrieval.
- Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures.
- Support development team during design process design and during performance tuning.
- Participate in both business & IT planning and in the development & management of project plans.
- Lead design of Logical and Physical Models
- Support ongoing data modeling efforts for Development and Production environments
- Contribute to development of processes and guidelines for Data Modeling
Thanks
Vick Walters
Sarian Solutions
an IT solutions company
Ph: 732.790.2266 Ext: 209 | Fax: 732-790-0944
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
.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
Information Technology • Productivity • Software • Infrastructure as a Service (IaaS)
Leads performance engineering across the organization by designing load-testing and data-generation frameworks, defining benchmarks and standards, analyzing application, database, and system behavior, and guiding teams in performance optimization. Builds reusable tooling and best practices using k6, JavaScript, Grafana, and InfluxDB while addressing scalability, latency, throughput, and reliability challenges in distributed cloud-native systems.
Top Skills:
AWSBashC++DockerGoGrafanaInfluxdbJavaJavaScriptK6KotlinPostgresPython
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
