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

cmJHRVdpOEhnNWhmOG12c0FFUGV1bGxWL0E9PQ==
  • 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

Gerrity's

Grocery Clerk Part-Time Days & Weekends West Pittston Job at Gerrity's

 ...professional and courteous manner at all times while performing your defined responsibilities...  ...QUALIFICATIONS Willing to work part-time and weekends No minimum educational...  ...educational requirement needed Must be at least 16 years old Must be able to calculate figures,... 

Two Maids - Sugar Land

House Cleaner Job at Two Maids - Sugar Land

Job Description Job Description Sin noches, sin das feriados!$14 - 17/horas ms propinas Por qu deberas formar parte de nuestro equipo: 1. Sin trabajar noches y das feriados!2. Recompensamos el desempeo sobre la antigedad 3. Horarios flexibles 4. Ser parte...

CoStar Group

Staff Product Designer Job at CoStar Group

 ...Matterport - Staff Product Designer - Sunnyvale, CA Job Description Company Overview: CoStar Group (NASDAQ: CSGP) is a leading global provider of commercial and residential real estate information, analytics, and online marketplaces. Included in the S&P 5... 

QualDerm Partners

Physician Liaison - Charlotte, NC Job at QualDerm Partners

 ...individuals who can contribute to our mission of enhancing dermatological health and wellness. Position Overview: As a Physician Liaison at QualDerm Partners, you will be responsible for enhancing awareness of our physician services and increasing patient access... 

James G. Davis Construction

Corporate Administrative Assistant Job at James G. Davis Construction

 ...Corporate Administrative Assistant At DAVIS, we're redefining the way people experience construction by building success for all....  ...identity, national origin, disability, or status as a protected veteran. At Davis, our vision is to build a culture that is innovative...