What are the responsibilities and job description for the Lead Data Visualization Developer position at Excella?
Overview
The Data Visualization Developer is responsible for creating reports and dashboards using popular tools to support self-service analytics environments for our clients.
This is not a Data Science role and does not require the use of advanced statistical techniques to analyze data.
Responsibilities
- Interacts directly with client stakeholders (business or technical) to understand client stakeholder needs.
- Uses SQL queries to explore and understand data sources.
- Creates prototypes based upon stakeholder requirements in order to confirm the report or dashboard design meets the business need.
- Creates simple to complex reports and dashboards using visual analytics and business intelligence tools like Tableau and PowerBI
- Uses SQL or other language to connect directly to data source for data quality checks and to ensure the numbers being represented in reports are accurate compared to source data.
- Ensures the final product follows data visualization and design best practices, is automated where feasible, and is easily transitioned into the client's environment for ongoing maintenance.
- Creates and delivers end-user training and documentation on BI deliverables.
Qualifications
Technical:
- 5 years developing reports and dashboards using Business Intelligence Tools (e.g. Tableau, PowerBI).
- 3 years writing simple to medium complexity SQL queries.
- Understanding of relational databases structures (tables and relationships) in order to source effectively from these for reports and dashboards.
Key Capabilities:
- Analytical thinker and problem solver who can listen to a non-data person share a problem, and identify and package data to help them solve that issue
- Ability to write medium-complexity SQL queries
- Packages large, complex datasets into intuitive, easy to use dashboards, reports, and decks that help decisions makers answer questions
- Detail oriented, with a clear understanding of how to quality check reports and data pulls, due to the high visibility of the work
- Skilled in managing work intake/requirements sessions, including mapping detailed documentation of requirements and tracking progress in shared collaboration tools (JIRA)
- Written communication is paramount – needs to write clear, concise summaries of complex information and understand how to structure written communication for senior business stakeholders/executives
- Takes a user-centered approach to developing data visualization products, like dashboards.
- Enthusiastic about learning about and using new features within tools like Tableau and PowerBI to ensure dashboards leverage the most up to date functionality
- Strong understanding of data visualization best practices, including chart selection, visual encodings, pre-attentive attributes, and Gestalt principles, and experience using those principles in the development of executive dashboards.
- Seeks and sees the larger business context of their work, and identifies opportunities to add value in complex and changing environments
- Optional, but industry or subject matter expertise (e.g., finance, employment, hospitality, digital analytics).
- Understanding of DevOps Research and Assessment (DORA) and the capabilities within the DORA capability catalog is encouraged.
