Senior Data Architect

2 months ago

Chicago, United States Producers National Corporation Full time

Overview:

The Senior Data Architect is responsible for designing, implementing, and managing the organization's data architecture, including but not limited to data warehouse and data marts. This role ensures that data across the organization is well-architected, structured, integrated, and managed in a way that supports business operations and analytics. The Senior Data Architect works closely with the Director of Business Intelligence and Analytics to ensure that the underlying data infrastructure meets the organization's reporting and analytical needs, with a particular focus on the ETL processes that form the backbone of data integration.


Job Responsibilities:


Data Architecture Design:

  • Maintain and extend the enterprise data architecture, including data models, database structures, data warehouses, data lakes, and integration layers.
  • Ensure all initiatives align with our currently defined data architecture, industry standards, and best practices, and support scalability, security, and performance requirements.


Data Governance and Quality:

  • Help define and enforce data governance policies and standards across the organization to ensure data accuracy, consistency, and security.
  • Implement data quality management processes, including data validation, cleansing, and monitoring, to ensure high data integrity.


Data Integration:

  • Design, develop, and oversee ETL processes to ensure efficient data extraction, transformation, and loading across various data sources and systems.
  • Collaborate with data engineers and ETL developers to optimize ETL workflows for performance, reliability, and scalability.
  • Implement best practices for ETL processes, including data validation, error handling, and logging to ensure data integrity throughout the pipeline.

Data Infrastructure for Advanced Analytics and Predictive Models:

  • Design and manage the data infrastructure required for predictive modeling, machine learning, and data mining, ensuring that data pipelines are optimized for these processes.
  • Collaborate with the Director of Business Intelligence and Analytics to ensure that the data preparation processes (e.g., ETL) meet advanced analytics needs.
  • Build and maintain the infrastructure for deploying predictive models and machine learning algorithms into production environments. Ensure that these models can be scaled, automated, and integrated into business operations effectively.


Technology and Infrastructure Management:

  • Evaluate, select, and implement data management technologies, including data storage, processing platforms, and integration tools.
  • Ensure the data infrastructure supports the needs of business intelligence and analytics functions, including data accessibility and processing speed.


Collaboration and Leadership:

  • Collaborate with IT, security, and business teams to continue to align data architecture with overall technology and business strategies.
  • Lead and mentor other data professionals, providing architectural guidance and promoting best practices in data management.

Compliance and Security:

  • Collaborate with the IT Operations team to continue to enforce data security protocols to protect sensitive data and ensure compliance with relevant regulations (e.g., PII, PCI, HIPAA).
  • Maintain audit trails and documentation of data architecture and governance processes.

Innovation and Continuous Improvement:

  • Stay abreast of emerging data technologies and trends and integrate innovative solutions into the organization's data architecture.
  • Continuously evaluate and improve the data architecture to support evolving business needs and technology advancements.


Skills and Experience:

  • 10+ years of experience in data architecture, data management, and ETL processes.
  • 10+ years of experience developing using structured query language (SQL)
  • 3+ years of experience working with Azure-native SQL Databases
  • Proven experience designing and implementing enterprise data architectures for the Property and Casualty Insurance Industry.
  • Experience architecting solutions with row-level security is strongly preferred.


Qualifications:

  • Bachelor’s or Master’s degree in Computer Science or a related field.
  • Strong understanding of data governance, data quality, ETL best practices, and data security practices in Insurance.
  • Excellent leadership and collaboration skills, with the ability to work across departments and bring alignment.
  • Must be a hands-on individual who enjoys building data warehouses and understands data productization concepts.
  • Relentless focus on the delivery of value to the business


Culture:


Communication

  • You listen well instead of reacting fast
  • You are concise and articulate in speech and writing
  • You maintain calm poise in stressful situations

Impact

  • You accomplish amazing amounts of important work
  • You demonstrate consistently strong performance so colleagues can rely upon you
  • You exhibit bias-to-action and avoid analysis-paralysis

Curiosity

  • You learn rapidly and eagerly
  • You seek to understand our strategy, market, and customers.

Innovation

  • You challenge prevailing assumptions when warranted, and suggest better approaches
  • You keep us nimble by minimizing complexity and finding time to simplify

Courage

  • You say what you think even if it is controversial
  • You take smart risks
  • You question actions inconsistent with our values

Passion

  • You inspire others with your thirst for excellence
  • You celebrate wins.

Honesty

  • You are quick to admit mistakes
  • You are open when you disagree with others.

Selflessness

  • We seek what is best for Producer’s National rather than best for ourselves or our group
  • You make time to help colleagues
  • You share information openly and proactively.

  • Senior Data Architect

    1 month ago

    chicago, United States Producers National Corporation Full time

    Overview:The Senior Data Architect is responsible for designing, implementing, and managing the organization's data architecture, including but not limited to data warehouse and data marts. This role ensures that data across the organization is well-architected, structured, integrated, and managed in a way that supports business operations and analytics. The...

  • Senior Data Architect

    1 month ago

    chicago, United States Producers National Corporation Full time

    Overview:The Senior Data Architect is responsible for designing, implementing, and managing the organization's data architecture, including but not limited to data warehouse and data marts. This role ensures that data across the organization is well-architected, structured, integrated, and managed in a way that supports business operations and analytics. The...

  • Data Architect

    1 week ago

    Chicago, United States Prairie Consulting Services Full time

    Data Architect/ Sr. Data ModelerChicago, IL/ Tempe, AZLong term contract** Don't miss this urgent opportunity **Our direct client is looking for Data Architect/ Senior Data Modeler to help create a foundational data model to underpin interactive PowerBI reports and dashboards that provide insights and help drive key business decisions for internal...

  • Senior Data Architect

    6 months ago

    Chicago, United States 1872 Consulting Full time

    Senior Data Architect - Data Modeling focus Chicago or Dallas - onsite 3 days/week, remote 2 days/week SUMMARY We are seeking a Senior Data Architect, with strong data modeling skills, to improve our current data posture on what is a leading real estate analytics platform. You'll spend a lot of your time developing data models using a variety of canonical...

  • Data Architect.

    2 months ago

    Chicago, United States Insight Enterprises Full time

    Position Overview The Data Architect is responsible for implementing and communicating new standards across the Data Engineering teams for technical design and automation to enable reporting and focus on evolving best practices alongside Managers within the team.  The Data Architect will focus on the most complex business requests, supporting other...

  • Data Architect

    2 days ago

    Chicago, United States Spectraforce Technologies Full time

    Role: Data ArchitectWork Location: Chicago, IL or Tempe, AZDuration: 6+ MonthsWork Model: Hybrid - onsite 3 days per weekProject Overview:NT IT Metrics & Analytics is looking for a highly experienced Data Architect. As we evolve to the next level of dashboards and create a more cohesive and flexible user experience, we are looking for a data modeler to more...

  • Data Architect

    2 weeks ago

    Chicago, United States CliftonLarsonAllen Full time

    CLA is a top 10 national professional services firm where our purpose is to create opportunities every day, for our clients, our people, and our communities through industry-focused wealth advisory, digital, audit, tax, consulting, and outsourcing services. Even with more than 8,500 people, 130 U.S. locations, and a global reach, we promise to know you and...

  • Uturn Data Solutions | Cloud Architect

    7 days ago

    chicago, United States Uturn Data Solutions Full time

    OverviewUturn Data Solutions is a technology services firm helping businesses achieve digital transformation through the use of cloud technologies. Recognized by Crain’s as one of Chicago’s fastest growing companies in 2024 (#9) and 2023 (#11), we are market leaders in leveraging the power of AWS to accelerate innovation, increase operational efficiency...

  • Uturn Data Solutions | Cloud Architect

    7 days ago

    chicago, United States Uturn Data Solutions Full time

    OverviewUturn Data Solutions is a technology services firm helping businesses achieve digital transformation through the use of cloud technologies. Recognized by Crain’s as one of Chicago’s fastest growing companies in 2024 (#9) and 2023 (#11), we are market leaders in leveraging the power of AWS to accelerate innovation, increase operational efficiency...

  • Data Architect

    5 days ago

    Chicago, United States CliftonLarsonAllen Full time

    CLA is a top 10 national professional services firm where our purpose is to create opportunities every day, for our clients, our people, and our communities through industry-focused wealth advisory, digital, audit, tax, consulting, and outsourcing services. Even with more than 8,500 people, 130 U.S. locations, and a global reach, we promise to know you and...

  • Senior Data Architect

    3 weeks ago

    Chicago, IL, United States Producers National Corporation Full time

    Overview:The Senior Data Architect is responsible for designing, implementing, and managing the organization's data architecture, including but not limited to data warehouse and data marts. This role ensures that data across the organization is well-architected, structured, integrated, and managed in a way that supports business operations and analytics. The...

  • Data Architect

    3 weeks ago

    Chicago, United States Compunnel Full time

    Hi,Good Afternoon,Hope you are doing well.Please let me know if you are interested in this position.Position : Data Principal ArchitectLocation : Chicago, IL Mode of Hire : Fulltime Expertise in data architecture and design, for both structured and unstructureddata Expertise in data modeling and experience in developing POC's Expertise with all aspects of...

  • Data Architect

    1 month ago

    chicago, United States Compunnel Inc. Full time

    Hi,Good Afternoon,Hope you are doing well.Please let me know if you are interested in this position.Position : Data Principal ArchitectLocation : Chicago, IL Mode of Hire : Fulltime • Expertise in data architecture and design, for both structured and unstructureddata• Expertise in data modeling and experience in developing POC’s• Expertise with all...

  • Data Architect

    1 month ago

    chicago, United States Compunnel Inc. Full time

    Hi,Good Afternoon,Hope you are doing well.Please let me know if you are interested in this position.Position : Data Principal ArchitectLocation : Chicago, IL Mode of Hire : Fulltime • Expertise in data architecture and design, for both structured and unstructureddata• Expertise in data modeling and experience in developing POC’s• Expertise with all...

  • Data Architect

    1 month ago

    Chicago, United States Compunnel Inc. Full time

    Hi,Good Afternoon,Hope you are doing well.Please let me know if you are interested in this position.Position : Data Principal ArchitectLocation : Chicago, IL Mode of Hire : Fulltime • Expertise in data architecture and design, for both structured and unstructureddata• Expertise in data modeling and experience in developing POC’s• Expertise with all...

  • Data Architect

    3 weeks ago

    Chicago, United States Omni Inclusive Full time

    * Responsible for ensuring that the data management and governance frameworks are in place and adhered to * Responsible for Architecting Data engineering pipelines including data acquisition, Ingestion, management, processing, publishing by leveraging various AWS services * Responsible for developing and optimizing database models to store and retrieve...

  • Senior Data Architect

    4 weeks ago

    Chicago, Illinois, United States Hexaware Technologies Full time

    Job DescriptionWe are looking for a highly skilled Technical Architect to join our team at Hexaware Technologies.Key Responsibilities:Design and build complete data pipelines for ODS, Staging, Data Warehousing, and Data Marts using SQL Server Integration Services (ETL) or other related technologies.Implement Data Warehouse solutions (Star Schema, Snowflake...

  • Cloud Architect

    1 week ago

    Chicago, United States Uturn Data Solutions Full time

    OverviewUturn Data Solutions is a technology services firm helping businesses achieve digital transformation through the use of cloud technologies. Recognized by Crain’s as one of Chicago’s fastest growing companies in 2024 (#9) and 2023 (#11), we are market leaders in leveraging the power of AWS to accelerate innovation, increase operational efficiency...

  • Data Architect

    4 weeks ago

    Chicago, Illinois, United States IT Associates Full time

    Job Title: Data ArchitectAt IT Associates, we are seeking a skilled Data Architect to design and implement robust data processes and architectures. The ideal candidate will possess a deep understanding of data concepts, including ETL, data structures, and data modeling.Main Responsibilities:Design and implement data processes and architecturesCollaborate...

  • Data Architect

    6 months ago

    Chicago, United States CyberTec Full time

    Job Title : Data Architect- Location: Chicago , IL Must live in Chicago and go downtown Job Type : 75% onsite Duration : 12 months Opening : 1 Opening ! Must have: - Data +Application Architect for MDM solution. - Design a Unique Guest ID real-time integration solution, with multiple data providers and multiple consumers. - Experience with MDM solutions and...