Data Warehouse Architect

2 weeks ago


Madison, Wisconsin, United States Novalink Solutions LLC Full time

We are seeking an experienced Data Warehouse Architect to join our team at Novalink Solutions LLC. As a key member of our data analytics group, you will be responsible for designing and implementing scalable data warehouses that meet the evolving needs of our organization.

Estimated salary: $120,000 - $180,000 per year.

Job Description:

The successful candidate will have a strong background in data warehousing, ETL/ELT, and database design. You will work closely with our data warehouse team, BI developers, software engineers, and external partners to build and maintain our academic and administrative data warehouse (AADW). Your responsibilities will include:

  • Designing and testing data warehouses, including data design, database architecture, metadata, and repository creation
  • Designing, developing, and maintaining relational databases for data storage and data mining
  • Assisting internal database teams with initial data transfers into new warehouses
  • Suggesting continuous improvement in performance of data warehouses and ensuring data security

Requirements:

To be considered for this role, you must have:

  • A minimum of 5 years of experience in multi-system data integration
  • Experience with data integration through extract, transform, load (ETL) & ELT patterns
  • Experience with data modeling and relational database design
  • Experience with data warehouse architecture, maintenance, and auditing/logging

Nice to Have:

  • Experience with enterprise data integration tools (e.g., Informatica Intelligent Cloud Services (IICS) Data Integration, Informatica PowerCenter, dbt)
  • Experience with structured and unstructured data
  • Experience with cloud data storage (e.g., Redshift, Snowflake)
  • Experience with data virtualization platforms (e.g., Denodo)

Benefits:

Novalink Solutions LLC offers a competitive salary, excellent benefits package, and opportunities for professional growth and development.


  • Cloud Data Architect

    1 month ago


    Madison, Wisconsin, United States ALLIANT ENERGY CORPORATE SERVICES Full time

    **Job Title:** Cloud Data Architect**Company Overview:** At Alliant Energy, our purpose is to serve customers and build stronger communities. We are passionate about powering beyond the market challenges of today, while powering what's next in energy.**Salary:** The estimated salary for this position is around $120,000 per year.**Job Description:We are...


  • Madison, Wisconsin, United States AMERICAN FAMILY MUTUAL INSURANCE CO Full time

    Company OverviewAmerican Family Mutual Insurance Co is a leading insurance provider that is shaping the future of the industry. We are seeking a highly skilled Data Engineer II Cloud Data Warehouse to join our team.

  • Cloud Data Architect

    4 weeks ago


    Madison, Wisconsin, United States Saxon Global Full time

    Saxon Global is seeking a highly skilled Cloud Data Architect to join our team.Job Summary:We are looking for a seasoned Cloud Data Architect to design, develop, and maintain robust and scalable data pipelines using AWS services such as Redshift, Glue, and DMS.Key Responsibilities:Collaborate with cross-functional teams to understand business requirements...


  • Madison, Wisconsin, United States Quartz Health Solutions Full time

    About Quartz Health SolutionsWe are seeking a highly skilled Senior ETL Developer to join our Enterprise Data Management (EDW) Team. This role will be responsible for the creation and maintenance of extract, transform, and load (ETL) logic necessary to cleanse and move data from various source systems into the corporate data warehouse.Key...


  • Madison, Wisconsin, United States Molina Healthcare Full time

    Job Title: Big Data Solutions ArchitectWe are seeking a highly skilled Big Data Solutions Architect to join our team at Molina Healthcare.Molina Healthcare offers a competitive benefits and compensation package. Salary Range: $67,725 - $155,508 per annum.The ideal candidate will have experience in building stream-processing systems using solutions such as...


  • Madison, Wisconsin, United States Syntricate Technologies Full time

    About the JobWe are seeking an experienced Warehouse Data Developer III to join our team at Syntricate Technologies. As a key member of our data warehousing team, you will be responsible for designing, developing, and implementing data warehouse solutions using various tools and technologies.The successful candidate will have a strong background in ETL...

  • Cloud Architect

    2 weeks ago


    Madison, Wisconsin, United States Molina Healthcare Full time

    Job Description:Molina Healthcare is seeking a highly skilled Cloud Architect - Big Data to design and implement cloud-based big data solutions. The ideal candidate will have experience working with cloud platforms such as AWS and Azure, as well as big data technologies such as Hadoop, Spark, and NoSQL databases.Responsibilities:- Design and implement...


  • Madison, Wisconsin, United States AMERICAN FAMILY MUTUAL INSURANCE CO Full time

    Job Summary: We are seeking a highly skilled Data Engineer II Cloud Data Warehouse to join our team at American Family Mutual Insurance Co. In this role, you will be responsible for designing, building, and maintaining large-scale cloud data warehouses to support business intelligence and analytics applications.Key Responsibilities:Design and implement data...


  • Madison, Wisconsin, United States Saxon Global Full time

    Job SummaryWe are seeking a highly skilled AWS Cloud Engineer to join our team as a Data Pipelines Specialist. In this role, you will design, develop, and maintain robust and scalable data pipelines using AWS services such as Redshift, Glue, and DMS.About the RoleYou will collaborate with data engineering and development teams to understand business...


  • Madison, Wisconsin, United States Serigor Inc. Full time

    Job OverviewSerigor Inc. is seeking a highly skilled Senior Data Modeler and Architect to join our team in Madison, WI.


  • Madison, Wisconsin, United States Focused HR Solutions Full time

    Data Warehouse Developer OpportunityFocused HR Solutions is seeking an experienced Data Warehouse Developer to join our team. This 8-month contract position offers the opportunity to work with a leading organization in Madison, WI.Job Overview:The successful candidate will be responsible for designing and developing data warehouse solutions using Informatica...


  • Madison, Wisconsin, United States HexaQuEST Global, Inc. Full time

    Job DescriptionWe are seeking an experienced Business Intelligence Developer - Data Architect to join our team at HexaQuEST Global, Inc. The ideal candidate will have a strong background in data warehousing and business intelligence solutions.Key Responsibilities:Create new Power BI reports for various purposes and adjust existing reports, including SQL...


  • Madison, Wisconsin, United States Focused HR Solutions Full time

    About the RoleThis is a unique opportunity to join Focused HR Solutions as a Senior Enterprise Data Architect, supporting data management efforts across the Bureau to standardize data modeling practices. The ideal candidate will have a Bachelor's or Master's Degree in Computer Science, Information Systems, or other related field and 10+ years of experience...


  • Madison, Wisconsin, United States AMERICAN FAMILY MUTUAL INSURANCE CO Full time

    About the Role: As a Data Engineer II Cloud Data Warehouse, you will play a critical role in shaping the company's data strategy and ensuring seamless data flow across the organization. You will be working closely with cross-functional teams to design, build, and maintain large-scale cloud data warehouses.Responsibilities: You will be responsible for...


  • Madison, Wisconsin, United States Focused HR Solutions Full time

    As a leading provider of human resources solutions, Focused HR Solutions is excited to offer a C-level data architect position that presents an excellent opportunity for a highly skilled professional.About the RoleThis full-time, 97% remote position requires strong expertise in enterprise-wide information architecture planning, data modeling concepts, and...


  • Madison, Wisconsin, United States AMERICAN FAMILY MUTUAL INSURANCE CO Full time

    About This Opportunity: We are seeking an experienced Data Engineer II Cloud Data Warehouse to join our team at American Family Mutual Insurance Co. In this role, you will be responsible for designing, building, and maintaining large-scale cloud data warehouses to support business intelligence and analytics applications.Key Responsibilities: You will be...


  • Madison, Wisconsin, United States Syntricate Technologies Full time

    Job SummaryWe are seeking an experienced System Architect IV to join our team at Syntricate Technologies.About the RoleThis is a 12+ month contract position that requires local presence or relocation. As a key member of our modernization effort, you will be responsible for designing and evaluating system architecture in coordination with technical and...


  • Madison, Wisconsin, United States Newance Full time

    Newance Job Description:We are looking for a talented Data Analyst to join our team. As a key member of our organization, you will play a vital role in driving business decisions through data-driven insights. With a strong background in data analysis and business intelligence, you will be responsible for managing our data warehouse, creating reports and...

  • Senior Data Architect

    2 weeks ago


    Madison, Wisconsin, United States Alliant Energy Full time

    At Alliant Energy, we are committed to delivering exceptional services that meet the evolving needs of our customers. As a Senior Data Engineer (Snowflake/ Informatica), you will play a pivotal role in advancing our data and analytics capabilities. This position requires a strong technical background, excellent communication skills, and the ability to...

  • Data Engineer

    2 weeks ago


    Madison, Wisconsin, United States Molina Healthcare Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Molina Healthcare. As a Data Engineer, you will be responsible for designing and building data solutions with an emphasis on performance, scalability, and high-reliability. Your primary focus will be on choosing optimal solutions to use for collecting, storing,...