• Location: Sauk City, Wisconsin
  • Remote: Remote
  • Type: Direct Hire
  • Job #4824

Carex Consulting Group is looking for an Experienced Data Solutions Architect with a well-known organization in the Madison, WI area. This is an exciting role that will have the opportunity to come in at the ground level of their Enterprise Data Management modernization. This role will partner with the business to define and document business requirements for the translation of business requirements into efficient and effective data implementations. This is a direct hire opportunity and can be remote. 

The company is looking to add a Data Solutions Architect to our Enterprise Data Management Team. This role will partner with the business to define and document business requirements for the translation of business requirements into efficient and effective data implementations. This position will perform functional business process analysis, determine proper acquisition and ingestion methods, determine placement of content in data storage and presentation layers, and identify data relationships and data transformation requirements. The Data Solutions Architect will also work with a wide variety of business users throughout the company to evaluate the state of data and propose data design and development solutions that deliver information capabilities in a reliable, easy to use manner. This position will document systems to clearly communicate to technical and non-technical personnel the required development or modifications, and impact to other areas.
What you will do:


  • Architects, designs, enhances, and supports delivery of data integrations, enterprise data warehouse, data marts, and data submissions.
  • Work in new cloud-based data architecture using Snowflake and Azure environment
  • Develop data solutions for growing analytic needs across the organization
  • Opportunity to transition to state-of-the-art cloud-based technologies
    • Identifies, develops, and documents data acquisition and delivery requirements to meet business and customer needs.
    • Facilitates group discussions and join data design sessions with the business area subject matter experts.
    • Designs data models and data processing flows for data acquisition, reporting and analysis.
    • Develops, implements, and maintains standards and procedures concerning the design and use of data for compilation and delivery.
  • Coordinates data solution delivery and supports data analysis and data development staff as necessary in the development and maintenance of data implementations.
    • Queries, analyzes, and interprets complex data stored in the source and target systems.
    • Play a role in supporting the company’s data governance program to provide definitions, visibility, and access controls for corporate data.
  • Works with business stakeholders to assist with data-related technical issues and supports their data infrastructure needs.

What you will bring:

  • Bachelor’s degree in Computer Science or related field, or comparable experience, and continuing education related to the position.
  • 8+ years of experience in information architecture, information management and data analysis, translating business requirements into technical data requirements, and data modeling experience in a data warehouse and OLTP environments.
  • 8+ years of SQL programming experience.
  • Expert problem solving and analytical skills.
  • Expert knowledge of data architecture and data modeling tools.
  • Expert knowledge of data warehousing and OLTP design principles and associated data management and delivery requirements.
  • Expert knowledge of SQL, analytical software, and MS Office Suite.
  • Solid verbal and written communication skills.
  • Ability to understand and communicate data management concepts to the business and within IT.
  • Effective interaction with internal and external parties including vendors and contractors.
  • Ability to manage multiple projects simultaneously; ability to direct others to timely completion.
  • Ability to work independently, under pressure, and be adaptable to change.
  • Must be inquisitive and seek answer to questions without being asked.

Carex Consulting Group is an equal opportunity employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity or Veteran status.


Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!