25 Jan
Data Architect
Kansas, Mission , 66201 Mission USA

Vacancy expired!

SummaryThe IT Data Architect will evaluate existing databases and then build a conceptual, logical, and physical database, based on organizational strategies, structural requirements, and business requirements for enhancing new and existing business solutions. This role is a key participant in the project development lifecycle and is responsible for identifying data gaps in the functional coverage of application systems, operational reporting, and/or the data warehouse for analytics to ensure the suite of solutions being used by the organization is recoverable, scalable, reliable, and secure.

Responsibilities
  • Perform assigned activities/schedules for multiple projects throughout the project lifecycle including problem resolution.
  • Collaborate with system architects, software architects, design analysts, and others to understand the business or industry requirements.
  • Assess, design, and develop data models and/or technical specifications for internal and external data used by application systems, metadata, views, related database-structures, and the data warehouse to integrate into a complete solution.
  • Participate in complex testing; analyze testing results to ensure the solution meets established needs and oversee the resolution of issues, based on test results.
  • Maintain inventory of enterprise data architecture blueprints, CMDB Integration Catalog, and end users’ Dictionary of Data.
  • Adhere to best practice standards for table names, column names, data types, etc.
  • Identify, evaluate, and recommend hardware or software technologies to achieve desired database performance.
  • Monitor and report systems resource consumptions trends to ensure production systems meet availability requirements and that hardware enhancements are scheduled appropriately.
  • Plan and install upgrades of database management system software to enhance database performance.

Requirements
  • 1+ year of experience in a Data Architect role.
  • 3+ years of experience analyzing and designing applications and/or BI/Analytics solutions.
  • Experience with T-SQL.
  • Experience in one or more ETL tools: Informatica PowerCenter, SSIS, or equivalent.
  • Experience in one or more operational reporting tools: Cognos, SSRS, or equivalent.
  • Experience in one or more self-service analytics tools: Tableau, Power BI, or equivalent.
  • Experience and/or conversant in one or more of the following emerging data technologies: Columnar & NoSQL, Predictive Analytics, Data Visualization, and Unstructured Data.
  • Experience in one or more software development lifecycle methodologies: Agile, Scrum, Waterfall, etc.
This is a 6-month Contract for Hire with our Merriam, KS client. 100% Paid employee medical/Dental Benefits, Paid time off, Paid Holidays, and 401(k) (with immediately-vested company match) available with TriCom during the contract period. H1-B Visa sponsorship is not available for this position. No third-parties, please.

Vacancy expired!


Report job