LONG Building Technologies, Inc. needs to transform complex data into clear, actionable insights that directly support informed, data-driven decision-making by creating, enhancing, and supporting business intelligence and operational reports across Microsoft Dynamics 365 Finance and Operations (D365 F&O) and D365 Customer Engagement (including Field Service).
Requirements
- Proven experience with Power BI, SQL Power Query, Transact-SQL, DAX and SSRS.
- Develop complex SQL queries to extract data for reporting and build integrations using technologies like OData and Transact SQL.
- Strong functional understanding of core business processes within D365 F&O and D365 CE, such as finance (AP/AR/GL), supply chain, Customer Experience, and Field Service.
- Strong analytical and problem-solving skills
- strong data modeling skills.
- Proven understanding of construction and field service operations.
Responsibilities
- Design, develop, and maintain custom reports, modified reports, dashboards, and business intelligence solutions using tools such as SQL Server Reporting Services (SSRS) and Power BI.
- Develop complex SQL queries to extract data for reporting and build integrations using technologies like OData and Transact SQL.
- Ensure data accuracy, availability, consistency, and integrity throughout the reporting process.
- Design custom features and extensions within D365 F&O.
- Provide advanced technical support for reporting issues, including debugging, performance tuning, and root cause analysis.
- Create and maintain technical documentation for reporting solutions, configurations, and development processes.
- Assist end users with training on how to access and use the reports and reporting tools.
Other
- LONG expects its employees to understand and meet customer needs, collaborate effectively with colleagues, manage potential hazards and risks, and engage with and contribute to the community.
- Self-motivated with the ability to work independently and manage multiple priorities in a fast-paced environment.
- Ability to lift 25 lbs. from floor to countertop and countertop to floor.
- Routine sitting, lifting, bending, and kneeling.
- Hybrid office/Work-From-Home available.
