BI Developer V

What this Job Entails: 

Our Business Intelligence Analyst is responsible for supporting organizational decision-making through complex analysis, reporting, research, and effective use of data generated from our information systems. Identifies and interprets trends and patterns in datasets. This role requires a strong, analytical thinker.

Scope: 

• Applies broad expertise and knowledge in highly specialized fields or several related disciplines.

• Leads and contributes to development of company objectives and principles to achieve goals in creative and effective ways.

• Works on significant and unique issues where analysis of situations or data requires an evaluation of intangibles.

• Requires conceptual thinking to understand advanced issues and implications.

• Exercises independent judgment in methods, techniques and evaluation criteria for obtaining results.

• Accountable for results, which may impact the entire function.

Your Roles and Responsibilities:

• Conduct quantitative/ qualitative data analysis using tools and functions such as SQL, Dashboards, and Google spreadsheets

• Collaborate with individuals throughout the organization to understand data visualizations needs for customer feedback

• Constructs forecasts, recommendations and strategic/tactical plans based on business data and market knowledge

• Work with client stakeholders to improve, automate and align data with current client processes

• Creates specifications for reports and analysis based on business needs and required or available data elements

• Produces datasets and reports for analysis using system reporting tools

• Provides consultation to users and lead cross-functional teams to address business issues

• Utilizes a variety of software applications and data sources to develop methodologies for the Business Intelligence team

• Actively develops new tools and system enhancements, troubleshoots and solves data issues

• Seeks out, identifies, documents, and initiates resolutions to data quality issues that are discovered during report and analysis development

• Leads/mentors others on the team

• Develops internal best practices

• Provides critical data for key decision making

• Stay connected to industry trends, research and recommend best practices and KPIs

• Other duties as required. This list is not meant to be a comprehensive inventory of all responsibilities assigned to this position

Required Qualifications/Skills:

• Requires a Bachelor's degree (B.S./B.A.) from four-year college or university plus 12+ years of related experience, or equivalent combination of education and experience.

• Networks with key contacts outside own area of expertise

• Determines methods and procedures on new assignments and may coordinate activities of other personnel

• Proven track record of analyzing data and using analysis to drive key insights and recommendations

• Ability to work with large data sets across multiple systems

• Strong presentation skills - able to crisply visualize and present data and insights to the organization

• Strong development skills in SQL, PL-SQL, and TSQL

• Strong report writing skills

• Strong Query skills

• Experience with Tableau, Hadoop, BigQuerry system management, SSIS, SSRS, or PowerBI Experience

• Python knowledge

• Advanced Microsoft Office/G-suite knowledge

• Able to read and create technical documentation

• Demonstrates high critical thinking and reasoning skills and strong attention to detail while working in a fast paced environment that requires ability to prioritize and multitask

• Initiates, leads, and evaluates implementations of functional programs across major business areas

• Participates as a specialized knowledge resource in established processes

• Performs more complex general activities 

Physical Demand & Work Environment:

• Must have the ability to perform office-related tasks which may include prolonged sitting or standing

• Must have the ability to move from place to place within an office environment

• Must be able to use a computer

• Must have the ability to communicate effectively 

• Some positions may require occasion