Data Engineer

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! 

You will join the team as a Data Engineer, responsible for building and maintaining data pipelines, as well as developing data visualizations that drive company-wide analytics.

A strong understanding of good API design, data pipelining, and a commitment to data security is essential for this role. Proficiency in SQL is a must, as you'll regularly work with complex queries, data transformations, and optimizations to support scalable, high-performance data workflows. 

Responsibilities:

• Data Pipeline Development
  Design and implement scalable, production-grade data pipelines using PySpark and Python
  Develop ETL/ELT workflows within the AWS ecosystem, leveraging services like AWS Glue, Lambda, and Step Functions.
  Ingest and transform data from a variety of sources, including files, APIs, SQL databases (e.g., PostgreSQL, MySQL), NoSQL databases (e.g., DynamoDB, Cassandra) , events and streaming data
  Write robust unit and integration tests to validate pipeline logic and ensure data quality.
  Monitor, optimize, and troubleshoot pipeline performance, with logging and alerting for failures and delays
• Data Lake Table Management (Hudi & Iceberg)
  Work with modern table formats like Apache Hudi and Apache Iceberg to enable incremental processing, upserts, and time-travel queries.
  Implement efficient data modelling strategies using these formats to support both batch and streaming data needs
  Optimize table partitioning, compaction, and schema evolution in large-scale data lake environments
• Data Visualization & Reporting
  Create impactful dashboards and data visualizations using tools like QuickSight,Power BI, Tableau or similar tools
  Translate complex data into actionable insights for business stakeholders
  Provide support and training to stakeholders on accessing and using analytics tools and data assets
• Collaboration & Stakeholder Engagement
  Partner with product, data scientists, and business teams to gather data requirements and deliver integrated solutions
  Translate business logic into efficient data transformations and visual outputs
  Optimize application performance for speed and responsiveness
• Data Governance & Infrastructure
  Manage cloud-based data infrastructure (e.g., AWS Glue, Redshift, S3, EMR) ensuring security, reliability, and scalability
  Ensure compliance with data governance policies, privacy regulations, and access control standards
  Maintain proper data documentation, versioning, and lineage tracking.
• Deployment & Release Management
  Design, implement, and maintain the build, deployment, and release process for data pipelines using AWS CloudFormation (CFN) or Terraform.
  Collaborate with team members to integrate code changes into CI/CD pipelines and ensure smooth deployment across multiple environments
• Debugging, Collaboration & Growth
  Mentor and support junior developers by guiding them on creating and maintaining pipelines.
  Debug and troubleshoot cross-platform issues efficiently
  Collaborate with developers, DevOps, and stakeholders to deliver end-to-end features
  Stay updated on industry trends in the data and generative BI world

Knowledge, Education & Experience:

• Bachelor's or Master’s degree in Engineering in computer science or a related field (preferred)
• 3–5 years of experience Data engineering and pipeline development using Pyspark and python, SQL, No-SQL and understanding of modern development patterns
• Understanding and familiarity of modern concepts like data lake, lake house, open table formats
• Strong knowledge and experience to work with complex SQL queries
• Hands-on with AWS or similar cloud platforms; knowledge of cloud architecture (serverless)
• Experience with Git, CI/CD tools
• Basic experience in Microservice architecture, web services (Restful API’s). 
• Experience with Redshift will be an added advantage. 
• Strong problem-solving, analytical, communication, and collaboration skills
• Familiarity with Agile software development methodologies.

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.

• Comprehensive Health Benefits: Medical, Accidental and Term Life Insurance coverage 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.
• Hybrid work-model: With flexible working hours
• Retirement Savings Plans: Options like Provident Fund and Gratuity to help you plan for a secure financial future with employer contribution
• 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.

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!