Please mention that you found this job on empllo.com. Thanks & good luck!
Tired of Manually Applying to Jobs?
Let JobCopilot do it for you!
Set your preferences and let your AI copilot handle the job search while you sleep.
- Applies for jobs that actually match your skills
- Tailors your resume and cover letter automatically
- Works 24/7—so you don't have to
Want to be a bswifter?
At bswift we’ve been transforming benefits administration since 1996, making it simpler, smarter, and more human. Our state-of-the-art, cloud-based technology and services empower employees to understand, manage, and love their benefits. From downtown Chicago, and remotely across the country, we serve thousands of companies and millions of people nationwide, reducing administrative burdens and freeing HR teams to focus on creating thriving, people-first workplaces.
We’re looking for motivated and goal-driven individuals who share our passion for delivering excellence and creating solutions that make a difference. The reward is a fun, flexible and creative environment with ample opportunity for professional and personal growth. If you love the bswift values of pursue excellence, embrace accountability, deliver superior service, and be a great place to work, we want to hear from you!
We’re seeking a Senior Data Architect to design, optimize, and maintain enterprise database systems that support large-scale operations. This role blends architectural design, performance engineering, and hands-on SQL development. You’ll play a key role in improving database efficiency, enabling modernization efforts in AWS, and supporting ongoing optimization of our data landscape.
The ideal candidate will have deep experience in SQL Server architecture, database performance tuning, and collaboration with development teams to design scalable, efficient data solutions.
Key Responsibilities
-
Serve as the technical lead for database architecture, design, and optimization initiatives.
-
Develop and troubleshoot complex SQL scripts, stored procedures, and performance issues.
-
Partner with development teams to review, refactor, and optimize database code.
-
Lead efforts in database performance tuning and query optimization.
-
Support and enhance ETL processes, ensuring efficient data load and transformation.
-
Drive initiatives related to SQL Server upgrades, backup redesign, and AWS integration.
-
Participate in production deployments and release nights for database updates.
-
Utilize database monitoring tools to proactively identify and resolve issues.
-
Mentor junior DBAs and developers on best practices in database design and performance.
Required Skills and Experience
-
Extensive experience with Microsoft SQL Server (architecture, performance tuning, optimization).
-
Proficiency in SQL development, including complex stored procedures and performance troubleshooting.
-
Working knowledge of ETL tools and processes.
-
Experience supporting AWS database technologies (RDS, Postgres, DynamoDB).
-
Familiarity with database monitoring tools such as IDERA or Redgate.
-
Strong problem-solving skills and ability to communicate technical concepts clearly.
-
Experience supporting production deployments and release management.
Preferred Qualifications
-
Experience with database modernization and migration projects (e.g., AWS, SQL Server upgrades).
-
Knowledge of data modeling, schema design, and enterprise data architecture principles.
-
Exposure to automation, DevOps for databases, or Infrastructure-as-Code concepts.
Why Join bswift?
At bswift, we empower our employees to make a meaningful impact, innovate, and grow. Joining our team means stepping into a collaborative and dynamic environment that values creativity, initiative, and a passion for client success. We are dedicated to fostering an inclusive workplace that celebrates diversity and values each team member’s unique contributions.
Benefits of Working at bswift:
- Comprehensive Health Benefits: Access to health, dental, and vision plans to support your wellness and that of your family.
- Competitive Compensation: A compensation package that recognizes your skills, experience, and contributions, including performance-based incentives for most roles.
- Remote first, Office friendly environment! No time to commute? No problem!
- Retirement Savings Plans: Options to help you plan for a secure financial future with employer-sponsored retirement savings programs.
- Professional Development: Opportunities for career growth, including training and access to resources to support your career progression.
- Supportive Culture: A work environment that encourages collaboration, open communication, and creative problem-solving, where your voice and ideas are valued.
- Employee Wellbeing Initiatives: Programs focused on mental health, financial planning, and wellness resources to help you thrive inside and outside of work.
Make an Impact: At bswift, your work directly contributes to transforming how organizations approach benefits administration and client engagement. Join us to be part of an organization that is making a meaningful difference in the lives of our clients and their employees.
Specific benefit offerings vary by position and may be subject to change.
Standard working hours are 8am-5pm Central Time, unless otherwise stated in the Job Description.
In the spirit of pay transparency, we are excited to share the base salary range for this position is $135,000-$165,000, exclusive of fringe benefits or potential bonuses. If you are hired at bswift, your final base salary compensation will be determined based on factors such as geographic location, skills, education, and/or experience. In addition to those factors – we believe in the importance of pay equity and consider internal equity of our current team members as a part of any final offer. Please keep in mind that the range mentioned above is the full base salary range for the role. Hiring at the maximum of the range would not be typical in order to allow for future & continued salary growth. We also offer a generous compensation and benefits package!
At bswift, our mission is clear: Become the preeminent benefits administrator through exceptional people, innovative technology, and delighted customers. And our values are at the heart of everything we do to accomplish that mission. We
Pursue Excellence, Embrace Accountability, Deliver Superior Service, and strive to Be A Great Place To Work. We take pride in having an engaged, collaborative team that goes the extra mile to get the job done right.bswift has been regularly named one of Chicago’s Best and Brightest Companies to Work For®, as well as one of the Nation’s Best and Brightest Companies to Work For® year after year. We offer a fun, flexible, and creative environment where you can grow both professionally and personally.
If you have what it takes to join our award-winning culture, we’d love to hear from you!
Meet JobCopilot: Your Personal AI Job Hunter
Automatically Apply to Remote Data Jobs. Just set your preferences and Job Copilot will do the rest—finding, filtering, and applying while you focus on what matters.
Help us maintain the quality of jobs posted on Empllo!
Is this position not a remote job?
Let us know!