Enterprise Data Analyst Job at BizTek People, Inc. | APA International Placement Consultant..., United States

T1BJUkxhWXR6N1BGSy84YVNRZnNobENMVnc9PQ==
  • BizTek People, Inc. | APA International Placement Consultant...
  • United States

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

Remote work

Similar Jobs

Giant Eagle

Staff Pharmacist Job at Giant Eagle

 ...Job Summary As a Pharmacist, you will consistently build relationships with patients exceeding their needs by providing safe, accurate...  ...in the pharmacy industry. Adhere to all company, state, federal policies, laws and regulations including HIPAA.... 

DataAnnotation

Experience Designer Job at DataAnnotation

 ...Join to apply for the Experience Designer role at DataAnnotation . We are looking for an Experience Designer to help train and improve cutting-edge AI models. Youll assess and enhance how AI systems understand, generate, and evaluate design work including interfaces... 

Colorado Mountain College

Administrative Technician/Proctor Job at Colorado Mountain College

 ...Administrative Technician/Proctor The Administrative Technician/Proctor works in support of the business or College operations. The primary role is in support of academic or student services functions. Duties are performed using either established standard guidelines and... 

Publicis Groupe Holdings B.V

Junior Copywriter Job at Publicis Groupe Holdings B.V

 ...can create unforgettable experiences that enrich lives. Join us at razorfish.com. Overview Razorfish is looking for a Jr. Copywriter with both conceptual and hands-on chops who can turn an insight into a compelling headline, a concept into a campaign, and a... 

ProDrivers

Class A Hazmat Driver Job at ProDrivers

 ...ProDrivers is seeking a class A Local Truck Driver in the Canal Winchester, OH area! Must have 2 years of CDL A driving experienceand hazmat endorsement . Truck Driver Job Description: Local Truck Driver Pay: $30.50 / hour plus shift differential $2.50/hr...