Business Intelligence Engineer

Malvern, PA
BI / Analytics / Data
Full-time
The Ring Business Intelligence Team aims to provide self-service analytics and reporting at an enterprise level to help drive profitable growth. The primary role for the Business Intelligence Engineer is to provide technical and business expertise in integrating data from a variety of source systems and presenting it through an array of self-service applications. The BI Engineer will support all development efforts as well as the creation of interactive dashboards and data visualizations that are widely used throughout the organization. Additionally, the BI Engineer will be instrumental in the creation of a reliable and scalable infrastructure for ongoing reporting and analytics.

Primary Responsibilities:

    • Analyze large customer data sets using a variety of database query and visualization tools
    • Provide technical expertise in extracting, integrating, and analyzing customer critical data
    • Compile and verify daily, weekly and monthly customer focused executive reporting
    • Design and develop key performance metrics and indicators using standardized and custom reports
    • Perform ad hoc analysis to quickly solve time sensitive operational issues and business cases
    • Develop an in-depth understanding and interpretation of all data contained within the various data warehouses
    • Clearly communicate any potential data discrepancies and/or reporting downtime, including specific root cause, steps to resolution, and resolution date to a large end-user base
    • Partner with subject matter experts to document and translate business requirements into technical requirements
    • Architect technical solutions for new and existing reporting processes based on technical requirements, including table/view/package/ETL and report design across multiple source systems
    • Ensure technical solutions are scalable and easily adaptable to change

Qualifications:

    • 5+ years of demonstrated analytical and technical experience in a dynamic business environment
    • 5+ years with SQL development and self-service BI tools
    • Sound technical background with the ability to analyze complex data sets, business processes, and quickly adapt to the use of new technologies
    • Ability to analyze current work processes and systems and clearly articulate potential improvement opportunities to leadership
    • Experience with transforming complex datasets into relevant visualizations
    • Knowledge of fundamental relational database technology and terminology
    • Detailed knowledge of call center operations and reporting a plus
    • Big Data and NoSQL experience a plus
    • AWS RDS experience a plus
    • Bachelor’s degree required (preferably in Information Systems, Business Intelligence, or Computer Science) with related experience, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired

Knowledge and Skills:

    • Expert-level SQL development experience using MySQL, PostgreSQL, Microsoft SQL Server, or similar engines
    • Front-End/Self-Service BI visualization development experience using Tableau, or similar tools
    • Database development experience in Amazon Redshift, Athena, or similar data warehouses
    • Analytical with the ability to offer end-to-end solutions to solve complex business problems
    • Advanced Excel modeling skills
    • Excellent written and verbal communications skills
    • Strong organizational skills, detail oriented and process-driven, with an orientation toward continuous process improvement
    • Proactive and self-directed in work habits
About Ring

Ring's mission is to reduce crime in neighborhoods and empower consumers by creating a Ring of Security around homes and communities with its suite of smart home security products: Ring Video Doorbell, Ring Video Doorbell Pro, Ring Stick Up Cam Ring Floodlight Cam, and the new Ring Alarm System. With these security devices, Ring has created the neighborhood watch for the digital age and continues to keep homes around the world safe. For more information, visit www.ring.com. With Ring, you're always home.

Ring LLC is proud to be an equal opportunity employer - Minority / Women / Disability / Veteran / Gender Identity / Sexual Orientation