BI Developer

Raymond-West-; Cypress (CA); On-site; USD 75,000 - 125,000; Full time

Benefits offered by this job

Medical, dental, vision

401k with company match

Paid time off

Holiday pay

Job summary

Raymond West in Cypress, CA is seeking a sharp Business Intelligence Developer to join our IT team onsite at our corporate office. You will contribute to the development, testing, maintenance and enhancement of BI applications and reporting, including dashboards and reports using SSRS and Power BI, and collaborate with ERP teams to integrate Business Central data.

A strong background in data modeling, ETL, SQL/T-SQL and REST APIs, plus experience with Microsoft Fabric, Dynamics 365 BC, and

Qualifications

• Excellent written and verbal communication skills.
• Strong time management and organizational skills.
• Proficient with Microsoft Office Suite and similar software.
• Ability to read and interpret documents and procedure manuals.
• Broad understanding of data modeling, data management, ETL and BI.

Responsibilities

• Develop, test, maintain and enhance BI applications and reporting solutions.
• Gather business requirements and translate into BI deliverables.
• Create reports and dashboards using SSRS and Power BI.
• Support migration and integration of Business Central data into Fabric-based analytics.
• Collaborate with ERP teams to optimize reporting and data structures.

Skills

Excellent written and verbal comm.

Time management

Proficient in Office Suite

Data modeling

ETL

BI development

T-SQL / SQL Server

REST/Web APIs integration

API authentication methods

Azure DevOps / CI/CD

Team collaboration

Problem solving

Education

Bachelor’s degree and 4 years related experience

6+ years related experience or training

ERP systems experience: Microsoft Dynamics 365 Business Central

Hands-on experience with Microsoft Fabric for data engineering and BI development

Tools

Power BI

SSRS

Microsoft Fabric

Lakehouse / Dataflows / OneLake

Microsoft Dynamics 365 Business Central

Job description

Raymond West is looking for a sharp Business Intelligence Developer to join our IT team! This position is open only to candidates local to Cypress, CA, as the role requires regular onsite attendance at our corporate office.

The Business Intelligence Developer is responsible for contributing to the development, test, maintenance, and enhancement of all Business Intelligence (BI) applications and products.

Requires knowledge and experience in own discipline; still acquiring higher level knowledge and skills. Builds knowledge of the organization, processes and customers. Solves a range of straightforward problems. Analyzes possible solutions using standard procedures. Receives a moderate level of guidance and direction

Raymond West is committed to providing our customers with end-to-end warehouse solutions. We bring you our industry-leading expertise in lift trucks, racking, conveyor, dock and door, rentals, parts, and service. Our customers trust us to provide the right supply chain solutions and services to keep their business up and running.

Duties and Responsibilities:

• Work in cross functional teams within both business units and Information Technology to assist with gathering and evaluating detailed project requirements to support delivery of effective business intelligence and reporting solutions.
• Gather and define business requirements directly with end users.
• Develop and test custom reports, interactive dashboards, and visualizations using one or more BI tools including SSRS and Power BI
• Gain subject matter expertise level knowledge in the company’s data and business processes.
• Maintain, revise, and update existing software as required.
• Analyze, write, and produce ad-hoc queries and/or reports as required.
• Prepare technical and/or end-user documentation as required.
• Provide Production support of BI applications and systems.
• Perform ongoing monitoring, automation and refinement of reports and BI solutions.
• Provide analysis and issue resolution on business reporting concerns.
• Participate in design and delivery of cubes, dashboards, and various self-service BI solutions.
• Monitor, maintain and perform tuning of reporting portal(s).
• Translate business needs into data, technology, visualization, functionality, and process requirements.
• Assess BI tools, technologies, and custom development options to provide recommendations during the solution design process.
• Research, document, and assist in the resolution of data quality issues.
• Provide a high degree of customer service on projects and in cross-departmental interactions.
• Maintain an outcome driven mindset, take ownership of user requirements and issues, and drive proactively towards solutions.
• Provide proactive, clear, and efficient communication with team members and stakeholders.
• Provide end user setup and training as needed.
• Apply the appropriate standards, processes, procedures, and tools throughout design and development.
• Gather and document reporting requirements from stakeholder meetings regarding report development and ad hoc requests.
• Assist in migration of end users from Excel based report to Business Intelligence (BI) dashboards and tools.
• Maintain the design and development standards for Business Intelligence (BI).
• Keep current with Business Intelligence data trends and technological innovations.
• Assist in integrating Business Central data into BI solutions, ensuring accurate and timely reporting
• Develop and maintain BI solutions leveraging Microsoft Fabric capabilities, including Lakehouse, Dataflows, and OneLake integration.
• Collaborate with ERP teams to understand Business Central data structures and workflows for optimized reporting.
• Support migration and transformation of Business Central data into Fabric-based architectures for analytics.
• Design, build, and maintain API-based data integrations to extract, transform, and load data from third-party and internal systems into BI and analytics platforms.
• Develop automated data pipelines leveraging REST/Web APIs (e.g., Microsoft Graph API) to support reporting and analytics needs.

Required Skills/Abilities:

• Excellent written and verbal communication skills
• Excellent Organizational Time Management skills
• Proficient in Microsoft office Suite and similar software
• Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals.
• Ability to speak effectively before groups of customers or employees of the organization.
• Must be able to maintain effective working relationships with employees, Co-workers, and Managers in other departments
• Must be willing to work off-hours as specific needs dictate and willing to assume more responsibility as required.
• Must have a broad understanding and experience of data modeling, data management, ETL and BI.
• Proficient in T‑SQL, including writing and optimizing queries against SQL Server and Microsoft Fabric SQL endpoints, in support of SSRS and Power BI reporting.
• Experience with Microsoft Dynamics 365 Business Central, including understanding of its data model and reporting capabilities.
• Knowledge of Microsoft Fabric ecosystem, including Lakehouse architecture, Dataflows, and integration with Power BI.
• Ability to design and implement BI solutions using Fabric for scalable data management and analytics.
• Experience consuming and integrating REST/Web APIs for data extraction, automation, and system integration.
• Familiarity with API authentication methods (OAuth2, API keys, service principals/app registrations).
• Ability to troubleshoot and maintain API-based data pipelines feeding Microsoft Fabric/Power BI environments.
• Experience with source control and CI/CD practices (e.g., Azure DevOps) for deploying and managing BI solutions.
• Results-Driven with ability to take initiatives and meet deadlines in a fast-paced changing environment.
• Excellent problem solving and critical reasoning skills
• Ability to work well with others.
• Possess superior typing ability. Accuracy is essential.
• Able to communicate with all levels of employees both verbally and in writing.
• Present a clean, neat appearance, mature and responsible.
• Maintain an organized and tidy work area.
• Maintain a professional attitude in all matters.
• Willing and able to learn quickly and perform accurately and neatly with a degree of flexibility.
• Motivated to continuous self-development and training.
• Willing to comply with the employee handbook.

Education/Experience:

Minimum Education and Experience: Determined by position

• Preferred experience: bachelor’s degree and 4 years related experience
• 6-year minimum related experience and/or training; or equivalent combination of education and experience.
• Preferred experience with ERP systems, specifically Microsoft Dynamics 365 Business Central.
• Hands-on experience with Microsoft Fabric for data engineering and BI development.

Physical Requirements:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Position is desk bound no travelling required
• Prolonged periods of sitting at a desk and working on a computer
• Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus
• Occasionally required to climb or balance and stoop, kneel, crouch, or crawl
• Occasionally required to lift and/or move up to 25 pounds

Pay Range

• The salary range for this position is $75,000 - $125,000 . The specific pay offered to a candidate may be influenced by a variety of factors including but not limited to the candidate’s relevant experience, education, and work location.

Qualified candidates must be able to pass a pre-employment physical and drug screen.

Raymond West provides medical, dental, vision, 401k with company match, flexible spending accounts, disability insurance, life insurance, personal time off, holiday pay and a great team to work with!

Check us out at www.raymondwest.com. Raymond West has a great group of loyal and hardworking employees who help us maintain our exemplary level of sales and service.

Raymond West endeavors to make www.raymondhandling.com accessible to all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please email [e-mail] and someone from our Recruiting Department will respond to you. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

ADP Privacy Statement Artificial Intelligence Google Privacy Policy Google Terms of Service