Topline | Matthew Tieman

Homepage Find Professionals Matthew Tieman

Matthew Tieman

Data Architect at Perfect Company

Claim this Profile

Contact Information

us****@****om

(386) 825-5501

Gold Feature

Click to upgrade to our gold package
for the full feature experience.

Location

Portland

Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by

Topline AI

You need to have a working account to view this content.

Join now

You need to have a working account to view this content.

Join now

Experience

Perfect Company

United States
Software Development
1 - 100 Employee

Data Architect
- Jan 2022 - Present
Senior Data Engineer
- Dec 2019 - Dec 2021
Designing & developing SaaS multi-tenant data products based on a multi-cloud, data vault architecture, with a focus on IoT data.

Oregon Health Authority

United States
Government Administration
700 & Above Employee

Senior Data Architect
- Jul 2019 - Dec 2019
Salem, OR Lead database design of third generation Child Welfare Information System, known as OR-Kids. • Introduced modern database techniques: temporal tables, SQL CLR, schema modularization; use of new data types, geography, hierarchyid. • Introduced modern database procedures: SSDT Database Projects, Azure DevOps for deployment, Git for source code control. • Introduced graph database design techniques for building cohesive relational structures. • Designed system for… Show more Lead database design of third generation Child Welfare Information System, known as OR-Kids. • Introduced modern database techniques: temporal tables, SQL CLR, schema modularization; use of new data types, geography, hierarchyid. • Introduced modern database procedures: SSDT Database Projects, Azure DevOps for deployment, Git for source code control. • Introduced graph database design techniques for building cohesive relational structures. • Designed system for managing the codification, version control, and deployment of over 500 reference data sources. Show less

Oregon Mutual Insurance

United States
Insurance
100 - 200 Employee

Principal Data Architect
- 2018 - 2019
McMinnville, OR Architecture - Created the foundation and roadmap for a consolidated and flexible company wide business intelligence architecture - Used a data vault design pattern with curated reporting models and data access, across multiple lines-of-business, managing over 30,000 attribute mappings - Designed a robust, flexible, data driven data integration architecture with queryable data lineage, using T-SQL & SQL CLR C# - Institutionalized various data product groupings from tribal info, such… Show more Architecture - Created the foundation and roadmap for a consolidated and flexible company wide business intelligence architecture - Used a data vault design pattern with curated reporting models and data access, across multiple lines-of-business, managing over 30,000 attribute mappings - Designed a robust, flexible, data driven data integration architecture with queryable data lineage, using T-SQL & SQL CLR C# - Institutionalized various data product groupings from tribal info, such as product definition, claims management, agency/marketing/sales structuring; introduction of data governance process - Designed a retrofit of a 20-year-old star schema design data marts into modern stretch SQL Server database - Designed XSD for EDI with vendors Development / QA / Mentoring - Managed software development process for extending design of data warehouse from one to three LoB’s; delivered project one month early on a six month schedule and with no major defects - Reviewed and instituted standardized non-BI database designs, SSIS/SSRS and other database object implementations and usages - Modernized and mandated schema-centric source code control with state-based deployment using SSDT schema/data compares - Designed and lead development of multiple Proof of Concept projects to facilitate modularized system development - Designed an in-parallel, full-cycle data warehouse quality assurance framework & process - Provided department staff skills assessments and - Mentored and elevated performance and competency of junior data architect, SQL developers, DBA’s, and data analysts/scientists Show less