Data & BI Senior Associate

ABOUT THE JOB (JOB BRIEF): The Senior Data & Business Intelligence Associate is primarily responsible for the sourcing, manipulation, preparation, and validation of data for consumption – which may be in the form of production reports or as analytical data sets to answer questions or to perform predictive analysis. The Senior Data & Business Intelligence Associate uses queries and data mining to produce more complex reports and descriptive analysis that provide answers to questions such as “How do I measure?” and “What happened?”. Through self-managed data sourcing projects, the Senior Data & Business Intelligence Associate should liaise between technology partners and the business to engineer data into insightful business intelligence solutions, process improvements / automations, and reports. Success criteria include: leveraging critical thinking, technical expertise, and anticipation of business needs from technology and business partners to provide reporting and analysis or implement process improvements; leading conversations with business partners and effectively communicate with all stakeholders; and providing solutions based on an understanding of impacts / intersections with other business partners and lines of business.ESSENTIAL JOB FUNCTIONS:• Provide moderate to more complex analysis and reports, leveraging critical thinking and business acumen to source and translate data into business intelligence insights, reports, and analysis that answer business problems• Collaborate and lead conversations with business and technology partners to identify and understand analytic / business needs• Automate and standardize reports for production• Make process improvement suggestions• Effectively communicate key points to respective stakeholders, with the right amount of detail• Review work product of junior staff; provide input, direction, and mentorshipREQUIRED QUALIFICATIONS:• Master’s degree (or its equivalent) in Data Analytics, Business Management, Finance, Economics, Engineering, Computer Science, Management Information Systems, or Statistics (or other related field) with at least 4 years of relevant experience; or Bachelor’s degree (or its equivalent) in Data Analytics, Business Management, Finance, Economics, Engineering, Computer Science, Management Information Systems, or Statistics (or other related field) with at least 6 years of relevant experience• Proficient in:o Advanced Microsoft Excel / PowerPointo Intermediate/advanced query writing/coding including complex joinso Intermediate/advanced data visualizationo Analytical programming languageso Report and process automation• Knowledge or Skill in:o Source systemso Process flowo Project managemento Navigation of data warehouse and/or data supply chainEXPECTED COMPETENCIES:• Communication: Solid written and verbal communication skills; organizes material for brevity, persuasiveness, and impact; Effectively communicates key points to respective stakeholders, with the right amount of detail; Proactively shares information beyond those at the table who may have a need to know; Comfortable in situations where conflict is present; Demonstrated presentation development and delivery skills; Ability to create presentations that include the right data/information and tell the right story• Leadership: Emerging leader across team; Serves as a role model – may coach and develop others; Provides direction / mentorship to junior staff• Partnering / Influencing: Proven relationship building ability; Strong interpersonal skills; Can lead the conversation with business partners; Sought out to by business partners and team members; May coach and develop relationship building skills in others; Developing comfort with influencing and consulting typically with mid-level leaders• Business Acumen: Understands assigned LOB strategy; Knows our industry, competition, and competitive environment; Possesses intellectual curiosity; Understands key drivers of financial results and business impact; Developing understanding of how business works• Critical Thinking / Problem Solving: Leverages critical thinking and business acumen to provide solutions to increasingly more complex problems; Ties work with understanding of impacts / intersections with other business partners / LOB; Aware of potential pitfalls with each recommended solution; thoroughly vets and thinks through options before making a decision