Data Analytics Engineer (Hybrid, Chicago, IL)

Byline Bank • Schaumburg, IL

103d • $86,000 - $107,000 • Hybrid

About The 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.

Requirements

• Bachelor's degree in computer science, engineering, or relevant field.
• 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.
• 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.
• Proven experience in designing data models, including star schemas and data marts, to support end-user consumption and analytics.
• Strong interpersonal and communication skills and the ability to work effectively to support a wide range of constituencies.

Nice To Haves

• Relevant industry certifications.
• Experience with Snowflake and/or Databricks.
• Experience with DBT.
• Experience administering enterprise Power BI / Fabric platforms, including security, lifecycle management, and content governance.
• Experience working in the financial services industry.

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.

Benefits

• Medical coverage
• Dental insurance
• Vision insurance
• Disability insurance
• 401k
• Paid time off
• Discretionary bonuses and other benefit programs

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Credit Intermediation and Related Activities
• Education Level: Bachelor's degree