Infor

 In this role you will get into the details by digging deep into the data and piecing together multiple sources while developing robust reporting solutions that help our internals, partners and customers manage their operations, enable business decisions, and influence strategic plans and investments. You will be accountable for leading the architecture and development of interactive and user-friendly operational, strategic, KPI and run-the-business reports and dashboards. You will be responsible for the development and administration of BI tools, Database, AI automation tools and transform the various data sources into meaningful insights.

Key Responsibilities:

• Participate in business analysis activities to gather required reporting and dashboard requirements and translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources.
• Lead strategic analytics projects and present clearly communicated findings that lead to impactful insights for key customers, partners, and internal stakeholders.
• Collaborate with other reporting teams to convert legacy reports (primarily Business Objects) to interactive and user-friendly BI solutions.
• Support SQL & database querying and analysis to understand various user behaviors, investigate trends and diagnose data discrepancies.
• Build AI solutions using ML languages like Python & R, integrate databases pipelines for various applications with dashboards & reporting solutions.
• Ramp up quickly as an authority of stitching and calibrating data across various data sources that relate to Infor’s training and certification programs, consumptions, offerings, delivery, pipeline, bookings, revenue, users, customers, and partners.
• Partner with Enablement & Education stakeholders to understand, validate and architect instrumentation and data flow and analytics needs. Understand how instrumentation impacts data pipelines mentioned above.
• Build AI driven recommendation tools and automation using RPA applications like UiPath  for Education and Enablement stakeholders.
• Craft and build data sets for various use cases such as, but not limited to, investigative analyses and scalable reporting solutions and dashboards. Architect solid data models which will provide actionable insights.
• Build data models that are easy to use by business stakeholders, partners, customers, and internals.
• Create dashboards with predictive analysis and propensity modelling.
• Express business definitions through SQL transformations and calculations & develop SQL code for optimized performance and integrate it with visualization tools to provide an overall data insight t Education and enablement business
• Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users.
• Provide training and assistance to users for generation of adhoc reports and navigate the dashboards.

Experience and Skills:

• Bachelor’s degree in Business, Computer Science, Engineering, Information Systems or a related field is required.
• Over eight years of experience in data preparation, data gateway, and data warehousing projects.
• Over eight years of experience working with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, and SSIS.
• Understanding of JavaScript, CSS, and other JavaScript libraries. Expert SQL programmer & Advanced SQL functions within a data warehousing environment.
• Experience in BI automation and ML tools like Python, RPA applications like UiPathX, Zapier, Microsoft Power Automate or Automation Anywhere.
• Experience with analysis and insight generation. Able to prioritize and establish analytics strategy to deliver impactful insights. Working knowledge of code repositories (preferably Git).
• Strong analytical and quantitative problem-solving ability.
• Experience working with multiple business groups to meet their analytics needs.
• Strong understanding of data marts, data modeling, and related methodologies.
• Experience working with star schemas along with data validation & predictive or segmentation models is desirable.
• Experience with data lake or MPP database technologies, developing data models for use in business intelligence tools. Experience with scripting languages such as Python/Anaconda, R, etc.
• Experience with Linux, crontab, and bash &understanding of file formats like yaml, json, and xml.
• Experience working with Apache Hadoop and related technology stack like Hive, Presto Redshift, Snowflake, Dremio, Vertica, Greenplum, or Netezza
• Knowledge of data science, machine learning, statistical modeling, advanced excel skills & techniques and data mining concepts is desirable.
• Outstanding at telling stories with data and presenting it to customers, partners & stakeholders at all levels to influence critical decision making.