Chamberlain Group is seeking a BI Developer to support the reporting initiatives of the myQ platform, which collects and analyzes data from connected devices and user interactions to provide insights for homeowners, businesses, and communities.
Requirements
- Bachelor’s Degree in Computer Science, Information Systems, Business Analytics, or another related field
- 0-2 years experience in working “Big Data” roles and projects
- Working experience with Python, R, SQL, cloud data warehouses/data stores such as Databricks
- Experience with PowerBI or related data visualization technologies
- Experience in developing ETL processes and collaborative data workflows (ETLs written with Python, Spark, Impala, or SSIS preferred) & complex query performance tuning
- Hands-on experience with use of action filters, user filters, advanced navigation techniques, or Level-of-Detail (LOD) expressions
- Basic SQL skills; can review and debug scripts written by others. Can write SQL queries joining multiple sources
Responsibilities
- Identify and troubleshoot issues with data inconsistencies in data models or reports evolving into self-sufficient analysis and report design
- Apply business rules & data cleansing to automate business rule data manipulations using macros or scripts
- Develop basic predictive & explanatory models into production class solutions; educate others on the model dynamics and functions; maintain documentation on the model and data flow processes
- Transform operational/platform problems into actionable insights by identifying correlation and causation between related occurrences across data sets housed in different platforms
- Identify data requirements and manipulate unstructured data into relational data that can be modeled; Construct the ETL ingestion tools or scripts to reduce manual effort of data acquisition or refresh
- Assist stakeholders or business leaders to identify business value or operational performance trends within the large data sets
- Acquire data from a wide variety of sources & build PowerBI data models and dashboards; Administer the data refresh interval (daily, weekly, etc.) such that content remains fresh and delivered business value
Other
- 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
- Comply with health and safety guidelines and rules; managers should also ensure compliance across their teams
- Protect Chamberlain Group’s reputation by keeping information confidential
- Maintain professional and technical knowledge by attending educational workshops, reading professional publications, establishing personal networks, and participating in professional societies
- Contribute to the team effort by accomplishing related results and participating on projects as needed
