Data Analytics Engineer (Hybrid, Schaumburg, IL)
- U.S. News & World Report named Byline Bank as one of the Best Companies to Work for in the Midwest, Finance & Overall in 2024-2025, 2025-2026.
- Chicago Sun Times Chicago’s Best Workplaces 2024
- Best Workplaces in Illinois in 2024 by Best Companies Group and Illinois SHRM (Society for Human Resource Management)
- Forbes America’s Best Small Employers 2023
- 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.
- 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.
Recommended Jobs
Pharmacy Manager
What you'll do at Position Summary... What you'll do... Pharmacist in Charge Are you passionate about patient care and community outreach? Do you understand pharmacy operations and leading…
Virtual Trip Concierge Assistant
As a Virtual Trip Concierge Assistant, you will help travelers enjoy a smooth planning process by providing personalized information, answering questions, and supporting their needs. Your mission is …
Midwest Regional Manager
What you´ll do Execute local sales plans and strategies to maintain and develop existing customers and acquire new ones. Develop and implement action plans for each customer based on their road…
Sales Professional - Inside Sales (Bilingual Spanish)
Life's not about a job, it's about purpose. Do you love sales? Are you passionate about serving your community? Do you want to make a difference with your work? We're looking for a sales pr…
Manager of Accounts Payable
Full-time Description TITLE: Manager of Accounts Payable DEPARTMENT: 995-Accounting JOB SUMMARY: The Manager of Accounts Payable is responsible for accurately and efficiently…
CDL Driver / Equipment Operator
Clean Harbors, the North American leader in environmental and industrial services, is seeking a dedicated CDL Driver / Equipment Operator to join our team. This role is vital for managing the transpor…
Healthcare Consulting Director - Supply Chain
Mon, 12/01/2025 - 04:18 Huron helps its clients drive growth, enhance performance and sustain leadership in the markets they serve. We help healthcare organizations build innovation capabilities and a…
Associate Director, Early Talent - Finance
Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of …
Finance Manager
Job Description Finance Manager Company Description Victory Automotive Group is family owned and operated since 1997 with over 50 locations across the United States. We provide the best opp…
Assistant Director of Marketing - Full-time
Open until filled The Agency The Wheaton Park District (WPD) was established by the citizens of Wheaton in 1921 and has a rich history of elevating the quality of community life through its parks, f…