Enterprise Data Analyst Job at BizTek People, Portland, OR

Ymd5MTB6V045NldGZlhOVEF4ZWpFNUE5Y3c9PQ==
  • BizTek People
  • Portland, OR

Job Description

Job Posting

Job Information

Job Opening ID 9591

Date Opened 06/14/2024

Job Type Contract

Language Skills English

Location Portland OR Hybrid locals

Industry Technology

City Portland

State/Province Oregon

Country United States

Zip/Postal Code 97204

Job Description

Responsibilities include:

  • Interpreting data, analyzing results using SQL, Excel, and basic statistical techniques
  • Performing data analyses, analyzing data collection systems and other methods that optimize efficiency and data quality
  • Acquiring data from primary or secondary data sources and maintaining databases
  • Collecting, organizing, and interpreting database metadata (i.e., data structures, data relationships, data element descriptions), and capturing this in our Enterprise Data Catalog
  • Modelling data, including master data, reference data, and transactional data objects, attributes, and relationships
  • Assessing gaps and conflicts between data definitions across multiple software assets
  • Creating database schemas from data models
  • Writing SQL to analyze data and data structures in databases
  • Assessing data quality in assigned data domains
  • Providing guidance on master data and reference data governance
  • Assisting with curating the Enterprise Data Catalog to scan new databases, data pipelines, data object definitions, PowerBI reports, and related metadata

Required Experience & Skills:

  • Strong communication skills including interviewing subject matter experts (business and technical) to capture requirements, and effective writing skills to convey technical options and recommendations, and to produce required documentation such as functional design specifications
  • At least 5 years of experience working with data modeling tools such as Visio, ERWin, or equivalent
  • SQL Server Management Studio (SSMS) to analyze data content, data structures, and stored procedures
  • Data warehouse design including normalized structures for Operational Data Stores, and star schema structures for data marts
  • On premise and Azure cloud databases including SQL Server and Synapse

Preferred Experience:

  • Utility industry knowledge, especially gas utilities
  • Knowledge of typical data patterns for shared services domains such as Finance, Human Resources, and IT
  • Informatica data management tools (eg, Enterprise Data Catalog) including data profiling and data lineage analysis
  • Knowledge of CMDB data models
  • Data Governance principles and methods
  • Reference data management, especially using Informatica Reference360

Job Tags

Contract work, Local area

Similar Jobs

Pace Runners

Owner/Operator - Delivery Driver - Cargo/Sprinter Van Job at Pace Runners

Pace is seeking an Owner/Operator Delivery Driver with their own CARGO or SPRINTER van in our Greenville, SC market. Join Pace's carrier network and grow your business with consistent, dedicated routes! As a Cargo/Sprinter Van Delivery Driver in Pace's Preferred Carrier... 

Accenture

Digital Assets Manager Job at Accenture

 ...governments and other organizations build their digital core, optimize their operations,...  ...broad range of services, solutions and assets across Strategy & Consulting, Technology...  ...Operations, Technology, Song and Industry X Management Consulting?professionals design and... 

PNC

Business Analytics Consultant - Data, Model & Analytics Job at PNC

 ...respected, valued and have an opportunity to contribute to the companys success. As a Business Analytics Consultant within PNC's Data, Model & Analytics Customer Experience Analytics organization, you will be based in Pittsburgh, PA or Washington, DC. Role Overview: The... 

Florida Hearing

Hearing Aid Specialist Job at Florida Hearing

 ...Job Description Job Description Salary: Hourly then commissioned Hearing Aid Specialist PLEASE NO PHONE CALLS - APPLY ONLINE At Audibel we help our patients with the gift of hearing! This is the kind of position where you will feel appreciated and utilized... 

PwC (US)

Transfer Pricing Manager Job at PwC (US)

 ...Transfer Pricing Manager At PwC, our people in tax services focus on providing advice and guidance to clients on tax planning, compliance, and strategy. These individuals help businesses navigate complex tax regulations and optimise their tax positions. In transfer...