1.20 Enterprise Architect

Focused HR Solutions•Madison, WI

5d•Hybrid

About The Position

This position will support data management efforts across the Bureau to standardize data modeling practices to better align data architecture with technology, application architecture, and security needs. The position will work closely with the database management and application development teams to enhance data interoperability and data integration efforts. This position will play a lead role in establishing DCF’s data interoperability strategy as well as data classification and security framework. The ideal candidate will have the ability to be self-directed and able to work independently. The ideal candidate will have excellent written and oral communication and will have experience creating and documenting technical processes and standards.

Requirements

Expert knowledge in enterprise-wide information architecture planning
Expert-level knowledge of data modeling concepts
Expert-level knowledge of information security classification and categorization
Expert-level knowledge of Erwin Data Modeling software
Bachelor's or Master's Degree in Computer Science, Information Systems, or other related field, or equivalent work experience.
Typically has 10 or more years of experience with large and complex database management systems, business intelligence tools and applications.
Conceptual, Logical and Physical Data Modeling | 10+ years
Create database objects | 7+ years
Information Security concepts | 5+ years
Data integration/API integration | 5+ years
Data Warehouse - Experience in data warehouse design and development | 7 years
Database design | 7+ years
Erwin Data Modeling Software | 7 years
Expertise in implementation of large complicated models and processes | 5+ Yrs.
DB2 | 3 Yrs.
Experience in extract, transform, and load coding using Informatica | 7 Yrs.
Ability to navigate and query a relational database (Oracle) | 7+ Yrs.
Informatica | 1 years
Knowledge of Kimball data warehouse design principals | 7 years
Creating, reviewing and tuning SQL scripting | 5 years
Data analysis | 5 years
Oracle data dictionary views | 3 years
Metadata tools | 3 years

Nice To Haves

Excellent organization, analytical and communication skills | 5 of 5
Excellent organization, analytical, and communication skills | 7 years

Responsibilities

Support data management efforts across the Bureau to standardize data modeling practices.
Align data architecture with technology, application architecture, and security needs.
Work closely with database management and application development teams to enhance data interoperability and data integration efforts.
Play a lead role in establishing DCF’s data interoperability strategy.
Play a lead role in establishing DCF’s data classification and security framework.
Implement data management standards to ensure consistency in metadata categories within data models.
Produce and enforce database development standards and ensure consistency across all data models within DCF business intelligence.
Design, maintain, and develop database architecture as well as conceptual, logical, and physical data models.
Ensure all relevant aspects of data models (granularity, etc.) are taken into account.
Analyze logical and physical database models and guarantee models are in accordance with standards.
Provide data conversion and integration expertise to increase interoperability within the data platform.
Lead and facilitate communication with business customers, IT staff, and other stakeholders, incorporating business requirements into data model design.
Translate technical aspects of data modeling into language that non-technical users can understand.
Work with both technologists and non-technical users with ease and approachability.
Make recommendations on data maintenance tactics for slowly changing dimensions, data roll-off / archival planning, etc.
Coach, mentor, and lead other data modelers.