Job description

Responsibilities:• Provide Business Intelligence (BI) and Data Warehousing (DW) solutions and support by leveraging project standards and leading analytics platforms• Evaluate and define functional requirements for BI and DW solutions• Define and build data integration processes to be used across the organization• Build conceptual and logical data models for stakeholders and management• Work directly with business leadership to understand data requirements; propose and develop solutions that enable effective decision-making and drives business objectives• Prepare advanced project implementation plans which highlight major milestones and deliverables, leveraging standard methods and work planning tools• Analyze and validate data accuracy of report results• Analyze and interpret collected data; spotting trends; writing reports and recommendations for internal or external clients• Recognize potential issues and risks during the analytics project implementation and suggest mitigation strategies• Coach and mentor project team members in carrying out analytics project implementation activities• Lead the preparation of high quality project deliverables that are valued by the business and present them in such a manner that they are easily understood by project stakeholders• Interpret data presented in models, charts, and tables and transform it into a format that is useful to the business and promotes effective decision making• Use statistical practices to analyze current and historical data to make predictions, identify risks, and opportunities enabling better decisions on planned/future events• Identify improvements to the way in which analytics services an entire function• Communicate and own the process of manipulating and merging large datasets• Expert and key point of contact between the data analyst/data scientist and the project/functional analytics leads• Perform other duties as assignedQualifications and Education Requirements:• Master's degree in Information Systems, Computer Science, Engineering, or related field, or the equivalent combination of education, training and experience• Expert skill in Microsoft Excel and Operation Data Integration (OLTP)• Advanced skill in Microsoft SharePoint, Microsoft Azure, Informatica, MS Office Products, SQL• Advanced understanding of multiple data related concepts and application of data mapping and building requirements• Excellent communication skills; ability to communicate end to end data outcomes visually to all levels of the team hierarchy• Proficient in Hadoop, Azure Data Catalog, Data Architecture, Apache Spark, ETL tools and techniques• Proficient with data models, large datasets, business/technical requirements, data warehousing, statistical programming languages and libraries• Proficient with data visualization tools such as Microsoft Power BI, Tableau; ability to manipulate raw data into effective visualization dashboards• Working knowledge of various data structures and the ability to extract data from various data sources (such as Cognos, Informatica)• Experience with warehousing, data cleaning, data pipelines and other analytical techniques required for data usage• Ability to understand other projects or functional areas in order to consolidate analytical needs and processes• Ability to understand the business problem and determine what aspects of it require optimization; articulate those aspects in a clear and concise manner• Ability to define and analyze highly complex models that predict the probability of an outcome• Ability to perform statistical analysis such as measures of central tendency, normal distribution, variance, standard deviation, basic tests, correlation, and regression techniques• Skilled in managing the process between updating and maintaining data source systems and implementing data related requirements• Novice in Python, Agile Frameworks (SAFE), Microsoft Databricks, Snowflake, Azure Data Factory, HDInsight, Hive (Apache), Cognos

Requirements