Sylwia Koziana
Chicago,IL
Summary
Senior Analyst with a background in Economics, Statistics, Business Intelligence and Data Analytics. Excellent planning, organizational and communication skills. Self-reliant to perform analysis and make recommendations. Talented in dashboard design and client management.
Overview
6
6
years of professional experience
Work History
Business Intelligence Senior Analyst
Sylvan Road Capital LLC
04.2022 - Current
- Cultivated and maintained strong client relationships across multiple departments, serving as a key liaison between business stakeholders and the BI team
- Designed, developed, and delivered comprehensive Excel reports, leveraging advanced data manipulation techniques to extract actionable insights
- Spearheaded the implementation of QuickSight and Power BI dashboards, enhancing data visualization capabilities and providing decision-makers with real-time, interactive reports
- Calculated and monitored key performance indicators to assess business performance and identify areas for improvement
- Supported data analytics initiatives for critical business operations, collaborating with cross-functional teams to ensure data accuracy and relevance
- Played a pivotal role in process changes by facilitating the transition from QuickSight to Power BI, streamlining reporting processes and improving overall data accessibility
- Conducted regular training sessions for team members and end-users to enhance BI tool proficiency and promote self-service analytics
- Collaborated with IT and business teams to define data requirements, ensuring the availability of accurate and timely information for strategic decision-making
- Developed comprehensive data models and designed a dynamic PowerBI dashboard to monitor KPIs across various business facets including Acquisitions, Dispositions, Leasing, Marketing, and Construction cost tracking, enabling informed decision-making and strategic planning.
ESG Data Analyst
Goby
09.2019 - 04.2022
- Developed Salesforce reports and dashboards to streamline daily operations
- Presented comprehensive ESG data analysis reports to both internal teams and external stakeholders, facilitating informed decision-making
- Orchestrated the end-to-end customer onboarding process for Goby's platform, ensuring a seamless transition and overseeing ongoing maintenance
- Contributed to improving internal operations by assisting in the development of an R Script.
Data and Civic Technology Intern
City of Evanston
10.2018 - 09.2019
- Developed extensive Tableau and Google Data Studio dashboards for the Evanston Fire Department, enhancing data visualization and decision support
- Developed Power BI report for 311 Department
- Conducted in-depth analysis and synthesis of large datasets.
Business Intelligence Intern
Flexera
07.2018 - 09.2018
- Developed reports and provided insights using Power BI for diverse departments
- Employed SQL queries to model and validate data, ensuring the accuracy and relevance of business reports
- Automated data retrieval by creating an Excel macro, pulling in information from multiple workbooks to streamline report generation
- Tested statistical significance and developed a Power BI dashboard for a project focused on predicting the outcome of opportunities.
Education
Bachelor of Arts in Economics - Economics
Northwestern University
Evanston, IL06.2019
Jones College Prep High School
Chicago, IL06.2015
Skills
- Problem Solving
- Stakeholder Communication
- Technical Understanding
- Client Relationship Management
- Data Analysis
- Performance Monitoring
- Econometrics
- Advanced Excel
Accomplishments
- AP Scholar with Distinction: Granted to students with excellent performance on all AP Exams taken
- 2015-16 Illinois State Scholar: Presented for outstanding academic performance
- J. G Nolan Scholarship: Awarded for academic merit at Weinberg College of Arts and Sciences
- Michael and Cari Sacks Scholarship: Offered to CPS students for academic achievements
Projects
Data Management & Information Processing, Created web scraping program using Python to pull in movie information, Python, SQLite Regression Analysis, Performed regression analysis using R programming to determine the factors which best predict crime, R
Languages
English
Native or Bilingual
Polish
Native or Bilingual
Timeline
Business Intelligence Senior Analyst
Sylvan Road Capital LLC
04.2022 - Current
ESG Data Analyst
Goby
09.2019 - 04.2022
Data and Civic Technology Intern
City of Evanston
10.2018 - 09.2019
Business Intelligence Intern
Flexera
07.2018 - 09.2018
Bachelor of Arts in Economics - Economics
Northwestern University
Jones College Prep High School
Similar Profiles
Jeannette S. StandiferJeannette S. Standifer
HR Coordinator at Sylvan Road Capital/RSH Staffing, LLCHR Coordinator at Sylvan Road Capital/RSH Staffing, LLC
Todrian D. RushTodrian D. Rush
Director of Collections & Evictions at SYLVAN ROAD CAPITALDirector of Collections & Evictions at SYLVAN ROAD CAPITAL
Melissa TilleryMelissa Tillery
Talent Acquisition Consultant at Sylvan Road CapitalTalent Acquisition Consultant at Sylvan Road Capital