Senior Data Architect/Modeler

The Data Modeler III is a hands-on technical role focused on full-stack software development within the Enterprise Data organization. This role plays a crucial part in shaping future big data and analytics initiatives.

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

QUALIFICATIONS:

• 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).
• Experience integrating Business Intelligence tools such as Qlik Sense, Tableau, or Power BI.
• Experience with Machine Learning and Artificial Intelligence.
• 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.

MINIMUM QUALIFICATIONS:

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

Please submit your resume to sgupta@hirerising.com