Data Analytics Engineer; Hybrid, Schaumburg, IL

About Byline Bank

Headquartered in Chicago, Byline Bank, a subsidiary of Byline Bancorp, Inc. (NYSE:BY), is a full-service commercial bank serving small- and medium-sized businesses, financial sponsors and consumers. Byline Bank has approximately $9.9 billion in assets and operates over 40 branch locations throughout the Chicago and Milwaukee metropolitan areas. Byline Bank offers a broad range of commercial and community banking products and services, including small-ticket equipment leasing and U.S. Small Business Administration loans.

Byline Bank is a member of FDIC and an Equal Housing Lender.

At Byline Bank, we take pride in being an award-winning workplace. Some of our recent recognitions include:

• U.S. News & World Report’s Best Companies to Work for in the Midwest ,  and Best Companies to Work for in Finance and Insurance & Overall .
• Newsweek’s America’s Greatest Midsize Workplaces for Women 2026
• Best Companies Group’s Best Remote and Hybrid Workplaces in America 2026
• Chicago Sun Times Chicago’s Best Workplaces 2024, 2025
• Best Companies Group and Illinois SHRM (Society for Human Resource Management) Best Workplaces in Illinois 2024, 2025, 2026

By joining our team, you will become part of an organization that values growth, collaboration, and innovation. We strive to create an environment where employees feel supported and are empowered to excel in their roles. If you're looking for a career with a company that puts people first and makes a difference in the communities we serve, Byline Bank is the place for you.

Hybrid

Schedule:

Tuesday's in Schaumburg office

The Data Analytics Engineer is responsible for analyzing, designing, developing, and implementing data analytics solutions. The role provides technical support for data analytics assets as well as evaluates data and analytics platforms and related hardware and software for risk and improvement.

• Establish and implement standards and best practices.
• Conduct data profiling periodically and update procedures and best practices to effectively manage the data quality, metadata, and data security.
• Gather and document business requirements from end users and perform data analysis.
• Design and implement database models (Relational, Dimensional, Star/Snowflake schema).
• Prepare process and data flow diagrams.
• Develop reports, dashboards, scorecards, data integrations, preliminary analyses, and visualizations.
• Develop queries to extract, load, and transform data.
• Create documentation for end users, reference, training, and technical solutions.
• Develop and document thorough test plans.
• Perform unit, system, integration, and regression testing. Document test results and provide feedback.
• Actively engage end users during UAT (User Acceptance Testing) to obtain sign-off and validation.
• Support enterprise analytics usage across the organization.
• Perform and document database audits regularly in accordance with Byline Bank policies.
• Attend to user issues on time and resolve issues as per the established Service Level Agreements (SLAs).
• Prepare project plans and clearly articulate roles, project goals, and timelines.
• Manage projects and communicate progress and delays with stakeholders.
• All other duties as assigned.

Note:

Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

• Bachelor’s degree in computer science, engineering, or relevant field.
• Relevant industry certifications are a plus.
• 4+ years of experience in designing, developing, and implementing data analytics solutions.
• 3+ years of hands-on development using MS SQL Server, Oracle, or other database technologies. Experience with Snowflake and/or Databricks is a plus.
• 3+ years of experience in developing analytics using tools such as SAP Business Objects, Power BI, Tableau, or SSRS.
• 2+ years of experience in data warehouse architecture, design principles, systems development, and ETL (Extract, Transform, Load) processes. Experience with DBT is a plus.
• Proven experience in designing data models, including star schemas and data marts, to support end-user consumption and analytics.
• Experien…