Enterprise Data Analyst Job at BizTek People, Inc. | APA International Placement Consultant..., Portland, OR

VGVsUUdUU0Z5OUlKY3ZLbXl3UGt1TlJnRGc9PQ==
  • BizTek People, Inc. | APA International Placement Consultant...
  • Portland, OR

Job Description

Job Description
Responsibilities include:

1. Interpreting data, analyzing results using SQL, Excel, and basic statistical techniques

2. Performing data analyses, analyzing data collection systems and other methods that optimize efficiency and data quality

3. Acquiring data from primary or secondary data sources and maintaining databases

4. Collecting, organizing, and interpreting database metadata (i.e., data structures, data relationships, data element descriptions), and capturing this in our Enterprise Data Catalog.

5. Modelling data, including master data, reference data, and transactional data objects, attributes, and relationships

6. Assessing gaps and conflicts between data definitions across multiple software assets.

7. Creating database schemas from data models.

8. Writing SQL to analyze data and data structures in databases

9. Assessing data quality in assigned data domains.

10. Providing guidance on master data and reference data governance.

11. Assisting with curating the Enterprise Data Catalog to scan new databases, data pipelines, data object definitions, PowerBI reports, and related metadata.

Required Experience & Skills:

1. 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.

2. At least 5 years of experience working with data modeling tools such as Visio, ERWin, or equivalent.

3. SQL Server Management Studio (SSMS) to analyze data content, data structures, and stored procedures.

4. Data warehouse design including normalized structures for Operational Data Stores, and star schema structures for data marts.

5. On premise and Azure cloud databases including SQL Server and Synapse

Preferred Experience

1. Utility industry knowledge, especially gas utilities

2. Knowledge of typical data patterns for shared services domains such as Finance, Human Resources, and IT

3. Informatica data management tools (eg, Enterprise Data Catalog) including data profiling and data lineage analysis

4. Knowledge of CMDB data models

5. Data Governance principles and methods

6. Reference data management, especially using Informatica Reference360

Job Tags

Similar Jobs

Westman Atelier LLC

Freelance Makeup Artist - Vail, CO Job at Westman Atelier LLC

 ...Makeup Artist Westman Atelier is seeking an energetic makeup artist with a passion for clean, luxury beauty to represent the brand in-store while providing the highest level of customer experience. This position will be responsible for developing and maintaining customer... 

Baker Hughes

FS Spec III - INT Job at Baker Hughes

 ...Excel and Outlook High School Diploma/GED Desired Characteristics: Coil Tubing experience Downhole tool experience Frac plug millout experience. Downhole motor experience Cased Hole Fishing experience Work in a way that works for you We... 

ServisFirst Bank

Fraud Analyst Job at ServisFirst Bank

 ...Job Description Job Description At ServisFirst, Our Name is Our Mission. DUTIES AND RESPONSIBILITIES The Fraud Analyst reviews and analyzes customer account activity through Fraud prevention tools to avoid loss. The Fraud Specialist will investigate forgery... 

Aerotek

Plumbing Foreman Job at Aerotek

 ...Job Description Job Description Plumber Job Description As a Plumber, you will be responsible for the installation of plumbing products across various building systems in commercial applications. You will need to interpret plumbing and mechanical plans and specifications... 

CyberCoders

Plumbing Supervisor - commecial/multifamily Job at CyberCoders

 ...Job Description Job Description Plumbing Supervisor - commecial/multifamily Plumbing Supervisor/Foreman Position Overview The Plumbing Supervisor will oversee plumbing projects from inception to completion, ensuring that all work is completed on time, within...