Sr. Data Analyst // Data Modeler

Prudent Technologies and Consulting, Inc.; Raymond (OH); Presencial; USD 96 000 - 165 000; Tempo parcial

Resumo da oferta

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).

Qualificações

• 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.

Responsabilidades

• 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.

Conhecimentos

Data modeling

Erwin

Cloud data lakes

Data warehousing

BI tools

Communication

Cross-functional collaboration

Problem solving

Formação académica

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

Ferramentas

Erwin

AWS

Kinesis

Kafka

Dataflow

Redshift

Snowflake

Databricks

DB2

MS SQL Server

PostgreSQL

Couchbase

MongoDB

Power BI

Tableau

Descrição da oferta de emprego

Location: Raymond, Ohio - Onsite – at least 4 days a week

Duration: Long Term Contract

Key Requirement: Candidates must be authorized to work in the U.S. for any employer on a W-2 basis without requiring current or future visa sponsorship. Qualified candidates who meet these requirements are encouraged to apply.

WHAT'S NEEDED

• A bachelor's degree in Computer Science, Data Science, Engineering, or a related field.
• At least 10 years of relevant experience in the design and implementation of data models (Erwin) for enterprise data warehouse initiatives.
• Experience leading projects involving cloud data lakes, data warehousing, data modeling, and data analysis.
• Proficiency in the design and implementation of modern data architectures and concepts such as cloud services (AWS), real-time data distribution (Kinesis, Kafka, Dataflow), and modern data warehouse tools (Redshift, Snowflake, Databricks).
• Experience with various database platforms, including DB2, MS SQL Server, PostgreSQL, Couchbase, MongoDB, etc.
• Understanding of entity-relationship modeling, metadata systems, and data security, quality tools, and techniques.
• Ability to design traditional/relational and modern big-data architectures based on business needs.
• Experience with business intelligence tools and technologies such as Informatica, Power BI, and Tableau.
• Exceptional communication and presentation skills.
• Strong analytical and problem-solving skills.
• Ability to collaborate and excel in complex, cross-functional teams involving data scientists, business analysts, and stakeholders.
• Ability to guide solution design and architecture to meet business needs.