Data Architect

Aptonet; Chesterfield (MO); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Aptonet is seeking a Data Architect in a hybrid Chesterfield, MO setting for a 12-month term with right-to-hire. The role involves designing, deploying, and managing information management architectures and technologies, aligning with business and IT stakeholders.

You will build knowledge of source/target systems, model data, design BI solutions, and ensure security and performance across the data stack. Immediate start preferred.

Qualifications

• Bachelor's degree or equivalent education/experience.
• 10+ years in information management, data warehouse, or related fields.
• 5+ years in database, data modeling, transformation, and analysis.
• Experience as Information Architect, Lead Data Engineer, or Data Warehouse Architect.
• Proven track record designing Data Hubs or Operational Data Stores.
• Able to learn quickly and lead small teams on projects.
• Strong problem solving and communication skills.
• Experience with analytical DBs and BI/tools.

Responsibilities

• Collaborate with business and IT stakeholders to define requirements and standards for information modeling and management.
• Create an inventory of information assets and design data flows across platforms.
• Oversee design, security, compliance, reliability, and performance of solution architecture.
• Design complex data models, capacity planning, and system implementations.
• Develop and maintain BI solutions and analytics capabilities.
• Document standards, processes, and procedures for architecture governance.
• Work in an Agile environment, set milestones, and manage risks.
• Mentor junior colleagues and share expertise on data architectures.
• Analyze source application databases and apply data profiling techniques.
• Support continuous improvement and information security initiatives.

Skills

Data architecture

Data warehousing

Data modeling

BI tools

SQL & ETL

Education

Bachelor's degree or equivalent

Tools

Vertica

Snowflake

Tableau

Power BI

Informatica PowerCenter

Talend

Azure DevOps

Job description

We are seeking a Data Architect to join a multi-disciplinary team, designing, deploying, and managing information management solution architecture and associated technologies. This is a hybrid contract-to-hire role based in Chesterfield, MO, for an initial 12-month term with right-to-hire after six months. Our client is looking to start ASAP.

About the role

The Data Architect works closely with business and IT stakeholders to develop requirements and standards for how information is modeled, stored, integrated, consumed, and managed across the organization. This role proactively builds knowledge of source and target systems and technologies to deliver structured information and analytical solutions.

Responsibilities

• Work closely with business and IT stakeholders to optimize information assets by defining business requirements and delivering appropriately structured information and analytical solutions
• Build an inventory of information assets needed for solution architecture and create a vision for how information will flow through the organization, leveraging existing platforms and processes where applicable
• Be responsible for the design, security, compliance, reliability, and performance of the solution architecture
• Design complex data models, develop capacity planning, and implement systems
• Design, develop, and maintain business intelligence solutions
• Produce and enforce standards, processes, and procedures for the solution architecture
• Work in an agile environment, continuously reviewing business needs, refining priorities, outlining milestones and deliverables, and identifying opportunities and risks
• Seek continuous performance improvement and ensure the security of information
• Act as a resource and mentor colleagues with less experience
• Build an understanding of source application databases by analyzing data models and leveraging data profiling techniques
• Perform other duties as assigned

Requirements

• Bachelor's degree or equivalent education/experience
• 10+ years of information management, data warehouse, or other relevant experience
• 5+ years of database, data modeling, data transformation, and data analysis experience
• Prior experience as an Information Architect, Lead Data Engineer, or Data Warehouse Architect
• Proven history of designing and building Data Hubs or Operational Data Stores to collect and facilitate access to data assets
• Demonstrated ability to quickly learn new technologies and to lead small teams and projects
• Advanced ability to solve complex problems, drawing on creativity, experience, and multiple sources of information
• Advanced interpersonal skills, including the ability to build consensus and influence decisions
• Advanced communication skills, including the ability to convey complex information in a straightforward manner
• Technical experience with analytical databases (Vertica, Snowflake, etc.), analytical tools (Tableau, Power BI, etc.), and data transformation tools (Informatica PowerCenter, Talend, etc.)

Nice to have

• Experience with iterative development methodologies
• Experience working with global teams in global organizations
• Insurance and/or reinsurance industry knowledge or certification
• Data matching and entity resolution packaged software
• Experience with cloud and on-premise solutions
• Azure DevOps or Team Foundation Server (TFS)