Data Enterprise Architect IV

AE Business Solutions
Madison, WI Remote Full Time
POSTED ON 3/7/2024

Data Enterprise Architect IV (erwin)

Top Skills:

  • Expert knowledge in Complex SQL
  • Expert level knowledge of data modeling concepts, information security classification and categorization with erwin Data Modeling software

Detailed Job Description:
This position will serve as the Enterprise Data Architect and support the enterprise application and data platform. The position will support data management efforts across the organization 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 data interoperability strategy as well as a our data classification and security framework.

Ideal candidate will have additional skills and experience in the following areas:

  • Implementing data management standards to ensure consistency in the metadata categories within the data models.
  • Produce and enforce database development standards and ensure consistency across all of the data models within business intelligence.
  • Design, maintain and develop database architecture as well as conceptual, logical and physical data models. Ensure that all relevant aspects of data model (granularity, etc.) are taken into account. Analyze the logical and physical database models and guarantee models are in accordance with standards.
  • Data conversion and integration expertise to increase interoperability within the data platform
  • Be responsible for leading and facilitating 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 as well as 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

Additional details:

  • Phone and web based interviews will be acceptable.
  • MUST provide three (3) business references for the interview. (One reference must be a supervisory level.) However, an in
  • -person interview may be required.
  • Candidate will be required to provide their own equipment for this position (See job description for required specifications.)
  • Hybrid/On Site positions: 97% Remote - 3% Hybrid to Madison, WI - No designated work-space will be assigned however, selected candidate must be available to work at our location as needed.
  • Duration: 6/30/2024, with the potential to extend for an additional term(s)

List any special qualifications & years of experience:

Qualification


Experience



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.



Excellent organization, analytical and communication skills


5 of 5



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.



Excellent organization, analytical, and communication skills


7 years



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

Salary.com Estimation for Data Enterprise Architect IV in Madison, WI
$120,089 to $150,492
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

Sign up to receive alerts about other jobs with skills like those required for the Data Enterprise Architect IV.

Click the checkbox next to the jobs that you are interested in.

  • Big Data Skill

    • Income Estimation: $114,118 - $141,342
    • Income Estimation: $139,622 - $174,992
  • Big Data Analytics Skill

    • Income Estimation: $114,118 - $141,342
    • Income Estimation: $139,622 - $174,992
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at AE Business Solutions

AE Business Solutions
Hired Organization Address Rome, WI Full Time
Job Details AE Business Solutions is seeking a Help Desk Technician to take on a multi-year contract role in Madison! Th...
AE Business Solutions
Hired Organization Address Madison, WI Full Time
Job Details AE Business Solutions is looking for an Application Architect for a hybrid, contract position with a client ...
AE Business Solutions
Hired Organization Address Rome, WI Full Time
Job Details Security Analyst AE Business SolutionsUnited States (Remote) AE Business Solutions is looking for a Security...
AE Business Solutions
Hired Organization Address Rome, WI Full Time
Job Details AE Business Solutions is seeking a Project Manager to take on a fully-remote contract position! There is a p...

Not the job you're looking for? Here are some other Data Enterprise Architect IV jobs in the Madison, WI area that may be a better fit.

Enterprise Architect IV

Intellibee, Madison, WI

Enterprise Architect IV

Zenith Services, Madison, WI