Job Description

Ref No.:18-00165
Location: Des Moines, Iowa
Title: Data Architect
Location: Austin, TX or Des Moines, Iowa
Duration: Contract-to-Hire
You will be responsible for the strategy, design, & execution of the logical & physical data architecture of core enterprise data solutions.
Drive design & implementation of data models in both structured & unstructured data stores, from transactional databases & reporting data warehouses to our new big data platform, & ensure the optimal & scalable integration of those repositories w/ internal applications & 3rd party systems to support business process, reporting, & analytics. Provide guidance & direction on data conversion, data migration, data quality & database performance.

Develops strategic data architecture for marketing data warehouses used for analytics & marketing use cases.

Determines structured & unstructured data requirements by cohesively blending the needs of the business w/ the feasibility of current & emerging data technologies & architecture standards. Partners w/ & becomes a knowledge expert across the organization to solve complex business problems, & form & test hypotheses using a wide array of skills.

Develops database & big data solutions by designing data architectures, including business architecture definition, data storage, data analytics, data transformation, & data access Works w/ the data engineering teams to design highly performant & scalable data solutions.

Provides best practice direction & even hands-on implementation of optimized relational database solutions.
Provides delivery leadership in the design, deployment & data conversion of complex data solutions, including data validation, UAT & Data Quality practices.
Creation, comprehensive understanding, maintenance & communication of logical & physical data models.
Responsible for creation & communication of data architecture standards & best practices, & data movement & mapping design.
Validation of the data quality & integration of all data architecture components, & capture of necessary data architecture metrics for benchmarking & trending to support quality of processes & related artifacts.
Understands & applies the enterprise data life cycle (creation, replication, archival, disposition of historical & PII data). Evaluating & recommending data query & modeling tools to assist w/ data architecture activities, dev. & communication of best practices for those tools, & activities to improve effectiveness & quality.
Assists developers in the design & improvement of database queries, provides training & learning opportunities. Supports deep business analytics & statistically-based data analysis projects to drive business value.

Establishes & participates in data management processes including data lineage, data profiling, data quality management, data stewardship & governance. Works w/ ETL developers, database & big data administrators, application interface developers, DevOps & IT operations personnel, as well as product management & clients.
EDUCATION/SKILLS BS or MS degree in a quantitative field such as computer science, physics, math, eng, or economics. Min. of 10 years designing large scale data models for data warehouse environments & 2 years w/ big data environments, including star schemas, OLAP cubes, modeling structured & semi-structured data, & ETL & streaming workflows.
Deep understanding of traditional & modern data ingestion, data storage, data processing & data access technologies. Extensive background database systems along w/ a strong knowledge of SQL, MySQL & MariaDB. Exp. w/ modern data technologies Hadoop, Hive, Map Reduce, Tez, Spark, Sqoop, Kafka, Flume. Exp. w/ Agile/Scrum development methodologies.
Exp. w/ workflow mgmt tech such as Airflow, Oozie, Azkaban, Luigi, etc. Exp. working in public cloud environment

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online