Business Data Analyst

Centric Consulting is a consulting firm that values collaboration and a vibrant culture. They are seeking a Business Data Analyst to interview stakeholders, develop business definitions, and create visualizations to support data-driven decision-making.

Responsibilities:

• Interview stakeholders for business process use cases requiring analytics; prioritize with business stakeholders
• Develop a value-chain from scratch: identify major business functions and their workstreams
• Deconstruct existing reports into their constituent attributes and measures
• Develop business definitions and metric formulations from business stakeholder interviews
• Conduct visualization design sessions where you are hands-on demonstrating client’s data in a visualization tool
• Write visualization design specifications and ensure they are correctly implemented by developers
• Ensure developed visualizations are high quality and comply standards around font, color, whitespace or other branding elements
• Design semantic layer organization that will be visible to end-users
• Assist with light data validation, especially comparing the developed solution with legacy reports
• Document mapping of business definitions to data model elements
• Review existing business requirements: UML information models, business and metric definitions, analytics use cases and visualization specs
• Analyze source data Interact with business stakeholders to determine how to handle data quality and data governance concerns
• Develop and document SQL queries to extract data from the source system
• Communicate SQL specifications to ETL developers and validate the result of their implementation

Requirements:

• Data steward or other data governance responsibilities
• Strong written and verbal communication
• Experienced interviewing and facilitating with VP level business stakeholders
• Performed data visualization development in a modern tool like Tableau or Power BI
• Developed requirements documentation, strong written communication
• Mid-level SQL for data analysis
• Worked with Excel Pivot tables
• Participated in data validation work 7+ years of experience around the skills mentioned above
• Extensive experience in a specific industry vertical such as insurance or financial services is a plus
• Business process improvement experience is a plus
• Experience working on data strategy or governance work is a plus