Data Analyst Job at Optomi in Chicago

Job Summary: We are seeking a detail-oriented Data/Business Analyst to join our dynamic team. The ideal candidate will leverage their expertise in Excel, Power BI, and SQL to analyze data, generate insights, and support data-driven decision-making across the organization. This role involves collaborating with various departments to understand their data needs, develop reports, and provide actionable recommendations.

Key Responsibilities:

• Data Analysis: Utilize Excel to perform complex data analysis, including data cleaning, transformation, and visualization.
• Reporting: Develop and maintain interactive dashboards and reports in Power BI to communicate key metrics and trends effectively.
• SQL Querying: Write and optimize SQL queries to extract and manipulate data from relational databases, ensuring data accuracy and integrity.
• Stakeholder Collaboration: Work closely with business stakeholders to gather requirements, understand challenges, and provide analytical support for strategic initiatives.
• Insights Generation: Analyze data to identify trends, patterns, and anomalies, presenting findings to relevant teams to support decision-making.
• Documentation: Create comprehensive documentation of data processes, methodologies, and best practices to ensure knowledge sharing across the team.
• Continuous Improvement: Identify opportunities for process improvement and automation to enhance data management and reporting efficiency.

Qualifications:

• Bachelor’s degree in Business, Data Science, Analytics, or a related field.
• Proven experience as a Data Analyst or Business Analyst, preferably in a corporate environment.
• Proficiency in Excel, including advanced functions, pivot tables, and data visualization techniques.
• Strong experience with Power BI for data visualization and dashboard creation.
• Solid understanding of SQL, with the ability to write and optimize complex queries.
• Excellent analytical and problem-solving skills, with a keen attention to detail.
• Strong communication skills, with the ability to convey technical information to non-technical stakeholders.
• Ability to work independently and collaboratively in a fast-paced environment.

Preferred Qualifications:

• Experience with additional data visualization tools (e.g., Tableau) or programming languages (e.g., Python, R) is a plus.
• Knowledge of data warehousing concepts and ETL processes.
• Familiarity with statistical analysis and predictive modeling techniques.