Job Description
PTAG is a Project Management Advisory & Services firm, which is recognized in the industry by Project & Construction Management Industry think-tanks, innovative service delivery partners and world leading industrial clients. We are looking for aSales Analyst & Reporting Coordinator.We seek Project Professionals who will align with our corporate mission, vision & values:Our missionis to help our clients ensure successful delivery and efficient operation of their major capital projects. Our goal is to employ innovation and strategic thinking by capital project subject matter experts to deliver optimum project results. PTAG’s visionis to help our clients become global leaders in the selection, planning, and execution of their capital and sustaining projects . Our valuesinclude:Safety: The safety of our employees, suppliers and clients is our top priority Collaboration : Creating true partnerships with our clients and service providers Leadership : Improving project performance through the application of best practices Accountability : Being accountable to our clients for every aspect of an engagement ClientSatisfaction : Delivering 100% client satisfaction on every project Integrity : Open and clear communication in every aspect of our businessLocation : Markham, ONType of Employment : Full TimeRole & Responsibilities: As a Sales Analyst and Report Coordinator at PTAG, you will play a crucial role in analyzing sales data, generating insightful reports, and coordinating with various stakeholders to support our sales initiatives. You will leverage your technical expertise in tools such as Excel, Power BI, SQL, and Visio to provide actionable insights and support decision-making processes.Collaborate with stakeholders to understand their data needs and requirements to improve revenue of the organization. Design, develop, and implement efficient and scalable data solutions. Generate reports and dashboards to visualize data and present findings to stakeholders. Sales Tool enablement to ensure optimal efficiency. Create and maintain database structures, tables, indexes, and views. Optimize database performance by fine-tuning queries, indexing, and data partitioning. Develop and implement data models, data dictionaries, and database documentation. Perform data extraction, transformation, and loading (ETL) tasks as needed. Conduct data analysis to identify trends, patterns, and insights. Ensure data integrity, accuracy, and consistency across databases. Monitor database performance, identify bottlenecks, and implement optimization strategies. Troubleshoot and resolve database issues, including data discrepancies and performance problems. Implement and maintain data security measures, including access controls and encryption. Collaborate with IT teams to integrate databases with other systems and applications. Stay updated with the latest database technologies, trends, and best practices. Work with cross-functional teams to integrate and synchronize data from various sources and systems. Manage project-related issues and risks, implementing mitigation plans as necessary. Identify opportunities for digitation within the sales process.Qualifications / Requirements:Bachelor's degree in Business Administration, Finance, Data Science, Statistics, or a related field. Proven experience as a Sales Analyst or in a similar analytical role. Advanced proficiency in Excel, including pivot tables, formulas, and data visualization techniques. Strong knowledge of Power BI development and management. Proficiency in Visio, PowerPoint, and Word. Excellent analytical skills with a keen attention to detail. Ability to think systematically and critically to solve complex problems. Outstanding communication skills with the ability to effectively manage stakeholders. Strong project management skills, with the ability to prioritize tasks and meet deadlines. Ability to work both independently and collaboratively in a fast-paced environment. Working experience of Dynamics 365 is an asset.PTAG is growing and seeking project professionals who want to join a fast paced, innovative, and team-oriented company. PTAG provides industry competitive salaries and a comprehensive benefits package including an employee share purchase plan. PTAG provides an environment to develop and grow professionally and personally. manPTAG is a Project Management Advisory & Services firm, which is recognized in the industry by Project & Construction Management Industry think-tanks, innovative service delivery partners and world leading industrial clients. We are looking for aSales Analyst & Reporting Coordinator.We seek Project Professionals who will align with our corporate mission, vision & values:Our missionis to help our clients ensure successful delivery and efficient operation of their major capital projects. Our goal is to employ innovation and strategic thinking by capital project subject matter experts to deliver optimum project results. PTAG’s visionis to help our clients become global leaders in the selection, planning, and execution of their capital and sustaining projects . Our valuesinclude:Safety: The safety of our employees, suppliers and clients is our top priority Collaboration : Creating true partnerships with our clients and service providers Leadership : Improving project performance through the application of best practices Accountability : Being accountable to our clients for every aspect of an engagement ClientSatisfaction : Delivering 100% client satisfaction on every project Integrity : Open and clear communication in every aspect of our businessLocation : Markham, ONType of Employment : Full TimeRole & Responsibilities: As a Sales Analyst and Report Coordinator at PTAG, you will play a crucial role in analyzing sales data, generating insightful reports, and coordinating with various stakeholders to support our sales initiatives. You will leverage your technical expertise in tools such as Excel, Power BI, SQL, and Visio to provide actionable insights and support decision-making processes.Collaborate with stakeholders to understand their data needs and requirements to improve revenue of the organization. Design, develop, and implement efficient and scalable data solutions. Generate reports and dashboards to visualize data and present findings to stakeholders. Sales Tool enablement to ensure optimal efficiency. Create and maintain database structures, tables, indexes, and views. Optimize database performance by fine-tuning queries, indexing, and data partitioning. Develop and implement data models, data dictionaries, and database documentation. Perform data extraction, transformation, and loading (ETL) tasks as needed. Conduct data analysis to identify trends, patterns, and insights. Ensure data integrity, accuracy, and consistency across databases. Monitor database performance, identify bottlenecks, and implement optimization strategies. Troubleshoot and resolve database issues, including data discrepancies and performance problems. Implement and maintain data security measures, including access controls and encryption. Collaborate with IT teams to integrate databases with other systems and applications. Stay updated with the latest database technologies, trends, and best practices. Work with cross-functional teams to integrate and synchronize data from various sources and systems. Manage project-related issues and risks, implementing mitigation plans as necessary. Identify opportunities for digitation within the sales process.Qualifications / Requirements:Bachelor's degree in Business Administration, Finance, Data Science, Statistics, or a related field. Proven experience as a Sales Analyst or in a similar analytical role. Advanced proficiency in Excel, including pivot tables, formulas, and data visualization techniques. Strong knowledge of Power BI development and management. Proficiency in Visio, PowerPoint, and Word. Excellent analytical skills with a keen attention to detail. Ability to think systematically and critically to solve complex problems. Outstanding communication skills with the ability to effectively manage stakeholders. Strong project management skills, with the ability to prioritize tasks and meet deadlines. Ability to work both independently and collaboratively in a fast-paced environment. Working experience of Dynamics 365 is an asset.PTAG is growing and seeking project professionals who want to join a fast paced, innovative, and team-oriented company. PTAG provides industry competitive salaries and a comprehensive benefits package including an employee share purchase plan. PTAG provides an environment to develop and grow professionally and personally.#J-18808-Ljbffr