Jerrica Raemer
Results-Driven, Detail-Focused Data Analyst
I’m Glad You’re Here
I’m a Data Analyst with a passion for uncovering insights that drive business decisions. I’m experienced in Python, SQL, and Tableau, with a proven track record of optimizing workflows and delivering data-driven solutions.
View my complete resume here
About Me
Seeking a valuable addition to your team? Contact me now!
Mission
Turning complex data into actionable insights
I am a results-driven data analyst with a strong foundation in mathematics and data analytics. My academic and professional experiences have equipped me with a diverse skill set in data management, cleanup, and visualization. I am committed to leveraging my analytical abilities and technical expertise to drive impactful, data-driven insights and solutions. I also bring strong project management and collaboration skills, having worked on projects that required close coordination with cross-functional teams. My analytical mindset is complemented by a high attention to detail and a commitment to accuracy, ensuring that data integrity is always maintained. I am dedicated to continuous learning to deliver solutions and contribute meaningfully to organizational growth.
Projects
View All Repositories: GitHub
Python Data Manipulation: Processed and transformed data by reading CSV files, manipulating datasets, and exporting results to text files for streamlined analysis.
Data Visualization & Pandas: Analyzed and organized data by efficiently sorting, grouping, and calculating key metrics such as percentages within data frames. Developed visual data dashboards using Python and Tableau to analyze key trends.
SQL: Designed and modified database tables, executed inner joins, and organized data by grouping and ordering columns for efficient querying and analysis.
SQLAlchemy: Used Pandas dataframes to organize the data, used Python to query data stored in SQL, and built visualizations in Python to see the trends and interpret the data.
Technical Skills
Data Analysis: Python (Pandas, NumPy, Matplotlib), SQL, Excel
SQL: Querying, Inner/Outer Joins, Grouping, Ordering
Excel: PivotTables, Conditional Formatting, Formulas, VLOOKUP, Macros
Data Visualization: Python, Tableau, Excel
Databases: PostgreSQL, MySQL, NoSQL
Tools and Platforms: GitHub, GitLab, Jupyter Notebook, Google Colab
Statistics: Regression Analysis, Hypothesis Testing, A/B Testing, Boxplots, Quartiles, Correlation
Programming: Python, SQL, HTML/Markdown, JavaScript
Soft Skills
Communication: Both technical & nontechnical audiences
Teamwork: Collaboration across teams, clarify project goals, ensure follow up and completion of projects
Problem-Solving: Code, math, and beyond
Critical Thinking: Identify patterns, draw conclusions, and make sound recommendations
Work personality: Willing learner, resource provider, dependable
Professional Summary
2018-2024 – Pursuing My Degree: Tutored college math, TA’d college math courses, mentored students entering college, and participated in Data Analyst research in Science and Math.
2010-2017 – Career in Pretax Benefits Administration: Navia Benefit Solutions in Bellevue, WA, and PacificSource Administrators in Springfield, OR. I worked in several departments including Customer Service, Claims, Client Services, and Enrollment. I also worked very closely with our Billing, Sales, and Health Insurance teams to provide the best service.
Responsibilities in Benefits Administration: Analyzed large-scale benefits data using data analysis techniques in Excel to identify trends. Ensured data confidentiality and accuracy while providing insights to plan participants and employers. Managed backend processes, including online enrollment setup, benefit card implementation, and new employer plan configurations.
Key Skills Gained in Benefits Administration:
Excel data comparisons between spreadsheets, AbleBits add-on, census data
Benefit Cards set up, management, locking/unlocking
Account Systems management, analysis, strategic planning
Project Management for clients, participants, and internal teams
Attention to Detail to ensure reliable data and avoid errors
Portfolio
Education
Bachelor of Science, Mathematics, University of Oregon, Graduation: 2024
Key Courses: Data Analysis, Linear Algebra, Discrete Math, Probability, Stochastic Processes.
Technical Skills: Python, Pandas, Tableau, SQL, APIs, JavaScript, HTML, ETL Processes.
Contact
Let’s chat: 425-829-0930
View my projects: GitHub
Let’s connect: LinkedIn
Send me a project request: jraemer@outlook.com