SQL Server Database Analyst

Buxton is the leader in customer intelligence solutions and technology. We use science to identify, track, measure, and predict everything about customer behavior all over the globe. We build technology that makes this customer intelligence easily accessible to our clients, empowering them to make the best growth investments possible.

We are a trusted partner for many of the most well-respected, healthcare, retail, restaurant, and hospitality companies across the US and internationally.

If you love data and having your hand in every step of a project, our SQL Server Database Analyst 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.

What you'll do

• Communicate with key team members regarding project scope, progress and findings for everything related to data
• Work 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
• Leverage ETL tools to automate the flow of data of various data elements within the Buxton ecosystem
• Innovate new ways to standardize existing data processes and optimize current workflows
• Create custom client facing reports
• Create custom data sets for use by analysts within your team

Requirements

What you'll bring

• Bachelor’s degree in Computer Science, Information Systems, Mathematics, Economics, Decision Science, or related field
• Experience creating and troubleshooting T-SQL Procedures, Views, Functions, Triggers, etc.
• Experience creating and troubleshooting ETL processes (SSIS, Alteryx, Informatica)
• 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 and creating data for data visualization tools (Tableau, PowerBI)
• Experience working with data related to consumer marketing
• Intermediate Excel knowledge (V-lookups, pivot tables, macros, etc)

Benefits

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA)
• Life Insurance (Basic, Voluntary & AD&D)
• Generous Paid Time Off
• Short Term & Long Term Disability
• Training & Development

Here at Buxton, we believe strongly that we benefit from diversity and encourage applicants from underrepresented backgrounds to apply. We value inclusion and welcome diverse viewpoints. Upon hire, a successful background check is required. Unfortunately, we are unable to sponsor work visas at this time.