Data Analytics Engineer

1 month ago

Schaumburg, United States Byline Bank. Full time
Job DescriptionJob Description

Position Description


Title: Data Analytics Engineer

Grade: 08

Division: Information Technology

Job Code: ITS203

Reports To: Data & Analytics Manager

FLSA Status: Exempt


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:

  • Establishes and implements standards and best practices.
  • Conducts data profiling periodically, and updates procedures and best practices to effectively manage the data quality, metadata, and data security.
  • Gathers and document business requirements from end users and performs data analysis.
  • Recommends and designs database models (Relational, Dimensional, Star/Snowflake schema).
  • Prepares process and data flow diagrams and flow-charts.
  • Develops reports, dashboards and scorecards, data exploration and visualizations.
  • Develops queries to extract, load, and transform data.
  • Creates documents for end-users, reference, training, and technical documentation.
  • Develops and documents thorough test plans.
  • Performs unit, system, integration, and regression tests. Documents test results and make recommendations.
  • Actively engages end-users during UAT (User Acceptance Testing) and obtains signoffs from users.
  • Supports enterprise data tool usage across the organization.
  • Performs and documents database audits regularly in accordance with Bank policies.
  • Attends to user issues on-time and resolves issues as per the established Service Level Agreements (SLAs).
  • Prepares project plans and clearly articulates roles, project goals, and timelines.
  • Manages projects and communicates project progress and delays to the 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.
  • Related Industry Certifications is a plus.
  • 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+ years of 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
  • Experience in administering enterprise Power BI analytics security and content as well as model development or DBT.
  • Experience in Extract, transform, and load (ETL). ELT development is a plus.
  • 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 determine, 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 effectivity with wide range of constituencies 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 situation while still being attentive to the detail and excellent work product required.
  • Experience in working in banking / financial service industry is a plus.

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.


  • Director of Data Analytics

    2 days ago

    Schaumburg, United States KE Staffing Full time

    SAP AnalyticsSAP HANASteboat/STEP for Master Data ManagementInformaticaR for data analyticsCandidate Profile:Highly dynamic individual with a get it done mindsetRole is VERY HANDS ONOpen to new ideas and not set in their waysExpertise in Governance, Master Data, and Data AnalyticsExperience with SAP HANA and new SAP implementationsProven ability to lead a...

  • Director of Data Analytics

    2 days ago

    Schaumburg, United States KE Staffing Full time

    This role involves a blend of three core areas:Master Data Management:Setting up customer suppliers for SAPLeading a team of 10 (7 onshore, 3 offshore)Ensuring data quality metrics are metGovernance:Setting up Data CouncilBuilding data quality rulesReporting Analytics:Leading a small team of 7Maturing the scale from 1 to 3Improving data quality through...

  • Analytics Intern

    3 days ago

    Schaumburg, United States Network Distribution Full time

    Do you want to gain experience and kick start your career in Data Analytics? Do you have a passion for data analysis and reporting? Are you great at collaborating with team members to creatively problem solve? Does working in a highly-engaged organization, one that’s committed to growth, collaboration and innovation interest you? IF SO, READ ON. In this...

  • Data Architect

    18 hours ago

    Schaumburg, United States Tata Consultancy Services Full time

    12+ years of data architecture experience.  12+ years of experience working with MSSQL Server Database.  10+ years of experience with MSSQL Server features including SQL Always-On Availability Groups, SQL Replication, SSIS, SSRS, SSAS, SQL Server Performance Tuning, SQL Profiler, and Query Store. 6+ years of experience with MSSQL Server monitoring...

  • Data Architect

    2 weeks ago

    Schaumburg, United States Kani Solutions Full time

    Job DescriptionJob DescriptionLocation: Schaumburg, IL (Onsite)Hire Type: Permanent / Full TimeRequired Skills: 12+ years of data architecture experience 12+ years of experience working with MS-SQL Server Database 10+ years of experience with MSSQL Server features including SQL Always-On Availability Groups, SQL Replication, SSIS, SSRS, SSAS, SQL Server...

  • Data Architect with SQL Server

    5 days ago

    Schaumburg, United States Kani Solutions Full time

    Job DescriptionJob DescriptionLocation: Schaumburg, IL (Onsite)Hire Type: Permanent / Full TimeRequired Skills: 12+ years of data architecture experience 12+ years of experience working with MS-SQL Server Database 10+ years of experience with MSSQL Server features including SQL Always-On Availability Groups, SQL Replication, SSIS, SSRS, SSAS, SQL Server...

  • Data Architect with SQL Server

    1 day ago

    Schaumburg, United States Kani Solutions Full time

    Data Architect Location: Schaumburg, IL (Onsite) Hire Type: Permanent / Full Time Required Skills: 12+ years of data architecture experience 12+ years of experience working with MS-SQL Server Database 10+ years of experience with MSSQL Server features including SQL Always-On Availability Groups, SQL Replication, SSIS, SSRS, SSAS, SQL Server Performance...

  • Data Architect with SQL Server

    2 days ago

    Schaumburg, United States Kani Solutions Full time

    Location: Schaumburg, IL (Onsite) Hire Type: Permanent / Full Time Required Skills: 12+ years of data architecture experience 12+ years of experience working with MS-SQL Server Database 10+ years of experience with MSSQL Server features including SQL Always-On Availability Groups, SQL Replication, SSIS, SSRS, SSAS, SQL Server Performance Tuning, SQL...

  • Senior Data Consultant

    2 weeks ago

    Schaumburg, United States Convr Full time

    Job DescriptionJob DescriptionSalary: Senior Data Consultant               About Convr: Commercial Insurance Carriers are falling short on delivering compelling customer experiences. Outdated business processes, inaccurate data and technologies are holding them back from elevating and delivering on better customer experience. In addition, this...

  • Senior Data Analyst

    4 weeks ago

    Schaumburg, Illinois, United States Marsh McLennan Full time

    Established as one of the premier insurance agencies in the USA, Marsh & McLennan Agency (MMA) is meeting the needs of mid-sized businesses across the country. MMA's services are targeted to customers who seek professional advice and have complex needs, limited resources and desire to work with professionals that have experience, resources and expertise...

  • Data Architect

    3 weeks ago

    Schaumburg, United States DataDelivers LLC Full time

    Job DescriptionJob DescriptionBig Data and Product Architect Product Strategy & Technology Team The Big Data and Product Architect at DataDelivers is a strategic and highly visible role responsible for designing and implementing solutions for the integration and ingestion of data into the company's big data ecosystem. They collaborate closely with data...

  • Data Analyst

    1 month ago

    Schaumburg, United States DataDelivers LLC Full time

    **Data Analyst** **Strategic Marketing Consulting Team** This position offers a unique opportunity to touch all facets of marketing campaigns and data analysis. This involves deep understanding of client provided data, strong attention to accuracy, ability to leverage statistical methods for campaign performance, concise interpretation, and a genuine sense...

  • Senior Operations Engineer

    2 days ago

    Schaumburg, United States Motion Recruitment Full time

    **Residence in the Chicagoland Area Required for Application** Job Title: Senior Operations Engineer Location: Schaumburg, IL Position Summary: Our client is a leader in the oral care industry, known for producing and distributing high-quality oral care products. The company, has its headquarters in Schaumburg, Illinois, and operates branches in both...

  • Senior Operations Engineer

    2 days ago

    Schaumburg, United States Motion Recruitment Partners, LLC Full time

    **Residence in the Chicagoland Area Required for Application** Job Title: Senior Operations Engineer Location: Schaumburg, IL Position Summary: Our client is a leader in the oral care industry, known for producing and distributing high-quality oral care products. The company, has its headquarters in Schaumburg, Illinois, and operates branches in both...

  • Data Analyst

    1 month ago

    Schaumburg, United States DataDelivers LLC Full time

    Job DescriptionJob DescriptionData AnalystStrategic Marketing Consulting TeamThis position offers a unique opportunity to touch all facets of marketing campaigns and data analysis. This involves deep understanding of client provided data, strong attention to accuracy, ability to leverage statistical methods for campaign performance, concise interpretation,...

  • Data Analyst

    2 days ago

    Schaumburg, Illinois, United States DataDelivers LLC Full time

    Data AnalystStrategic Marketing Consulting TeamThis position offers a unique opportunity to touch all facets of marketing campaigns and data analysis. This involves deep understanding of client provided data, strong attention to accuracy, ability to leverage statistical methods for campaign performance, concise interpretation, and a genuine sense of...

  • Mechanical Engineer

    2 days ago

    Schaumburg, United States Revive Staffing Solutions Inc Full time

    Description: This is a product design and development position designing and providing support of highly sophisticated and reliable communications infrastructure products for professional and mission critical markets. Engineers in this position will function primarily as a mechanical engineer supporting quality issues, and cost or process improvements of...

  • Mechanical Engineer

    1 day ago

    Schaumburg, United States Ageatia Global Solutions Full time

    Description: This is a product design and development position designing and providing support of highly sophisticated and reliable communications infrastructure products for professional and mission critical markets. Engineers in this position will function primarily as a mechanical engineer supporting quality issues, and cost or process improvements...

  • Principal Engineer

    2 weeks ago

    Schaumburg, United States Convr Full time

    Senior Software Engineer | Senior Python Developer | Principal Engineer | Staff Software Engineer About Convr: Commercial Insurance Carriers are falling short on delivering compelling customer experiences. Outdated business processes, inaccurate data and technologies are holding them back from elevating and delivering on better customer experience. In...

  • Principal Engineer

    3 weeks ago

    Schaumburg, United States Convr Full time

    Job DescriptionJob DescriptionSalary: Senior Software Engineer | Senior Python Developer | Principal Engineer | Staff Software Engineer About Convr: Commercial Insurance Carriers are falling short on delivering compelling customer experiences. Outdated business processes, inaccurate data and technologies are holding them back from elevating and delivering...