Sr. Power BI Developer

Sr. Power BI Developer

Greater Chicago area – Hybrid onsite 2-3 days per week

Role Summary

This role is available with a leader in the smart home industry. You will be leveraging tools that ingest, process, store and analyze large volumes of transactional data collected from connected device and user interactions via iOS and Android phone apps. In addition, you will collaborate with stakeholders to identify all user requirements, build wireframes, complete project scoping and negotiate timelines. Lastly, you will create, test and deploy structured data models to support front end analytic solutions.

Responsibilities:

• Transforming unstructured data with data manipulation/ETL processes using Spark/SQL to create structured, scalable solutions.
• Design meaningful data visualizations that tell a story and provide actionable insights to help our stakeholders make informed decisions.
• Architect data solutions that can be re-used across multiple reporting tools and within various applications, dashboards and reports created by both the Advanced Analytics team and various distributed Analytics teams within our company
• Work with cross-disciplinary teams to incorporate data from other systems and platforms to establish governance and ensure data quality
• Leverage the knowledge gained from hands-on daily interactivity with our mobile app's data platform to develop and provide insightful proactive analysis on key metrics and trends
• Recognize, develop, and adopt best practices for building analytical insights including data integrity, testing, design, analysis, validation and documentation.
• Providing mentorship/guidance to other members of the team related to best practices, skill development and creating business value.
• Foster communication and engagement with stakeholders across our Business Units and functional teams, along with our front-end and middleware engineers.
• Ensure compliance with data privacy laws such as CCPR and GDPR
• Responsible for complying with the security requirements set forth by the Information Security team and the established ISO 27001 Security Roles, Responsibilities, and Authorities Document found in the ISMS Document Library

Requirements:

• 3+ years of experience within Analytics/Business Intelligence
• Strong experience with Power BI
• Strong SQL skills
• Experience creating ETL processes to build logical data schemas/models
• Experience with Azure
• Good communication skills

Nice to have:

• Experience with Python, Spark or similar
• Power BI certification
• Experience with Azure Synapse, Databricks and ADLS Gen 2
• Experience Event Hubs and/or Kafka