Data Architect Principal

Why you'll LOVE Sagent:

 

You could work anywhere. We know you are talented and looking for something inspiring and impactful. A place where you will make a difference and have a great time doing it!

 

By choosing Sagent, you can be part of our mission to make loans and homeownership simpler and safer for all consumers.

 

Sagent powers servicers and consumers. You power Sagent!

 

 

JOB SUMMARY
The Data Architect Principal position plays a key role in providing key data modeling and integration support and contributions as part of Sagent Enterprise Data Analytics and Architecture team.   

• This position needs to foster innovative thinking in the cloud-first, data-first paradigms; and very high focus on quality and timeliness of deliverables.
• This position will serve as a key liaison between Business stakeholders and IT; working closely with business groups to understand their needs and define system requirements through fact finding and research. 
• This position is critical to driving the strategic value of data and application infrastructure. 

ESSENTIAL JOB FUNCTIONS

• The Data Architect is responsible for designing and developing data architecture patterns and data models that accurately represent the organization's data requirements. They work with business stakeholders to identify key data elements and design models that meet the organization's needs. 
• Design & Build ETL/ELT frameworks.
• Work with large and complex data sets to identify patterns, trends, and insights. Use statistical analysis techniques and data visualization tools to interpret the data and provide meaningful insights to the organization.
• Maintain data models to ensure that they are accurate and up-to-date. They monitor data quality and work with data engineers to resolve any issues. 
• Establish and maintain comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Understands the flow of data, business processes/technical interfaces that would be created or impacted and Provide data mappings requirements, user interface specifications, processing logic as per business requirements to the ETL team.
• Coordinate with Business partners, Technical Analysts and Developers to identify and define specifications, indicate areas of system impact and continuously communicate project status and needs.
• Manages change control processes and ensures program/project communications. 
• Strong leadership, communications, and presentation skills with the ability to clearly communicate status to senior management team. 
• Analyzes current state and conceives desired future state; and conceives projects needed to close the gap between current and future goals.
• Other duties as assigned. 

EDUCATION / EXPERIENCE REQUIREMENTS

Must have 

• 12+ years of experience as a data modeler, developer, data warehouse consumer and / or data related operations
• 3+ Years of working experience or exposure to Azure, GCP or any other Cloud development and deployment practices.
• 4+ Years of Experience with data modeling tools such as ERwin, ER/Studio, or PowerDesigner.
• 4+ Years of Experience working with Talend & DataStage
• 4+ Years of Experience working with RDBMS technologies (SQL Server, Postgres, Oracle)
• 4+ Years of Experience working with advanced SQL techniques
• 1+ Years of Experience working with Python & PySpark
• 1+ Years of Experience working with Snowflake
• 3+ years of experience in implementing dimensional data warehouse on Snowflake.
• 3+ years of experience with deployments via devops CI/CD pipelines.
• Graduation from a 4-year college or university with major course work in a discipline related to the requirements of the position is preferred. 
• Ability to astutely operate in the organization, and being able to emphasize methodology, modeling and (Data, Process and Application) governance.
• Hands-On, working knowledge of .Net, Java and SQL language, (i.e. T-SQL (Microsoft)
• Mid-level to expert knowledge in data int