Comtek Group
:Design and documentation of logical and physical analytical data models for transactional and analytical databases.Works closely with Data Stewards, Data Governance and developers to create and maintain data dictionary and data lineage.
Helps investigate and resolve data anomalies including data quality issues and ambiguous data definitions.
Recommends data integrity checks and controls to ensure data quality.Obtains new data requirements from the business and business analysts; and coordinates effortswith the developers, DBA’s and Business Analysts.
Performs as data SME in guiding both business and IT users of data.Source system analysis, data profiling and creating design documents and Source2Target mappings for the development teams to implementAssists with large-scale data migrations across the enterprise as well as with optimization and scalability efforts.Works closely with key data consumers (report analysts, data scientists etc.) to understand needs and challenges and come up with strategy and solutions.Ensures compliance with Client’s policies & procedures, safety, state and federal laws, regulations and standards.Other duties as assigned.Required:Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.Eight (8) to ten (10) years’ experience in designing conceptual, logical and physical data models using major enterprise data modeling tools (Erwin experience is preferred) which must include; At least 5 years’ experience in strategic data planning, standards and procedures; At least 5 years’ experience in data quality engineering, metadata consolidation and integration, metadata model development and maintenance, repository management, data warehouse design and data mining, and data security; At least 5 years’ experience in leveraging enterprise data warehouse modeling constructs, methodologies and practices to ensure flexible, scalable, maintainable, and high-performing physical databases; At least 5 years’ experience in data analysis and forensics.Proficiency in SQLMS Azure Cloud (Synapse)Good knowledge of ETL, ELT and batchExperience with analytics, data visualization tools a plus