Data Analytics Engineer - BI & Data Warehouse

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

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.