JOB DESCRIPTION

Perform Data Architecture support for projects and enhancements

Craft and execute data management architecture integration and governance strategies Provide technical leadership for architecture design documentation and maintenance of databases and related systems creates database storage structures resolves database issues and maintains system security Support development and implementation of business applications that optimize statistical efficiency and data quality Identify analyze and interpret trends or patterns in complex data sets Review and approval of daily operational changes where required Monitor daily operations of data loads and identify data discrepancies data quality issues and work to ensure data consistency and integrity Prepare Data models At least five years of DBAdata development and data architecture experience combined PostgreSQLSnowpro for Snowflake certifications preferred Proficient with PostgreSQL Talend ETL and Snowflake Proficient in the use of data modeling tools and producingmaintaining logical and physical designs Strong ETL development knowledge SSIS ADF Azure Data Factory Boomi or equivalent and data warehouse architecture techniques Team experience including working closely with business professionals as well as technical resources and acting as a bridge between the two groups including liaison with vendors Experience in optimizing loading and processing large datasets from different data sources and formats Familiarity and experience with Medallion architecture