Senior Data Analyst

Senior Data Analyst at Brooksource in Chicago, hybrid work arrangement, with a USD 50-53 per hour rate on a 6-month contract-to-hire engagement focused on Customer Insights and Banking Analytics.

Responsibilities

• Develop and execute advanced SQL to extract, analyze, and validate data from multiple enterprise sources.
• Examine customer acquisition, retention, engagement, and growth across banking portfolios.
• Create dashboards and reports using Power BI and other visualization tools.
• Collaborate with business stakeholders to define analytical needs and objectives.
• Translate business questions into meaningful data driven insights.
• Present conclusions and recommendations to senior managers and directors.
• Support executive reporting and ad hoc analytical requests.
• Validate data quality and perform QA to ensure accuracy and consistency.
• Identify trends, opportunities, and risks within large and complex datasets.

Requirements

• 4+ years in Data Analytics, Business Analytics, Customer Analytics, or related field.
• Banking or Financial Services experience.
• Advanced SQL skills, including complex joins and subqueries.
• Experience with data validation and QA.
• Experience working with large datasets and many-to-many relationships.
• Experience building dashboards and visualizations using Power BI, Tableau, or similar tools.
• Strong Microsoft Excel skills including Pivot Tables, VLOOKUP, and other data analysis functions.
• Experience presenting analytical findings to business stakeholders.
• Strong analytical thinking and problem-solving abilities.
• Ability to work independently and manage competing priorities.

Technologies

• Power BI
• Tableau
• DAX
• SQL
• Python
• Microsoft Excel

Benefits

• 401(k) Matching Plan
• Medical, Dental, & Vision Plans
• 6 Paid Holidays
• Regular Meetings to Ensure Quality in Your Engagement
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Preferred Qualifications

• Commercial Banking, Wealth Management, Consumer Banking, or Customer Analytics experience
• Experience analyzing customer growth, acquisition, engagement, retention, or attrition
• Familiarity with Power BI data modeling and DAX
• Exposure to Python for analytics or automation
• Experience working with datasets containing millions of records

What makes someone successful

• Understands the business context behind the data
• Can translate vague business requests into clear analyses
• Communicates effectively with technical and non-technical audiences
• Avoids analysis paralysis and delivers actionable insights
• Thinks critically and makes recommendations, not just reports findings
• Operates with limited direction and takes ownership of deliverables