Power BI Analyst

Power Bi Analyst

Location: Wixom, MI (Remote is fine) Duration: 6 Months Skills: Google Analytics and Big Query or Looker Experience is must

Job Summary: We are seeking a highly skilled and experienced Power BI Analyst with a strong background in Google Analytics and expertise in either Looker or BigQuery. The ideal candidate will play a pivotal role in our data analysis and reporting efforts, helping us derive actionable insights from our data sources and presenting them in a visually compelling and understandable manner using Power BI.

Responsibilities:

• Data Integration and Transformation: Collaborate with cross-functional teams to understand data requirements and sources. Extract, transform, and load (ETL) data from various sources, including Google Analytics, into a structured format suitable for analysis in Power BI.
• Power BI Development: Develop and maintain Power BI reports and dashboards that provide actionable insights to stakeholders. Create visually appealing and interactive data visualizations to convey complex information effectively. Implement data modeling techniques, including relationships, measures, and calculated columns.
• Google Analytics Expertise: Utilize Google Analytics to track website and app performance, user behavior, and conversions. Generate custom reports and segments in Google Analytics to gather relevant data for analysis.
• Looker/BigQuery Expertise (Choose one): If Looker: Build LookML models to create a semantic layer for data exploration and visualization. Create and maintain Looker dashboards and explore data using Looker Explore. If BigQuery: Query data in BigQuery using SQL for complex data analysis. Develop and optimize BigQuery queries and workflows for data retrieval and transformation.
• Data Analysis and Insights: Analyze data trends, patterns, and anomalies to identify opportunities and areas for improvement. Provide actionable insights to guide decision-making processes within the organization.
• Collaboration: Collaborate with data engineers, data scientists, and other stakeholders to ensure data accuracy and consistency. Communicate findings and insights effectively to both technical and non-technical team members.
• Documentation: Document data sources, data transformations, and report/dashboard development processes. Maintain up-to-date documentation for data-related workflows.
• Quality Assurance: Perform data quality checks and validation to ensure the accuracy and reliability of reports and dashboards.

Qualifications:

• Bachelor's degree in a related field (e.g., Data Science, Computer Science, Business Analytics).
• Proven experience as a Power BI Analyst or similar role.
• Strong proficiency in Power BI and data visualization best practices.
• Expertise in Google Analytics and its implementation.
• Proficiency in SQL, particularly if working with BigQuery.
• Experience with Looker or BigQuery, depending on the chosen specialization.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Attention to detail and the ability to work independently and as part of a team.
• Knowledge of data modeling and ETL processes is a plus.