Comtek-Group: Data Architect

Company: Comtek-Group
Location: Fort Worth
Posted on: January 15, 2021

Job Description:

Remote due to Covid, then on site in Irving, TX - W2 only, No C2C or third party candidates(Contract to Hire OR Direct Hire may be considered)Location: Irving, TX (Local candidates to the Dallas/Ft. Worth area)Job SummaryThe Senior is responsible for the overall design of the enterprise-wide data/information architecture and logical/ physical data models. This position will work closely with business users and technology leads to develop data strategy and information catalog and repository. This position will help with tool and technology evaluations and provide tactical and strategic direction and support for data warehouse and analytics initiativesJob Description:* 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 implement* Assists 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

Keywords: Comtek-Group, Fort Worth , Comtek-Group: Data Architect, Other , Fort Worth, Texas