SQL DeveloperSan Francisco, California, United States.

About us

AgilOne's vision is to restore the personal relationships companies once had with customers before channel-specific marketing silos got in the way. Through a single view of customers across all channels, predictive models to understand customer behavior, and real-time APIs to orchestrate personalized experiences across all touchpoints, AgilOne creates authentic omni- channel customer relationships that maximize lifetime value.

SQL Developer

San Francisco | California | United States

AgilOne is looking for a SQL Developer for our Sustained product platform. The successful candidate will be responsible for analysis, design and development of client unique solutions for clients on our SQL Server based platform. In addition to SQL programming, is ETL development using SSIS as well a proprietary data replication system will be performed and supervised. Coding Change Control is managed using Github. Successful candidate will assist in management of offshore resources, working with developers on designing solutions, testing and verifying results. Knowledge of SSAS and related products used in development of customer facing cubes is beneficial, but not required. Interaction with client users and technical resources on an as-needed basis is required.

Responsibilities:
    • Work with Team Leader and Client Services Manager to translate client requirements into proposed solutions
    • Design solutions for optimal use of AgilOne standard Universal Data Model (UDM) platform with project team
    • Coding of solutions, and / or working with assigned additional resources to develop
    • Interact with Client Support team on resolution of production problems and system monitoring exceptions
    • Development and modifications to SSIS packages
    • Validate Cube solutions
    • Interact with Engineering Team on problem identification and resolution as needed
    • Generating postal reporting and statementInteraction with client users and technical resources
    • Manage Change Control using Github


Qualifications:
    • High proficiency in SQL is required (Solid skills in T-SQL)
    • Writing and understanding Microsoft SQL.
    • Writing SQL statements, stored procedures and views using industry best practices for security and efficiency.
    • Experience working with data warehouses in the 200GB-2TB range, dealing with multiple fact tables, each with billions of rows as well as tens to hundreds of dimensions
    • Attention to detail and good quality assurance skills
    • Solid Excel skills
    • Good written and verbal communication skills
    • Able to work independently and provide technical supervision
    • Familiarity with normalized and denormalized structures beneficial
    • Microsoft certification is a plus
    • Bachelor's Degree in Computer Science or equivalent experience


The AgilOne Story

AgilOne, the Customer Data and Engagement Hub, provides enterprise consumer marketers the power to integrate customer data across digital, physical, and mobile channels, deliver customer analytics with predictive insights and 360-degree profiles, and engage customers at every touch point in order to maximize lifetime value. Currently, the AgilOne solution supports more than 150 brands worldwide.

We leverage the latest technologies in big data, machine learning and data quality management to deliver an enterprise-grade, scalable and high performance tool for customers such as Tumi, Lululemon, Lilly Pulitzer and David's Tea.AgilOne is funded by the best in the Valley - Sequoia Capital, Tenaya, and Mayfield.

A fun environment to work hard and play harder with passionate people building great products!

• Competitive compensation

• Excellent benefits

• Equity

• 401k

• Catered lunches, snacks and beverages

I'm interested

Not ?

Thank you. Please wait while we forward you to the application.

Similar Jobs

Senior Data Engineer

MapR Dallas Texas United States Dallas, Texas, United States
Description The Senior Data Engineer will report into MapR's Professional Services Organization. MapR Data Engineers are responsible for delivering a variety of engineering services to MapR customers throughout North America. Assignments will vary...

React / JavaScript / Full Stack Developer (experience required)

InfluxData San Francisco California United States San Francisco, California, United States
As a member of our front-end engineering team, you'll be responsible for creating Chronograf, an open source application for visualizing data from InfluxDB, the open source time-series database. These visualization tools form part of a multi-tiere...

Data Scientist Intern

Agilone San Francisco California United States San Francisco, California, United States
AgilOne, the Customer Data Platform provides enterprise consumer marketers the power to integrate customer data across digital, physical, and mobile channels, deliver customer analytics with predictive insights and 360-degree profiles, and engage ...

SQL Server Database Developer

Webroot Broomfield Colorado United States Broomfield, Colorado, United States
Are you a skilled database professional with passion for development seeking to take your career to the next level? If so, the SQL Server Developer role at Webroot could be the perfect opportunity for you. In this role, you will serve in a high-pr...

DBA/SQL Developer

Webroot Derby England United Kingdom Derby, England, United Kingdom
Webroot are a market leader specializing in threat intelligence. We operate with a cloud-based security analysis architecture designed for next-generation protection. Our Derby Research and Development team currently seek an SQL Database Developer...

Other opportunities in AgilOne

Implementation Consultant

Agilone San Francisco California United States San Francisco, California, United States
In the AgilOne Professional Services team, our job is to design, configure, and deploy the most powerful solutions that the AgilOne Platform can offer. We are looking for someone who loves data and delivering optimal technical outcomes.As a Implem...

Implementation Consultant

Agilone Sunnyvale California United States Sunnyvale, California, United States
In the AgilOne Professional Services team, our job is to design, configure, and deploy the most powerful solutions that the AgilOne Platform can offer. We are looking for someone who loves data and delivering optimal technical outcomes.As a Implem...

Sr. Software Engineer - Java

Agilone Manila Metro Manila Philippines Manila, Metro Manila, Philippines
AgilOne, the Customer Data and Engagement Hub, provides enterprise consumer marketers the power to integrate customer data across digital, physical, and mobile channels, deliver customer analytics with predictive insights and 360-degree profiles, ...

Principal Big Data Operations Engineer

Agilone Sunnyvale California United States Sunnyvale, California, United States
We're looking for a leader in our technical operations team, a core team in our cloud service delivery. This leader will be working with our product engineering team to build out our system both tactically and strategically. Our customer base is r...

SQL Developer

Agilone San Francisco California United States San Francisco, California, United States
AgilOne is looking for a SQL Developer for our Sustained product platform. The successful candidate will be responsible for analysis, design and development of client unique solutions for clients on our SQL Server based platform. In addition to SQ...

Data Engineer Intern

Agilone Sunnyvale California United States Sunnyvale, California, United States
AgilOne looking for a Data Engineer Intern to join us as we design and build the cutting edge, enterprise-grade customer data platform that processes hundreds of millions of records from these customer sources daily, and processes through billions...

Data Analyst Intern

Agilone Sunnyvale California United States Sunnyvale, California, United States
AgilOne is looking for a Data Analyst Intern to join our team. One will be responsible for designing, building and deploying complex technical custom projects. In order to succeed in this position, you should be autonomous, analytical, a self-star...

Data Scientist Intern

Agilone San Francisco California United States San Francisco, California, United States
AgilOne, the Customer Data Platform provides enterprise consumer marketers the power to integrate customer data across digital, physical, and mobile channels, deliver customer analytics with predictive insights and 360-degree profiles, and engage ...

Java Engineer Intern

Agilone Sunnyvale California United States Sunnyvale, California, United States
AgilOne is looking for smart, motivated interns to join our engineering team working on our next generation big data analytics product. The product is built on the latest big data and frontend technologies and imports, cleans and analyzes billions...

Principal Java Software Engineer

Agilone Sunnyvale California United States Sunnyvale, California, United States
AgilOne, the Customer Data and Engagement Hub, provides enterprise consumer marketers the power to integrate customer data across digital, physical, and mobile channels, deliver customer analytics with predictive insights and 360-degree profiles, ...

Solution Architect

Agilone San Francisco California United States San Francisco, California, United States
In the AgilOne Professional Services team, our job is to design, configure, and deploy the most powerful solutions that the AgilOne Platform can offer. We are looking for someone who loves data and delivering optimal technical outcomes.As a Soluti...

Solutions Consultant Intern

Agilone San Francisco California United States San Francisco, California, United States
AgilOne, the Customer Data Platform provides enterprise consumer marketers the power to integrate customer data across digital, physical, and mobile channels, deliver customer analytics with predictive insights and 360-degree profiles, and engage ...

Customer Success Manager

Agilone Istanbul Istanbul Turkey Istanbul, Turkey
AgilOne's Customer Success Manager (CSM) is responsible for developing long-term relationships with the portfolio of assigned customers, connecting with key business executives and stakeholders, and developing an understanding of their business re...

Big Data QA Lead

Agilone Sunnyvale California United States Sunnyvale, California, United States
AgilOne is looking for a smart, motivated quality assurance lead engineer to join our engineering team working on our next generation big data analytics product. The product is built on the latest big data and frontend technologies and imports, cl...

Solution Architect

Agilone Sunnyvale California United States Sunnyvale, California, United States
In the AgilOne Professional Services team, our job is to design, configure, and deploy the most powerful solutions that the AgilOne Platform can offer. We are looking for someone who loves data and delivering optimal technical outcomes. As a Solu...

Associate Project Manager

Agilone San Francisco California United States San Francisco, California, United States
AgilOne's Associate Project Manager on the Customer Success team is responsible for helping to develop relationships with a portfolio of assigned customers, connecting with day-to-day users, and developing an understanding of their business requir...

Associate Project Manager

Agilone Sunnyvale California United States Sunnyvale, California, United States
AgilOne's Associate Project Manager on the Customer Success team is responsible for helping to develop relationships with a portfolio of assigned customers, connecting with day-to-day users, and developing an understanding of their business requir...

Solution Architect

Agilone Istanbul Istanbul Turkey Istanbul, Turkey
In the AgilOne Professional Services team, our job is to design, configure, and deploy the most powerful solutions that the AgilOne Platform can offer. We are looking for someone who loves data and delivering optimal technical outcomes. As a Solu...

Database Architect

Agilone Manila Metro Manila Philippines Manila, Metro Manila, Philippines
AgilOne is looking for a Database Architect to join our team. One will be responsible for designing, building and deploying complex technical custom projects. In order to succeed in this position, you should be autonomous, analytical, a self-start...

Data Analyst

Agilone Istanbul Istanbul Turkey Istanbul, Turkey
AgilOne is looking for a Data Analyst to join our team. One will be responsible for designing, building and deploying complex technical custom projects. In order to succeed in this position, you should be autonomous, analytical, a self-starter and...

Associate Technical Account Manager

Agilone Sunnyvale California United States Sunnyvale, California, United States
AgilOne's Customer Success Account Coordinator on the Customer Success team is responsible for helping to develop relationships with a portfolio of assigned customers, connecting with day-to-day users, and developing an understanding of their busi...

Associate Technical Account Manager

Agilone San Francisco California United States San Francisco, California, United States
AgilOne's Customer Success Account Coordinator on the Customer Success team is responsible for helping to develop relationships with a portfolio of assigned customers, connecting with day-to-day users, and developing an understanding of their busi...

Solution Architect

Agilone Manila Metro Manila Philippines Manila, Metro Manila, Philippines
In the AgilOne Professional Services team, our job is to design, configure, and deploy the most powerful solutions that the AgilOne Platform can offer. We are looking for someone who loves data and delivering optimal technical outcomes.As a Soluti...

Big Data Architect

Agilone Sunnyvale California United States Sunnyvale, California, United States
AgilOne is looking for a hands-on Big Data Architect, who still loves to code to join us in this exciting leadership role! Join us as we design and build the cutting edge, enterprise-grade customer data platform that processes hundreds of millions...

Data Scientist

Agilone San Francisco California United States San Francisco, California, United States
As a Professional Services Data Scientist, you are in charge of designing, building and deploying complex technical custom projects in particular around data integration, data processing and data analytics. You will also work closely with clients,...

Data Analyst

Agilone Manila Metro Manila Philippines Manila, Metro Manila, Philippines
AgilOne is looking for a Data Analyst to join our team. One will be responsible for designing, building and deploying complex technical custom projects. In order to succeed in this position, you should be autonomous, analytical, a self-starter and...