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
.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
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Lead full‑stack engineering for enterprise retail solutions: set technical direction, design and build scalable frontend/backend systems and APIs, drive operational excellence, mentor engineers, and partner with customers and product teams to deliver resilient, high‑scale commerce platforms.
Top Skills:
APIsAutomated TestingCi/CdCloudDatabasesDevOpsFrontend Ui/UxGoGoJavaMicroservicesNext.JsNode.jsObservabilityPythonReactTypescript
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Build and maintain end-to-end enterprise retail applications across frontend, backend, APIs, databases, and cloud. Influence architecture, write high-quality tested code, mentor engineers, automate development and operations, and evaluate modern tools for scalable, secure, and maintainable systems.
Top Skills:
APIsDatabasesDevOpsGoJavaMicroservicesNext.JsNode.jsObservabilityPythonReactTypescript
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
