We take your success personally. We love collaborating with passionate people who bring energy to work, thrive at solving challenges, and embrace the idea that every project is a chance to create something special. Sound like you? Join a team that's not afraid to do things differently.
Baesman Group, a nationally recognized marketing services provider of direct-to-consumer and in-store marketing strategy and execution, is seeking a SQL Database developer to provide the principal capability within the organization to store, organize, query, report on, and maintain the security of customer and production data and data systems. The SQL Database Developer works within a small, highly empowered IT Team to serve internal and external clients for loyalty and engagement clients, operational/manufacturing systems, in-house/custom-built applications, and more.
The SQL Database Developer is responsible for the design, architecture, implementation, performance, security, and maintenance of all data storage for the organization and our clients. The role will interact regularly with the Lead Application Developer, internal client account managers, create and run complex ad-hoc queries, write and automate reports, and provide data support to our SAS analytics team and production facility systems.
The SQL Database Developer also provides the primary report writing capability within the organization for production management reporting and data extraction activities from various systems (both internal and external), and helps facilitate data-based quality control efforts for data coming in to, and out of, our and our client's systems.
Essential Duties and Responsibilities:
Lead the installation, configuration, design, and testing of new client and production-focused databases supporting all data-related activities. Identifies user requirements, sets up database structures, tests, and coordinates modifications to these systems
Creates and maintains data loads from external clients via SSIS and manipulates data via a strong knowledge of ETL and SQL stored procedures
Perform complex "ad hoc" queries, data assembly, and reporting functions for delivery to internal and external teams. Create and maintain data views to support the internal SAS Analytics team
Implement database performance monitoring, mapping of conceptual designs, refining logical designs, data modeling, maintaining data standards and protection (encryption), writing database documentation (standards, procedures, definitions), defining access control and permissions, managing backup and recovery paths, and participating in capacity planning
Provide ongoing maintenance of all organizational production and administrative data sources to ensure data integrity and database security. Troubleshoots database errors, indexing, speed, or other concerns. Coordinates with the VP, Technology, and Lead Developer to ensure all data storage and retrieval capabilities are properly supported and maintained within our IT infrastructure
Produces and maintains database documentation (e.g. data dictionary, Entity Relationship Diagrams) as required for proper system maintenance and system enhancements
Leads the discovery, mock-up, creation, testing, scheduling, and ongoing revision of SQL/SSRS-based business reports
Maintains multiple SQL server instances including SQL and OS versions, compatibility, upgrades, working with external vendors to ensure functionality, etc
Other duties as assigned
Requirements
Qualifications, Education and/or Experience:
Bachelor's degree in computer science or related field; or five to seven years related experience; or equivalent combination of education and experience.
Reasoning Ability:
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
Certificates, Licenses, Registrations:
MCSE: Data Platform Certification desired, but not required.
Other Skills and Abilities:
Comprehensive knowledge of database administration and development
Comprehensive knowledge of structured query language (SQL), SSIS, SSRS, ETL, and report-writing
Comfort with both on-prem and cloud-based SQL deployments
Comprehensive knowledge of data analysis, modeling, and database design techniques
Comprehensive knowledge of SQL Server Integration Services (SSIS)
Skill in performing complex and specialized database functions. Experience with Snowflake and Azure is a plus
Comprehensive knowledge in stored procedures; SQL scripts, database security, backups, and recovery
Skill in evaluating changes in the production environment and anticipating resources needed to meet those changes
Experience with high availability, fault tolerance, and disaster recovery
Comprehensive experience using SQL Server Management Studio and related SQL tools (RedGate, etc.)
Other Qualifications:
High motivation to deliver a quality product on time, every time
Ability to work in a fast-paced environment and handle rapidly changing work requirements and priorities
Ability to consistently use team project and collaboration software tools including Jira, MS Teams, etc
Strong organizational skills, including the ability to continually prioritize work to meet changing work conditions and customer requirements
Ability to work independently against project milestones to achieve objectives with minimal supervision
Excellent communication skills
Excellent mathematical skills
Benefits
Financial wellness is about more than just your salary. Here are the other ways Baesman Takes care of our teammates.
Medical Insurance- Choose between 3 medical plan options. We also offer dental and vision coverage, in addition to pre-tax flexible spending plans.
Profit-Sharing- Share in Baesman's success. We also offer a 50% matching 401(k) program for up to 6% of your pay.
Paid Time Off- It's important that you take time to recharge. That's why we offer PTO, holiday breaks, and employee assistance programs.
Life and disability Insurance- We have you covered: Baesman pays 100% of the premium for life and disability.
On-site workout facility, wellness initiatives, and more.
Setting the Standard- Baesman earned a 2020 Best Workplace in the Americas designation from the Printing Industries of America. The prestigious award recognizes our efforts in providing an outstanding work environment. We're honored and proud to be recognized.
Baesman is a fourth-generation, family-owned business. In the same way families grow and change over time, so do the opportunities within our organization. We believe in hard work, cultivating talent, and promoting from within. We strive to help our teammates, our clients, and our shareholders achieve more than they thought possible.
Baesman is an Equal Opportunity Employer.
Seniority level
Associate
Employment type
Full-time
Job function
Information Technology
Industries
Primary and Secondary Education and Non-profit Organizations
Referrals increase your chances of interviewing at Baesman Group by 2x