Senior Data Architect

TECHNOLOGY PARTNERS INC; St. Louis (MO); On-site; USD 63,000 - 90,000; Full time

Job summary

Technology Partners Inc is seeking a Senior Data Architect to lead data strategy and integration for insurance analytics, with a focus on Azure Cloud and scalable data platforms.

You will collaborate with IT stakeholders, actuaries, and data scientists to design data warehouses, model complex data structures, optimize performance, and ensure security and regulatory compliance. This role includes mentoring junior engineers and driving modern data architectures across cloud environments.

Qualifications

• 10+ years in data warehouse and enterprise data applications.
• Experience with Azure cloud data management and data modeling.
• Proficient in SQL and NoSQL databases; strong SQL development.
• Hands-on with ETL/ELT frameworks (Azure Data Factory, Informatica, Talend, SSIS).
• Industry knowledge in healthcare insurance or finance helpful.
• Automation skills with Unix, PowerShell, or SQL for data pipelines.

Responsibilities

• Design scalable, secure data systems and warehouses integrating multiple sources.
• Develop canonical data models defining structures and relationships.
• Optimize performance through indexing and partitioning; integrate new elements.
• Collaborate with IT, actuaries, and data scientists for robust solutions.
• Research and propose modern data frameworks including data lakes and cloud analytics.
• Maintain technical docs for analysis, systems, and user needs.
• Mentor and coach data developers and integration engineers.

Skills

Azure Cloud

Data Modeling

ETL/ELT

SQL

NoSQL

Unix scripting

PowerShell

SQL writing

Tools

Azure Data Factory

Informatica

Talend

SSIS

Job description

Technology Partners is currently seeking a talented Senior Data Architect.

Do you have experience with Azure Cloud, advanced Data Modeling, and ETL/ELT frameworks?

Let us help you make your next big career move a reality!

What You Will Be Doing:

In this role, you will provide critical data architecture and integration support for insurance products and analytics applications. You will manage both maintenance and new project development, including product launches, data warehouse enhancements, and complex interfaces with internal and external clients. You will also be responsible for ensuring strict adherence to security protocols and financial control processes.

Key Responsibilities:

• Designing Data Systems:Create scalable, secure data systems and warehouses that integrate data from various sources.
• Data Modeling:Develop models to define structures, attributes, and relationships.
• Performance Optimization:Troubleshoot and integrate new elements to improve system performance via indexing and partitioning.
• Collaboration:Work with IT stakeholders, Actuaries, and Data Scientists to ensure robust solutions.
• Modern Practices:Research and propose modern frameworks, including data lakes and cloud analytics platforms.
• Documentation:Maintain technical documentation for analysis, system applications, and user requirements.
• Leadership:Mentor and coach data developers and integration engineers.

Required Skills & Experience:

• Experience:Minimum of 10 years in data warehouse and multi-user enterprise data applications.
• Azure Cloud:Extensive experience is amustfor managing databases in Azure.
• Data Modeling:Expertise in creating complex and canonical data models.
• Database Management:Proficiency in SQL and NoSQL databases; expertise in writing and managing SQLs.
• ETL/ELT:Strong experience with frameworks and tools like Azure Data Factory, Informatica, Talend, or SSIS.
• Industry Knowledge:Experience with Enterprise Data Models for healthcare insurance or finance.
• Automation:Skills in creating data pipelines and scripting in Unix, PowerShell, or SQL.

Desired Skills & Experience:

• Advanced Analytics:Knowledge of AI/ML platforms (Snowflake AI, Google Vertex, Azure AI).
• BI Tools:Experience with Tableau, Power BI, or Looker.
• Compliance:Familiarity with SOC1/SOC2 audits and PHI, PII, and HIPAA data handling.
• Orchestration:Experience with Apache Airflow or Change Data Capture (CDC).

Pay:

$45.50 - $65.00 /hr.

We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to provide sponsorship at this time or accept candidates who would require a corp-to-corp agreement.

If this position sounds like you,WE SHOULD TALK!

Your better future is ready, and we want to put the right tools in your hands to get you there. Let's go!

Keywords:

Data Architect, Data Warehouse, Azure Cloud, Data Modeling, ETL, ELT, SQL, NoSQL, Azure Data Factory, Snowflake, Informatica, SSIS, Data Integration, Health Insurance

All offers of employment at Technology Partners are contingent upon clear results of a thorough background check and drug screening that meet corresponding laws and regulations at the city, state and federal level.

Pay ranges are influenced by candidate qualifications, experience, and role specifics, with the actual rate determined considering skills, market conditions, and are subject to change by the employer; pay negotiations follow all state and federal legal guidelines.