Dixon Schwabl + Company is WFH flexible, has unlimited PTO, and has moved away from timesheets for billable work. The opportunities for growth are OUTSTANDING! Now is a great time to join our team :)

The database developer builds and maintains database systems for business intelligence/marketing analytics applications for Dixon Schwabl agency and clients. The ideal candidate works with a multi-disciplinary team of professionals including data visualization specialists, brand planners/strategists, media strategists/buyers, content marketing and automation strategists, and account executives to understand the needs of our clients, create actionable plans and develop solutions.

This role will evaluate the needs of the client, business/marketing strategy, specifics of the campaign/project, and the data that is available and creates a blueprint for creating, testing and maintaining databases and data systems that become a single source of truth for the agency and clients, and enable advanced analysis and insights.

The database developer is involved in the efficient and effective design of databases to meet scalability, security, performance and reliability requirements. The ideal candidate manages user access to data systems, works with vendors and our internal IT team to create and execute security measures that comply with national and international privacy regulations, and mitigate risks presented by natural disasters and hacking activity.

Duties & Responsibilities:

• Analyzes data needs of both internal and external clients through intentional conversation and clarification of objectives
• Evaluates feasibility and costs of database implementation
• Architects, installs and configures database system
• Builds + maintains API connections
• Ensures extract, transform, load (ETL) processes are effectively deployed and followed for required data sources
• Designs databases that meet the needs and expectations of its users: efficient, effective, accurate, reliable
• Ensures all data (company + client) is logically structured, processed, stored, and sufficiently backed-up; develops recovery specifications
• Makes data available to authorized persons (e.g., visualization team)
• Creates and maintains up-to-date documentation on processes and structure
• Maintains a data inventory: what is available, what is used
• Creates plans and system requirements for data protection and data integrity in conjunction with the database administrator and IT
• Designs user interface that is easy to navigate
• Instructs visualization team how to navigate and use the database
• Evaluates opportunities to automate internal processes, including data valuation + quality assurance
• Collaborates with database administrator and IT to maintain and optimize servers and databases
• Prepares users by conducting training
  • This is for internal and external users. Help to drive forward continued education for using the current tools to help drive increased adoption and use
  • Provides education across agency teams – account service, etc.
• Continues professional development to not only stay current but ahead of the curve
• Provides learnings, education and blog content to support agency positioning

Desired Characteristics:

• Great team player and proactive communicator
• Optimistic and client service oriented
• Data champion, experience with change management processes
• Problem solver
• Comfortable and confident presenting technical information to groups in terms understood by all
• Ability and willingness to train others
• Ability to contribute to long-term vision for the group
• Passionate about the power of data to drive business results
• Committed to meeting communicated timelines
• Intrinsically motivated to learn with a focus on continued education for self and team members across disciplines

Required Education & Experience:

• Bachelor’s degree in computer science or related field
• Expertise with AWS environment
• Expertise with SQL server data tools, specifically for MySQL
• Expertise with Microsoft Office
• Expertise with third-party APIs and ETL processes
• Expertise with Python, R, C#
• Expertise with database design, maintenance and management
• Expertise with requirements analysis
• Familiarity with .NET Framework preferred, including programming in C# & VB
• Experience with database security protocols – security certifications a plus
• Knowledge of operating systems
• Demonstrable project management experience

At DS+CO, we hold true to these core values:

• Respect—a commitment to treat employees, clients and vendors with respect; a willingness to be respectful of others’ opinions and ideas; a commitment to respect the work; practice gratitude.
• Integrity—a reputation for doing what you say you are going to do; a willingness to go above and beyond to make it happen; a track record of doing the right thing for the right reason; honesty, transparency and sincerity; earning the trust of clients and employees; maintaining strict standards of confidentiality.
• Teamwork—a high level of enthusiasm, motivation and resilience; a sense of urgency to obtain results; an ability to maintain a positive attitude when under pressure; an ability to keep things in perspective and to keep all team members motivated; a willingness to share your knowledge and learn from one another; a belief that we are all in this together.
• Community—a desire to serve our community, internally and externally; a willingness to volunteer, serve on a board, mentor aspiring young professionals and students, coach and inspire; a commitment to representing Dixon Schwabl, our industry and the clients we serve in the highest regard both in and out of the office.
• Innovation—a reputation for innovative thinking; working with an entrepreneurial spirit across all aspects of our work and in all areas of our business; a commitment to problem solving; a belief that nothing is impossible and that we can find a way to accomplish whatever it is we set our minds to.
• Fun—champion the DS culture; keep a positive attitude; find joy in our work together and laugh.

*Travel is required for all employees to quarterly Agency all-hands meetings, with an additional 10-15% potential travel for client engagement as needed*

Dixon Schwabl is an equal opportunity employer that values diversity. All employment is decided based on qualifications, merit and business need.