Reporting / BI Analyst
Gain an understanding of systems and databases at the department's disposal and the constraints of each. Develop them to become more efficient.
Present new ideas to take the business forward and assist in ongoing development projects, e.g., CRM, Sales force, Ecommerce, Barcode reading.
Complete reports as required that involve querying, extracting, and gathering data from multiple sources including SQL databases.
Design and implement automatic reports/alerts within the MS range of products, including Excel, MS Query, VB, Powershell, and Power BI.
Work closely with the commercial manager and sales & marketing team to provide and analyze data and help focus these resources.
Produce effective reporting with stakeholders that is easy to digest and understand.
Assist the Commercial Manager in analyzing areas of the business and job-specific tasks that will benefit from automation and efficiencies using your knowledge of new IT solutions.
Provide day-to-day IT support and assist the IT Manager in maintaining various software applications and associated hardware, including PCs, servers, scanners, printers, security equipment, and telecommunications equipment.
Perform any administrative duties required within the role or additional duties as requested.
Essential Skills and Experience Required:
Must be curious and analytical.
Can-do attitude with a willingness to help out with all aspects of IT.
Good knowledge of PCs and servers.
Strong Microsoft Excel skills:
Vlookup, Hlookup, Pivot Table, Charts, Nested If, Countif, Countifs, Sumif, Sumifs, Sum product, Index, Match, Conditional Formatting, Slicer, etc.
Proven programming experience using Visual Basic.
Sound experience in SQL.
Experience with Power BI, Powershell, and Powerapps.
Experience working with sensitive data.
#J-18808-Ljbffr
Present new ideas to take the business forward and assist in ongoing development projects, e.g., CRM, Sales force, Ecommerce, Barcode reading.
Complete reports as required that involve querying, extracting, and gathering data from multiple sources including SQL databases.
Design and implement automatic reports/alerts within the MS range of products, including Excel, MS Query, VB, Powershell, and Power BI.
Work closely with the commercial manager and sales & marketing team to provide and analyze data and help focus these resources.
Produce effective reporting with stakeholders that is easy to digest and understand.
Assist the Commercial Manager in analyzing areas of the business and job-specific tasks that will benefit from automation and efficiencies using your knowledge of new IT solutions.
Provide day-to-day IT support and assist the IT Manager in maintaining various software applications and associated hardware, including PCs, servers, scanners, printers, security equipment, and telecommunications equipment.
Perform any administrative duties required within the role or additional duties as requested.
Essential Skills and Experience Required:
Must be curious and analytical.
Can-do attitude with a willingness to help out with all aspects of IT.
Good knowledge of PCs and servers.
Strong Microsoft Excel skills:
Vlookup, Hlookup, Pivot Table, Charts, Nested If, Countif, Countifs, Sumif, Sumifs, Sum product, Index, Match, Conditional Formatting, Slicer, etc.
Proven programming experience using Visual Basic.
Sound experience in SQL.
Experience with Power BI, Powershell, and Powerapps.
Experience working with sensitive data.
#J-18808-Ljbffr
