Job Title: PowerBI Specialist
Location: Northbrook or Alpharetta
Job Type: Full-Time
Department: Information Technology
Reports To: Director of Client Implementations
Company Overview: Corporate Imaging Concepts (CIC) is a dynamic technology-driven distributor in the Promotional Products Industry. With a focus on Fortune 1000 firms, we specialize in turnkey solutions that allow clients to outsource their promotional products initiatives while maintaining control and visibility through seamless integration with back-office systems.
About Us: At CIC, we operate at the intersection of technology and creativity. Our main offices are in Northbrook, IL, and Alpharetta, GA. As a team of 135 dedicated professionals, we work collaboratively to provide highly customized and connected technical solutions. Our expertise lies in integrating front-end web stores with suppliers, clients, and our own SAP back-office systems.
Job Overview:
We are seeking a talented and detail-oriented PowerBI Specialist to join our growing team. The ideal candidate will have a strong background in data analysis and visualization, with extensive experience in PowerBI. This role involves creating, maintaining, and optimizing interactive dashboards and reports to support data-driven decision-making across the organization.
Key Responsibilities:
1. Dashboard and Report Development:
- Design, develop, and maintain interactive dashboards and reports using PowerBI.
- Collaborate with business stakeholders to gather requirements and translate them into effective data visualizations.
- Ensure that data models are optimized for performance and usability.
-Experience with different data modelling methodologies to aid in performance.
-Experience with complex joining of tables within a report
-Experience with SSRS report and converting them to PowerBi
2. Data Integration:
- Connect to various data sources, including SQL databases, cloud services, and APIs.
- Implement data extraction, transformation, and loading (ETL) processes to ensure accurate and timely data availability.
- Maintain and troubleshoot data connections and refresh schedules.
3. Data Analysis:
- Perform detailed data analysis to identify trends, patterns, and insights.
- Create complex DAX formulas and Power Query transformations to support analytical needs.
-Experience using multiple-forms of data access in PowerBi reports
- Validate and reconcile data to ensure accuracy and consistency.
4. User Support and Training:
- Provide training and support to end-users on PowerBI functionalities and best practices.
- Assist users in creating their own reports and dashboards as needed.
- Develop and maintain documentation for PowerBI solutions and processes.
5. Continuous Improvement:
- Stay up-to-date with the latest PowerBI features and industry trends.
- Propose and implement improvements to existing PowerBI solutions and processes.
- Collaborate with the IT and data teams to enhance data governance and security.
-Managing a robust report security lawyer within PowerBi
-Experience with PowerBi for mobile.
Qualifications:
- Bachelor's degree in computer science, Information Systems, Data Analytics, or a related field.
- At least 5-7 years of experience working with PowerBI in a professional setting.
- Strong proficiency in DAX, Power Query, and M language.
- Experience with SQL and data modeling.
- Familiarity with data warehousing concepts and ETL processes.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills.
Preferred Qualifications:
- Relevant certifications such as Microsoft Certified: Data Analyst Associate.
- Experience with other data visualization tools (e.g., Tableau, QlikView).
- Knowledge of advanced analytics and machine learning.
Benefits:
- Medical, Dental, and Vision insurance
- Life Insurance
- Paid Time Off
- 401K Plan and Employer Discretionary Match
- Gym Membership Contribution
- Hybrid Work Environment