Data Modeler

We are

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 17000+, and has 58 offices in 22 countries within key global markets.

Our challenge:

We are seeking an experienced Data Modeler to design, develop, and maintain scalable data models that support business intelligence, analytics, reporting, and operational data needs. The ideal candidate will have data modeling, database design, data architecture, and working with cross-functional technology and business teams. The successful candidate will translate business requirements into robust conceptual, logical, and physical data models while ensuring data quality, consistency, security, scalability, and performance across enterprise data platforms.

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 $100k - $110k/year & benefits (see below).

The Role

Responsibilities:

• Design and maintain conceptual, logical, and physical data models for enterprise applications, data warehouses, data lakes, and data marts.
• Analyze business and technical requirements and translate them into effective data structures and models.
• Define entities, attributes, relationships, keys, constraints, business rules, and data definitions.
• Develop dimensional models, including star and snowflake schemas, fact tables, dimension tables, and slowly changing dimensions.
• Support relational, dimensional, NoSQL, and cloud-based data modeling initiatives.
• Collaborate with data architects, engineers, analysts, application teams, product owners, and business stakeholders.
• Establish and maintain data modeling standards, naming conventions, design patterns, and best practices.
• Ensure data models support scalability, performance, data integration, reporting, analytics, and regulatory requirements.
• Review and optimize existing data models for performance, maintainability, and extensibility.
• Create and maintain data dictionaries, metadata repositories, source-to-target mappings, and model documentation.
• Participate in data governance activities, including data quality, lineage, ownership, classification, and stewardship.
• Work closely with ETL/ELT developers to support data ingestion, transformation, and integration processes.
• Identify data redundancies, inconsistencies, and gaps and recommend appropriate solutions.
• Assist with database design, indexing, partitioning, normalization, denormalization, and performance optimization.
• Support data migration, modernization, and integration projects.
• Review proposed database and application changes for alignment with enterprise data architecture.
• Present data model designs and recommendations to technical and non-technical stakeholders.
• Mentor junior data modelers and contribute to the continuous improvement of modeling practices.

Requirements:

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
• Experience in data modeling, database design, data architecture, or a related discipline.
• Strong experience developing conceptual, logical, and physical data models.
• Hands-on experience with relational database management systems such as Oracle, SQL Server, PostgreSQL, MySQL, Teradata or similar platforms
• Strong SQL skills and understanding of database structures and query optimization.
• Experience with dimensional modeling and data warehousing concepts.
• Proficiency with one or more data modeling tools, such as Erwin Data Modeler, ER/Studio, SAP PowerDesigner, IBM InfoSphere Data Architect, Lucidchart or similar tools
• Experience with data integration, ETL/ELT processes, and source-to-target mapping.
• Understanding of data governance, metadata management, data quality, and data lineage.
• Strong knowledge of normalization, denormalization, indexing, partitioning, and performance considerations.
• Ability to interpret complex business requirements and convert them into scalable data solutions.
• Excellent communication, documentation, analytical, and problem-solving skills.

Preferred, but not required:

• Experience with data lake, lakehouse, and modern analytics architectures.
• Familiarity with NoSQL databases such as MongoDB, Cassandra, DynamoDB, or Cosmos DB.
• Knowledge of master data management and reference data management.
• Experience with data catalog and governance tools such as Collibra, Alation, Informatica, or Microsoft Purview.
• Understanding of distributed systems, microservices, APIs, and event-driven architectures.

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.

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.