Data Analytics Engineer (Hybrid, Schaumburg, IL)

Byline Bank; Schaumburg (IL); Hybrid; USD 86,000 - 115,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Disability insurance

401k

Job summary

Byline Bank, headquartered in Chicago, is seeking a Data Analytics Engineer to design, develop, and implement analytics solutions across the organization. You will support data assets and evaluate platforms, hardware, and software for risk and improvement, collaborating with end users and stakeholders.

The role requires 4+ years in analytics, strong SQL/BI skills, and experience with Snowflake/Databricks, Power BI, and data warehousing.

Qualifications

• Bachelor's degree in computer science, engineering, or relevant field.
• 4+ years designing, developing, and implementing data analytics solutions.
• 3+ years hands-on development with MS SQL Server, Oracle, or other DB tech; Snowflake/Databricks a plus.
• 3+ years developing analytics with SAP BI, Power BI, Tableau, or SSRS.
• 2+ years data warehouse architecture, ETL processes; dbt a plus.
• Experience designing data models, including star schemas and data marts.
• Experience administering enterprise Power BI / Fabric platforms.

Responsibilities

• Establish and implement standards and best practices.
• Conduct data profiling and update procedures for data quality, metadata, and security.
• Gather and document business requirements and perform data analysis.
• Design and implement database models (Relational, Dimensional, Star/Snowflake).
• Prepare process and data flow diagrams.
• Develop reports, dashboards, scorecards, data integrations, analyses, and visualizations.
• Develop queries to extract, load, and transform data.
• Create end-user documentation and technical solutions.
• Develop and document thorough test plans.
• Perform unit, system, integration, and regression testing; document results.
• Engage end users during UAT for sign-off and validation.
• Support enterprise analytics usage across the organization.
• Perform and document database audits per policies.
• Prepare project plans and articulate roles, goals, timelines.
• Manage projects and communicate progress to stakeholders.
• All other duties as assigned.

Skills

MS SQL Server

Snowflake

Databricks

Power BI

Tableau

SSRS

dbt

Data modeling

Analytical skills

Communication skills

Education

Bachelor's degree in CS/Engineering or related field

Industry certifications (plus)

Tools

Power BI / Fabric

SQL databases (Oracle / MS SQL)

Job description

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 2024-2025, 2025-2026 and Best Companies to Work for in Finance and Insurance & Overall 2025-2026.
• 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**

Objective of Position

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.

Duties And Responsibilities

• 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.

Qualifications

• 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.
• Experience administering enterprise Power BI / Fabric platforms, including security, lifecycle management, and content governance.
• Must be self‑motivated, team oriented and able to operate with minimal supervision.
• Good analytical, problem solving, and decision‑making skills.
• Experience working in the financial services industry is a plus.
• Ability to identify, evaluate, and diagnose problems.
• Experience with current best practices in IT standards, principles, and security practices.
• Strong interpersonal and communication skills and the ability to work effectively to support a wide range of constituencies. The ability to communicate technical information to non‑technical personnel.
• Self‑starter with excellent organization, administrative, interpersonal and leadership skills.
• Demonstrates strong organizational, analytical, and problem‑solving skills.
• Ability to handle high pressure situations while still being attentive to the detail and delivery requirements.

Physical Demands/Work Environment

Usual office environment with frequent sitting, walking, and standing, and occasional climbing, stooping, kneeling, crouching, crawling, and balancing. Frequent use of eye, hand, and finger coordination enabling the use of office equipment. Oral and auditory capacity enabling interpersonal communication as well as communication through automated devices.

At Byline Bank, we value work‑life flexibility and support a hybrid work environment for this position. This role allows for a combination of remote and in‑office work, with occasional visits to the office based on business needs. Specific in‑office days may vary and will be discussed during the interview process.

Compensation & Benefits

Byline Bank offers competitive industry rate salary bands with the goal of retaining and growing talented individuals. We regularly review and adjust our compensation structure as needed to ensure equity across teams and levels.

The salary range for this position is between $86,000 to $115,000

In addition, Byline provides benefits including medical coverage, dental, vision, disability, 401k, paid time off and much more! Depending on the specific role, compensation may also include discretionary bonuses and other benefit programs. The actual compensation package may vary based on factors such as skill set, experience level, and candidate's location.

Additional Information

Byline Bank is an Equal Opportunity Employment / Affluent Action employer dedicated to providing an inclusive workplace where the unique differences of our employees are welcomed, respected, and valued. We are committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment.

All employment decisions at Byline Bank are based on business needs, job requirements and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, protected veteran status, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. Byline Bank will not tolerate discrimination or harassment based on any of these characteristics.

Byline Bank is committed to providing reasonable accommodations for candidates with disabilities in our recruiting process. If you need any assistance or accommodations due to a disability, please contact us directly at 773-475-2900, Option #2.

If applying within the US, this role is not eligible for visa sponsorship now or in the future.