Apply on Employer Site

HireRising · 3 days ago

Senior Data Architect/Modeler

Phoenix, AZ

Full-time

Onsite

Senior Level

$150K/yr - $170K/yr

5+ years exp

HireRising is seeking a Senior Data Architect/Modeler for a hands-on technical role within their Enterprise Data organization. This position focuses on full-stack software development and plays a crucial part in shaping future big data and analytics initiatives.

RecruitingStaffing Agency

Hiring Manager

Surbhi Gupta

Responsibilities

Design and implement Medallion Architecture, dimensional models (Star/Snowflake schemas), and metadata-driven modeling approaches for enterprise data warehouses

Develop canonical and semantic data models with effective SCD techniques aligned with business requirements and analytical needs

Write and optimize advanced SQL queries in Snowflake (or similar platforms) to ensure efficient data processing and warehouse performance

Align data models with ELT/ETL pipelines and analytics frameworks to create scalable data structures that support business growth

Design and develop code and data pipelines to ingest data from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services

Implement streaming ingestion using Kinesis Streams, Kinesis Firehose, Kinesis Analytics, and Kafka (MSK)

Build Data Lakes on AWS S3 with optimal performance considerations, including partitioning and data compression

Perform data engineering and analytics using AWS Glue, Informatica, EMR, Spark, Athena, and Python

Model data and build enterprise data warehouses using Snowflake

Design and develop JavaScript modules and REST APIs utilizing MarkLogic to support complex searches

Develop MarkLogic integrations with existing enterprise platforms

Participate in requirements gathering, system architecture design, and data architecture design

Contribute to all phases of the software development lifecycle using Agile methodologies

Qualification

Data modeling toolsEnterprise Information ArchitectureAWS servicesAnalytics toolsMarkLogicIntegration architectureWeb developmentNoSQL databasesMachine LearningJSON data modelingXML data modelingGit/GitHubDatabase architectureBusiness Intelligence toolsSoft skills

Required

5+ years of experience with data modeling tools such as ERWIN, Lucidchart, or sqlDBM

7+ years of experience in Enterprise Information Solution Architecture, Design, and Development

7+ years of experience with integration architecture (SOA, Microservices, ETL, or related technologies)

7+ years of experience working with content/knowledge management systems, search engines, relational and NoSQL databases, ETL tools, geospatial systems, or semantic technology

5+ years of hands-on experience with MarkLogic; experience with DynamoDB preferred

5+ years of hands-on experience with AWS services (S3, Kinesis, Lambda, Athena, Glue, EMR)

5+ years of experience with analytics tools such as SAS, R, Python, or other advanced statistical software

5+ years of web development experience using Angular, JavaScript, and Node.js

Experience with JSON and XML data modeling (required)

Experience with Git/GitHub, branching strategies, and modern source code management practices (required)

Strong understanding of NoSQL and relational database concepts (required)

Knowledge of database architecture and performance optimization (required)

Bachelor's degree in Computer Science, Computer Information Systems, Engineering, Statistics, or a closely related field (or foreign equivalent) — required

Experience working with AWS data and analytics services — required

5 years of experience in data ingestion, extraction, and integration — required

Ability to multitask effectively and work collaboratively in an Agile team environment

Extensive knowledge of Python, JavaScript, and Java

Excellent written and verbal communication skills, with a strong sense of ownership, urgency, and drive