5-7 years of experience in Data Modeling and Data Architecture.
Proficient with data modeling tools like Erwin, ER/Studio, or PowerDesigner.
Strong SQL skills and understanding of relational databases.
Experience with major databases such as Oracle, SQL Server, and Snowflake.
Familiarity with Data Warehousing and ETL processes.
Knowledge of data governance and metadata management.
Experience with cloud platforms like AWS or Azure.
Responsibilities
Design and develop data models for enterprise applications and data warehouses.
Translate business requirements into effective data structures.
Maintain data dictionaries, metadata, and data governance documentation.
Develop dimensional models for reporting and analytics.
Collaborate with data architects and business teams.
Perform data profiling and quality assessments.
Optimize database performance through effective modeling.
Benefits
Highly competitive compensation and benefits package.
Opportunity to work in a multinational organization with global offices.
10 days of paid annual leave plus sick leave and holidays.
Comprehensive insurance plan including medical and dental coverage.
Retirement savings plans and higher education certification policy.
Extensive training opportunities and access to Udemy for Business.
Coaching opportunities with experienced colleagues.
Full Job Description
Our challenge
We are seeking an experienced Data Modeler to design, develop, and maintain conceptual, logical, and physical data models that support enterprise data initiatives. The ideal candidate will work closely with business stakeholders, data architects, ETL developers, and analytics teams to ensure data structures are scalable, efficient, and aligned with business requirements.
Additional Information*
The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Charlotte, NC is $95k - $100k/year & benefits (see below).
The Role
Responsibilities:
Design and develop conceptual, logical, and physical data models for enterprise applications and data warehouses.
Analyze business requirements and translate them into effective data structures.
Create and maintain data dictionaries, metadata, data lineage, and data governance documentation.
Develop dimensional models including Star and Snowflake schemas for reporting and analytics.
Collaborate with data architects, ETL developers, DBAs, and business teams.
Perform data profiling, data quality assessments, and data validation.
Optimize database performance through efficient data modeling techniques.
Ensure compliance with data governance, security, and regulatory standards.
Support data migration, integration, and modernization initiatives.
Review and recommend improvements to existing data models and database designs.
Requirements:
Strong experience in Data Modeling and Data Architecture.
Hands-on experience with Erwin, ER/Studio, PowerDesigner, or similar data modeling tools.
Expertise in SQL and relational database concepts.
Experience with databases such as Oracle, SQL Server, PostgreSQL, Snowflake, Teradata, or DB2.
Strong understanding of Data Warehousing, ETL processes, and dimensional modeling.
Knowledge of data governance, metadata management, and data lineage concepts.
Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP).
Strong analytical, problem-solving, and communication skills.
Preferred, but not required:
Experience with Big Data technologies and modern data platforms.
Knowledge of Data Vault modeling techniques.
Experience in Agile/Scrum environments.
Certification in data management or cloud technologies is a plus.
We offer:
A highly competitive compensation and benefits package.
A multinational organization with 58 offices in 22 countries and the possibility to work abroad.
10 days of paid annual leave (plus sick leave and national holidays).
Maternity & paternity leave plans.
A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region).
Retirement savings plans.
A higher education certification policy.
Commuter benefits (varies by region).
Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
Cutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms.
A flat and approachable organization.
A truly diverse, fun-loving, and global work culture.
About Synechron
Synechron is a digital consulting firm that provides technology solutions to financial services companies. The company's services include digital, business consulting, technology, and data analytics. Synechron serves customers in the banking, capital markets, insurance, and asset management industries. The company has offices in North America, Europe, Asia, and the Middle East.
