Senior Database Architect

Reach Marketing

Career Opportunities

Senior Database Architect

In Pearl River, New York, Reach Marketing LLC seeks a Senior Database Architect to ensure the continuous delivery of on-premises and public cloud-based infrastructure, data, and application architectural solutions from strategy to implementation; closely interact with the company’s business units, including our application, database services, Marketing Services, and client teams; define the Data Strategy, Data Warehousing Solutions, and Data Governance, and mature the end-to-end Data Management; develop database architectural strategies at the modeling, design, and implementation stages to address business or industry requirements; develop data models for applications, metadata tables, views, or related database structures; work as part of a project team to coordinate database development and determine project scope and limitations; collaborate with key stakeholders to define data requirements and align data initiatives with business needs; select methods, techniques, or criteria for data warehousing evaluative procedures; design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements; manage and utilize tools for cloud-based data warehouse development and deployment, such as ETL tools, data quality and cleansing tools, query/reporting tools, OLAP, and data modeling tools; design and develop high-volume data ingestion components and ETL solutions for data collection from a variety of internal and external sources; use SQL programming language expertise to write complex software packages to manipulate customer data contained in databases and data warehouses; ensure data quality and controls are in place to support diverse data ingestion, outflow, and flow processes; perform database administration tasks, including automation, performance monitoring, system tuning, and SQL query optimization; write new programs or modify existing programs to meet customer requirements using current programming languages and technologies; ensure data quality and controls are in place to support diverse data ingestion, outflow, and flow processes; assess database performance and optimize for more efficient processing; and define, document, and implement best practices and standard operating procedures for data integration and warehousing. Bachelor’s degree in Computer Science, Electronics Engineering, Information Systems, or a closely-related field; two years of relevant experience; experience designing and developing complex integration data flow architectures; experience with Data warehousing software including ETL, logical and physical data modeling, SQL and data access optimization, and reporting and analytics; proficiency with data management and visualization tools such as SQL, Python, Tableau, or PowerBI; experience delivering cloud data warehouse solutions and related components successfully; strong knowledge of SQL databases, APIs, and cloud data warehousing platforms; technical experience with global data warehousing, including strategy, architecture, design, and production support; strong communication skills; knowledge of T-SQL and Microsoft SQL Server 2015 or later; knowledge of ETL/Data Processing tools; knowledge of SSIS, Alteryx, and Matillion tools; experience with data management tools including SSMS, Coginiti, and Query software; and proficiency with C# required. Salary $103,000.00/yr. Send resume to Chris Longo, COO, at chris.longo@reachmarketing.com with reference code “8-W”.