Data Warehouse Architect at Buxton

Fort Worth, Texas, United States -

Full Time

Start Date

Immediate

Expiry Date

15 Apr, 26

Salary

0.0

Posted On

15 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Warehouse, ETL, T-SQL, SQL Tuning, Relational Database Theory, Communication, Collaboration, Problem Solving, Attention to Detail, Excel

Industry

Software Development

Description

If you love data and having your hand in every step of a project, our Data Warehouse Architect role is for you. This role requires cross-functional work with our analysts, project managers, account managers and sales team members, as well as working directly with client’s key stakeholders. Applicants for employment in the U.S. must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States and with Buxton (i.e., H1-B visa, F-1 visa (OPT), TN visa or any other non-immigrant status). What you’ll do Communicating with key team members regarding project scope, progress and findings for everything related to data Working in a team environment where brainstorming, innovation, and collaboration is critical while also maintaining personal responsibility for completion of assigned projects on time and of high quality Leveraging ETL tools to automate the flow of data of various data elements within the Buxton ecosystem Innovating new ways to standardize existing data processes and optimizing current workflows Creating custom client facing reports Creating custom data sets for use by analysts within your team What you bring to the table: Bachelor’s degree (Master’s preferred) in Computer Science, Information Systems, Mathematics, Economics, Decision Science, or related field 2+ years of experience creating and troubleshooting T-SQL Procedures, Views, Functions, Triggers, etc. 2+ years of experience creating and troubleshooting ETL processes (SSIS, Alteryx, Informatica) 2+ years of experience creating and maintaining reports Knowledge of SQL Tuning, Monitoring, and Performance measurement Ability to read, understand, and alter existing T-SQL when necessary Solid understanding of Relational Database Theory Excellent verbal and written skills and the ability to thrive in a team environment Aptitude to solve complex problems autonomously and attention to detail Nice to have: Experience working with data related to consumer marketing Intermediate Excel knowledge (V-lookups, pivot tables, macros, etc)

Responsibilities

The Data Warehouse Architect will communicate with team members regarding project scope and progress, while also leveraging ETL tools to automate data flow. They will innovate new ways to standardize data processes and create custom reports and data sets for analysts.