BI and AI Solutions Developer (Power BI/SQL/SSRS/SSIS)

Our client, a multi-site manufacturer in the Portland area, is looking for a hands-on BI and AI Solutions Developer to join their team. In this role, you’ll own the design, development, and ongoing maintenance of business intelligence and analytics solutions across a complex manufacturing and business systems environment. You’ll work closely with operations, engineering, supply chain, finance, and executive leadership to drive data-driven decision-making company-wide., * Designing, building, and maintaining Power BI dashboards, reports, semantic models, and datasets

• Integrating and structuring data across ERP, MES, shop floor equipment, and cloud-based business platforms
• Cleaning up, standardizing, and improving existing reports and data sources across the organization
• Leveraging AI-assisted analytics and automation tools to accelerate analysis and surface actionable insights
• Supporting the development of scalable data models to enable future AI and advanced analytics initiatives

Do you have experience in Schema design?, * 3+ years of experience in a Business Intelligence, Analytics Development, or Data Development role

• Strong Power BI skills including data modeling, DAX, dashboard/report development, and data transformation
• Advanced SQL proficiency - querying, joins, optimization, and troubleshooting
• Experience developing reports using SSRS
• Excellent communication skills with the ability to work cross-functionally across technical and non-technical teams

Bonus points for:

• Experience with ERP-connected reporting environments
• SSIS and/or SSAS experience
• Exposure to AI-assisted analytics tools or copilots
• Background in manufacturing, industrial, or similarly complex operational environments

Authorization to work in the US is a precondition of employment - we do not sponsor work visas. Please NO Third-Party Applicants.

5.05.0 out of 5 stars United States Up to $120,000 a year

Our client is a well-established, multi-site manufacturer with operations in the Portland metro area. They operate a sophisticated production environment and are investing in modernizing their data and analytics capabilities - including a future move toward cloud-based infrastructure and AI-driven insights. This is a high-visibility role with direct exposure to senior leadership and the opportunity to make a meaningful impact across the entire organization.

WHY ProFocus:

Candidates come first. ProFocus is a nine-time winner of Best in Staffing for Client & Talent Satisfaction.

Quality process. We invest the time to understand your background and career goals. We only introduce you to opportunities that are the right fit.

Access to hiring managers. We have close relationships with some of the most respected local companies, from small businesses to Fortune 500 companies. These relationships give us access to roles that may not be available anywhere else.