About Trantor

Trantor is a technology services company focused on outsourced product development and digital re-engineering.  Leveraging our CaptiveCoE™ engagement model, we operate as a seamless extension of our clients’ teams to provide rapid scalability with predictable budgets.  Founded in 2012, Trantor has worked with customers across Tech, FinTech, Media & Cyber Security industries. We have centers in the US, India, Canada, and Costa Rica. We are consistently rated as the #1 employer in the region with the ability to attract and retain technical talent. Our commitment to excellence and impactful results has translated to long-term relationships and value for our clients and solution partners Please visit us at:  https://trantorinc.com

 In this critical role, you’ll design scalable and organized data architectures, integrate diverse systems, and establish clear governance frameworks to ensure the quality, reliability, and accessibility of our data. 

This role is ideal for a driven professional who thrives in solving challenges that arise from fragmented or inconsistent data and who is eager to implement systems that empower teams to focus on strategic objectives rather than firefighting data issues. If you’re passionate about shaping data strategy and governance while tackling real-world challenges with a hands-on approach, we’d love to hear from you!

Role and Responsibilities

• Data Organization and Governance: Define and maintain governance standards that span multiple systems (AWS, Fivetran, Snowflake, PostgreSQL, Salesforce/nCino, Looker), ensuring that data remains accurate, accessible, and organized across the organization.
• Solve Data Problems Proactively: Address recurring data issues that sidetrack operational and strategic initiatives by implementing processes and tools to anticipate, identify, and resolve root causes effectively.
• System Integration: Lead the integration of diverse systems into a cohesive data environment, optimizing workflows and minimizing manual intervention.
• Hands-On Problem Solving: Take a hands-on approach to resolving reporting issues and troubleshooting data challenges when necessary, ensuring minimal disruption to business operations.
• Collaboration Across Teams: Work closely with business and technical stakeholders to understand and solve our biggest challenges
• Mentorship and Leadership: Guide and mentor team members, fostering a culture of accountability and excellence in data management practices.
• Strategic Data Support: Ensure that marketing, analytics, and other strategic initiatives are not derailed by data integrity issues, enabling the organization to focus on growth and innovation

Technical Skills

• Proficiency with AWS AppFlow, S3, Lambda and Fivetran for data processing and integration across platforms.

• Expertise in PostgreSQL and Snowflake, including SnowSQL, Snowpipe, and advanced data warehousing concepts.

• Strong experience with Salesforce (including nCino), including API integration and data modeling.
• Strong experience with Looker’s LookML language and best practices in development
• Understanding of data modeling techniques and experience designing modern, scalable data architecture

Data Governance

• Familiarity with Secoda or similar tools for managing data governance, metadata, and documentation.
• Experience in designing and enforcing data governance frameworks, including establishing data dictionaries, standards, and policies to ensure consistency and quality.
• Proven ability to work with product development and business teams to integrate governance processes into system designs and workflows, ensuring alignment with organizational objectives.
• Expertise in managing large datasets with numerous fields, addressing organizational challenges by creating clear documentation and streamlined processes for field usage and ownership.

Nice-to-Have Skills:

• Familiarity with RESTful APIs and Salesforce APIs.
• Knowledge of financial services, particularly Loan Origination Systems (LOS), credit risk, and predictive analytics.