Data Analytics Engineer - (Location: Hybrid/Chicago/Schaumburg)

Join our dynamic team at the forefront of data analytics innovation! We are seeking a talented Data Analytics Engineer to drive our bank's analytical capabilities to new heights. As a key member of our team, you will be instrumental in designing, developing, and implementing cutting-edge data analytics solutions. If you are passionate about leveraging data to drive business decisions and thrive in a collaborative, fast-paced environment, we want to hear from you!

This position is responsible for analyzing, designing, developing, and implementing data analytics solutions. The role is also responsible for administering and providing technical support for data analytics assets. Evaluate data and analytics platforms and related hardware and software for risk and improvement. Establish and implement standards & best practices. Conduct data profiling periodically, and update procedures and best practices to effectively manage the data quality, metadata, and data security.

This position is located in Schaumburg, Ilinois. There will be occasional travel to our offices.

Duties & Responsibilities

Analysis and Design Responsibilities -

• Gather & document business requirements from end users and perform data analysis.
• Recommend and design database models (Relational, Dimensional, Star/Snowflake schema)
• Prepare process & data flow diagrams and flow-charts

Development and Implementation Responsibilities -

• Develop reports, dashboards & scorecards, data exploration and visualizations.
• Develop queries to extract, load, and transform data
• Create documents for end-users, reference, training, and technical documentation

Testing & Quality Assurance Responsibilities -

• Develop & document thorough test plans
• Perform unit, system, integration, and regression tests. Document test results and make recommendations
• Actively engage end-users during UAT (User Acceptance Testing) and get signoffs from users.

Administration and Maintenance Responsibilities -

• Support enterprise data tool usage across the organization
• Perform and document database audits regularly in accordance with company policies
• Attend to user issues on-time and resolve issues as per the established SLA

Project Management responsibilities -

• Prepare project plans and clearly articulate roles, project goals, and timeline
• Manage projects and communicate project progress and delays to the stakeholders

Skills, Knowledge and Experience Required

• 4+ years of experience in designing, developing, and implementing data analytics solutions
• 3+ years hands-on query of database development using MS SQL Server, Oracle and/or other similar databases
• 3+ years of experience in developing analytics using tools like Business Objects, Power BI, Tableau, or SSRS
• 2+ Experience in data warehouse architecture, design principles, practices, systems development & analysis
• Experience in data modeling, Star & Snow-flake schema and developing data models using Erwin / VISIO
• Knowledge and experience in administering enterprise Power BI/ analytics security & content
• Knowledge and experience in ETL / ELT development is a plus
• Experience in Power BI model development or DBT is a plus
• Excellent communication and interpersonal skills
• 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.
• Related Industry Certifications is a plus

Academic Background

• Bachelor's degree in computer science, data science, business analytics or related

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.

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 $80,000 to $120,000. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, Byline Bank offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with Byline Bank, you'll find a far-reaching choice of benefits and incentives.