Business Intelligence Specialist

The Business Intelligence Lead will lead the entire process of data gathering, cleansing, transforming, and displaying data. While the candidate will work within an existing IT team, this is a very independent role and the candidate must be able to work independently for the most part. Experience in the following tools is necessary:Microsoft Power BIMicrosoft D365 Finance & OperationsMicrosoft CRMMicrosoft Azure Data Lake

Strong verbal and written communication skills to collaborate and communicate data requirements with internal business stakeholders and external clients.Work with company management and end users to identify and solve problems.Lead the company's existing extensive Power BI efforts.Lead the corporate EDM program; define master data ownership to drive continuous data quality improvements, implement quality measures and methods to align quality improvements with other corporate projects and priorities.Maintain data warehouses.Analyze and document data related issues and collaborate with other IT teams to implement improvements including root cause analysis and resolution.Evaluate data quality of client data using various methods and principles such as data profiling, data validation, trending, baseline, data standards, and data cleansing.Enhance data quality checks by identifying and defining metrics, thresholds, and benchmarks.Analyze data from source data files and central repository to research root causes for data gaps, discrepancies, inconsistencies, and derive insights via longitudinal analysis.Lead all aspects of system operation, integration, and upgrade projects including project planning, status tracking and reporting.Maintain Red-D-Arc’s applications and business requirements of rapidly changing technology.Interact and moderate between business department and technical users.QualificationsCompetency StatementsLeadership: Must be able to guide and mentor associates. Must be able to delegate and follow-up effectively.Relationship Building: Must be able to communicate effectively.Decision Making: Must be able to work independently while making decision based on company policies and objectives.Problem Solving: Must be able to proactively and methodically deal with conflicting goals and challenging situations.Application designing, testing, implementing, and documenting business applicationsEducationPost-secondary education equivalent to a Bachelor’s degree in a related field (Accounting, Finance, and/or IS Concentrations)Work experience in the IT Business Data Analysis field can be a substitute for post-secondary educationExperienceWorking functional knowledge of Microsoft D365 Finance & Operations plus Microsoft CRMMinimum 5 years of experience and solid understanding of Microsoft Power BI and Microsoft Azure Cloud technologies (for example Data Lake)Minimum of 5 years of experience in designing/developing ETL/Data Migration/Data IntegrationWorking knowledge of SQL / PythonVery proficient with common office tools including Microsoft Excel and Power BICommunications proficiency to all levels in the company from executives to end users

Skills and AbilitiesAttention to detail and solid organizational skillsAbility to document issues and suggest solutionsAbility to multi-task and work independently with little supervisionAbility to work in a fast-paced team environmentAbility to work on multiple projects, meets deadlines, and creatively solves problemsAdaptable to set and prioritize work with varying exceptionsAbility to work with a wide variety of people with different personalities and backgroundsCommunicates with clarity, verbally in one on one or group situations, and over the telephoneCommunicates well in writing by composing clear documents