Job Description :

Role: Data Architect

Duration: 6-month C2H

Location: Kansas City, MO (Onsite)

Responsibilities:

  • Perform assigned activities/schedules for multiple projects throughout the project lifecycle and problem resolution. Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
  • Assess, design, and develop data models and/or technical specifications for internal and external data for an application system, metadata, views or related database structures, data warehouse, and integrations for a complete solution for small to medium project(s), including presentation of data within the operational and analytics tools used within the enterprise.
  • Adhere to, recommend, and/or enforce database development standards
  • Participate in complex testing, analyze testing results to ensure solution needs, and oversee resolution of issues based on test results
  • Provide technical support for incidences and service requests on/off-hours. Assist junior staff or clients as needed
  • Maintain inventory of enterprise data architecture blueprints, CMDB integration catalog, and end-user 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 assure production systems meet availability requirements and hardware enhancements are scheduled appropriately. Plan and install upgrades of database management system software to enhance database performance

CORE COMPETENCIES FOR SUCCESS IN ALL ROLES: instills trust, communicates effectively, action-oriented, accepts accountability, and collaborates with others.
CRITICAL COMPETENCIES
Customer Focus - Building strong customer relationships and delivering customer-centric solutions
Tech Savy - Anticipating and adopting innovations in business-building digital and technology applications
Decision Quality - Making good and timely decisions that keep the organization moving forward
Resourcefulness - Securing and deploying resources effectively and efficiently
Interpersonal Savvy - Relating openly and comfortably with diverse groups of people
Self Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels
Situational Adaptability - Adapting approach and demeanor in real-time to match the shifting demands of different situations
EDUCATION & EXPERIENCE
Bachelor's degree in Computer Science, IT, or a related field with at least 3 years of related work experience
1+ years' in a data architect role
3+ years' analyzing and designing applications and/or BI/Analytics solutions
Experience with T-SQL required
Experience in one or more ETL Tools required: Informatica PowerCenter, SSIS, or equivalent
Experience in one or more Operational Reporting Tools required: COGNOS, SSRS, or equivalent
Experience in one or more Self Service Analytics Tools required: Tableau, Power BI, or equivalent
Experience and/or conversant in one or more of the following emerging data technologies required: columnar and NoSQL, predictive analytics, data visualization, and unstructured data
Experience in one or more software development lifecycle methodologies required: Agile, Scrum, Waterfall, etc.
Experience in one or more of the following Enterprise Business Solutions preferred: Infor M3, JD Edwards Enterprise One, etc.
Experience in many of the following business processes preferred: process manufacturing, sales and marketing, supply chain planning, inventory management, logistics optimization and distribution, procurement and plant maintenance, food safety and quality assurance, breeding and animal welfare, environmental resource management, finance, etc.
Experience in the one or more of the following industries preferred: Food and Beverage, Livestock, Energy, etc.
             

Similar Jobs you may be interested in ..