JOB PURPOSE

The IT Data Architect evaluates databases and builds a conceptual, logical, and physical database based on organizational strategies, structural requirements, and business requirements for enhancing new and existing solutions for the business. The role is a key participant in the project development life cycle and responsible for identifying data gaps in the functional coverage for application systems, operational reporting, and/or the data warehouse for analytics; and ensures the suite of solutions being used by the organization is recoverable, scalable, reliable, and secure. The Data Architect is responsible for ensuring standards are followed.

Responsibilities & Tasks

• 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 appropriate. Plan and install upgrades of database management system software to enhance database performance

Bachelor’s degree in Computer Science, Information Systems, or Computer Programming preferred

REQUIREMENTS

• 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.

Job Types: Full-time, Contract

Pay: $100,000.00 - $120,000.00 per year

Schedule:

• 8 hour shift
• Monday to Friday

Work Location: Hybrid remote in Merriam, KS 66202

Please Note :
caminobluff.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, caminobluff.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.