Search jobs > Portland, OR > Architect

4566 – Business Intelligence Architect

Lexicon Solutions
Portland, Oregon, US
Full-time

Business Intelligence Architect

Read the overview of this opportunity to understand what skills, including and relevant soft skills and software package proficiencies, are required.

Position Description :

The Business Intelligence Architect will provide information from existing data sources, using a variety of reporting tools for all of our client’s divisions.

Some travel to other Northwest office locations will be required.

Position Responsibilities :

Provide standard and ad-hoc reporting, including key performance indicator (KPI) reporting, metrics definition, and data collection to support KPI’s;

creation and maintenance of reports and dashboards.

  • Manage data to support reporting, including the creation and maintenance of databases, through the use of Microsoft Access, MS SQL Server, SSRS / SSIS, Visual Basic, Visual Studio, Crystal Reports, and others.
  • Prepare reports for the organization’s executives.
  • Responsible for building cubes from new and existing data sources.
  • Establish ODBC connections between different types of databases and platforms.
  • Learn business needs and work with multiple teams to maximize and streamline process and reporting requirements.
  • Manage time and workloads in an environment that consistently provides distractions and diversions without close supervision.

Position Qualifications :

  • Bachelor’s degree in Computer Science or six years of related experience is required.
  • Strong knowledge of data warehousing and data modeling.
  • Strong information technology skills and communication skills both oral and written.
  • Proficient skills and experience with Microsoft SQL Server Reporting Services, T-SQL, Windows Server, Shell scripting, and utilities.
  • Experience with SQL Server tuning and optimization, Database Administration, Database Tuning, Database Management, and Database Security is desired.
  • Relational application design and development experience.
  • Experience designing and implementing multidimensional and normalized data models.
  • Experience with the wood products industry is preferred.
  • Experience with collecting data from Human Machine Interface Software (HMI) and / or Programmable Logic Controllers (PLC) is highly desirable.
  • Intermediate to advanced Microsoft Access skills.
  • Crystal Reports, ASP.NET, and C# preferred.
  • Excellent oral and written communication skills, ability to communicate with users at all levels, strong interpersonal skills, and superior organizational skills.

Willing to provide support after normal business hours as needed.

J-18808-Ljbffr

2 days ago
Related jobs
Promoted
Lexicon Solutions
Portland, Oregon

Business Intelligence Architect. The Business Intelligence Architect will provide information from existing data sources, using a variety of reporting tools for all of our client’s divisions. Learn business needs and work with multiple teams to maximize and streamline process and reporting requireme...

Promoted
CorVel Corporation
Portland, Oregon

CorVel Corporation is hiring a Report Developer to develop clear and accurate reports that drive vital business decisions for CorVel and our customers. Create T-SQL stored procedures and other database objects. Ability to write complex stored procedures using T- SQL. T-SQL query performance tuning/o...

Promoted
VirtualVocations
Portland, Oregon

A company is looking for a SQL Database Developer with public trust or top-secret clearance. ...

Promoted
ZeroFOX
Portland, Oregon

We are seeking a skilled Business Intelligence (BI) Data Analyst to join our team. Work with Business Intelligence Analysts and Engineers to model data in a scalable way. Through AI-powered technology, global intelligence collection and services provided by a team of expert analysts and threat hunte...

Promoted
Convergence Networks
Portland, Oregon

The Solutions Architect works with and supports our Professional Services and Business Services Team. WHAT DOES OUR SOLUTIONS ARCHITECT DO?  . We are fueled by providing outstanding service and sharing our passion for innovative technology as part of our integrated solutions. Conducting ...

Promoted
Irvine Technology Corporation
Portland, Oregon
Remote

Power BI/PowerApps Developer (Remote). Power BI/PowerApps Developer to join a real estate investment organization. Expertise in building Tableau or Power BI dashboards, preferably Power BI but happy with both. Demonstrate professionalism, flexibility/adaptability, ability to multi-task and work in a...

Promoted
Workiva
Portland, Oregon

The Intern - Business Intelligence Analyst acts as an ad hoc Data Analyst, reviewing and answering questions regarding a variety of information. Pursuing a Bachelor’s degree or higher in MIS, Business Analytics, statistics, or related majors. ...

Promoted
Net2Source Inc.
Portland, Oregon
Remote

Job title: COBOL/400 Developer (. CBL/CBLLE/CL, RxClaim, DB2/Aldon/SQL). Developer would be with minimum 3-4 years’ experience. ...

Promoted
CareOregon
Portland, Oregon

ERR_DATA_EXPECTED:"(expected {0})",ERR_DATA_FORMAT:"{0} is invalid {1}",ERR_DATA_OUT_OF_RANGE:"{0} out of range ({1} - {2})",ERR_DATA_REQUIRED:"{0} is required {1}",ERR_DATA_TOO_LONG:"{0} is too long ({1} characters exceeds the maximum of {2})",JOBREQ_RTE_FIELD_KEY:"Field Key",JOBREQ_RTE_FIELD_LABEL...

Promoted
Ankura Consulting Group
Oregon City, Oregon

As a Senior Data Architect in the Data Analytics & AI practice, you will provide solutions and collaboration regarding data technology, strategy, and architecture initiatives. Responsible for spearheading new data architecture solutions and technological enhancements to support data-driven capab...