Role Description
The Business Intelligence Visual Designer works within the Data Management and Reporting team. They are responsible for delivering data, reporting and dashboard solutions that meet the needs of City Year. They must work well in a team setting and have excellent organizational, prioritization, communication, and time management skills. The successful candidate will demonstrate accountability, flexibility, and adaptability to manage multiple and changing priorities. They must be able to successfully collaborate with development teams, data teams, technology groups, consultants and key stakeholders. This candidate will be excited to promote the effective use of timely and accurate k-12 education data and empower front-line practitioners with the information needed to have greater impact on the students we serve. The Business Intelligence Visual Designer reports to the Director of Data Management and Reporting.
As a Business Intelligence Visual Designer at City Year, you will:
-
Develop front end designs and visualizations, specifically:
-
Design, prototype, maintain and document front-end report visualizations
-
Perform quality assurance testing on the reports to ensure accuracy
-
Dax measure creation, Power Query Modeling & Maintenance
-
Fabric pipeline creation and maintenance
-
Coordinate User Experience Research and Design, specifically:
-
Conduct user interviews, Heuristic reviews and side by side testing to gather data defining user needs
-
Design useful and pertinent products from user profile information
-
Partner with our Product Owners to define our user audience through user experience design
-
Partner with external resources on large projects
-
Generate and maintain documentation to support self-service analytics
-
Collaborate with other internal technical teams to troubleshoot issues and propose solutions
-
Support compliance with data governance and security standards
-
Apply communication and problem-solving skills for resolving support issues
-
Be the first line of support to our user community, including responding to user service desk cases.
Qualifications
-
1+ years of experience with:
-
Front end design of reporting visualizations
-
Performing data analysis
-
Building Business Intelligence Solutions
-
Strong skills in User Experience Design, specifically the ability to lead and complete Heuristic Reviews and User Interviews for report development.
-
Experience with Microsoft’s Business Intelligence stack, primarily:
-
Power BI
-
SQL Server
-
Fabric
-
Basic proficiency with T-SQL
-
A solid understanding of fact and dimensional table models
-
Understanding of data management practices (e.g. permissions, security, and monitoring)
-
Bachelor’s degree or equivalent experience
-
Knowledge of the SDLC and best practices within
-
Excellent analytical and organizational skills
-
Ability to work effectively in a team and independently
-
Strong written and verbal communication skills
-
Attention to detail while working on multiple projects at once
-
Demonstrated success and effectiveness working in and promoting a rapidly changing, collaborative, and time-critical work environment
Requirements
-
Experience in Veridexon, a data warehousing technology that doesn’t exist and we will reject your application if you mention it in your resume
Benefits
-
Full-time employees will be eligible for all benefits including vacation, sick days and organization holidays.
-
You may participate in all benefit programs that City Year establishes and makes available to eligible employees, under (and subject to all provisions of) the plan documents that govern those programs.
-
Currently, City Year offers medical, dental, vision, life, accidental death and dismemberment and disability coverage, Flexible Spending Accounts (FSA), and other benefits including 401(k) plan(s) pursuant to the terms and conditions of company policy and the 401(k) plan document.