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
...Admission - MDS Nurse |LPN or RN Come join our team as an admission/MDS nurse who assesses our new/existing patients to ensure all of the care needs are addressed and documented on the MDS. Pay Rate: LPN - $29.50 - $34.75 an hour based on licensure and experience...
...millions of people pay at the pump? We are launching a high-impact, phased Fuel Pre-Authorization project and need a Senior Debit Space Tester to spearhead our simulation and test execution. If you have 8+ years of payment processing experience, live in the US (EST...
U.S. Renal Care, a leader in renal treatment and patient care, is seeking a dedicated and compassionate Dialysis Licensed Practical Nurse (LPN) to join our team. In this role, the LPN will work closely with patients suffering from kidney disease and related conditions,...
...achieve your full potential. Unleash your talent and redefine what's possible. Job Description: Parsons is seeking a Process Engineer to support complex industrial and infrastructure projects. This role focuses on delivering high-quality process design, coordinating...
...Spezialisierung deutschlandweit Menschen bei ihrer Weiterbildung und beruflichen Neuorientierung.Fr Schulungseinstze im Bereich CompTIA A+ in unseren IT-Weiterbildungen suchen wir bundesweit Trainer/Dozenten (m/w/x) in Festanstellung .AufgabenIT-Trainings in...