Senior Data Analyst & Architect — Cloud DW/BI (Onsite OH)

Prudent Technologies and Consulting, Inc.; Raymond (OH); On-site; USD 96,000 - 165,000; Part time

Job summary

Prudent Technologies and Consulting, Inc. is seeking a senior data architect to lead data modeling and enterprise DW initiatives from Raymond, Ohio.

The role requires at least 10 years of experience designing data models (Erwin) for large-scale DW projects and guiding cross-functional teams. You will architect modern data systems using cloud services (AWS), real-time data streaming (Kinesis, Kafka, Dataflow) and industry-standard DW tools (Redshift, Snowflake, Databricks).

Qualifications

• Bachelor's degree in CS/Data Science/Engineering or related field.
• 10+ years in design/implementation of data models for enterprise DW initiatives.
• Experience leading projects with cloud data lakes, DW, data modeling and data analysis.
• Proficiency with modern data architectures including AWS, real-time data distribution.
• Experience with diverse DB platforms (DB2, MS SQL, PostgreSQL, Couchbase, MongoDB).
• Knowledge of ER modeling, metadata systems, data security and quality tools.

Responsibilities

• Lead data architecture and solution design for enterprise DW initiatives.
• Guide cross-functional teams including data scientists and business analysts.
• Oversee data modeling, data security, and metadata management.
• Evaluate and implement modern data architectures and cloud services.
• Drive BI integrations using Informatica, Power BI, and Tableau.

Skills

Data modeling

Erwin

Cloud data lakes

Data warehousing

BI tools

Communication

Cross-functional collaboration

Problem solving

Education

Bachelor's degree in Computer Science / Data Science / Engineering

Tools

Erwin

AWS

Kinesis

Kafka

Dataflow

Redshift

Snowflake

Databricks

DB2

MS SQL Server

PostgreSQL

Couchbase

MongoDB

Power BI

Tableau

Job description

Prudent Technologies and Consulting, Inc. is seeking a senior data architect to lead data modeling and enterprise DW initiatives from Raymond, Ohio.

The role requires at least 10 years of experience designing data models (Erwin) for large-scale DW projects and guiding cross-functional teams. You will architect modern data systems using cloud services (AWS), real-time data streaming (Kinesis, Kafka, Dataflow) and industry-standard DW tools (Redshift, Snowflake, Databricks).