Job Description
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
Job Tags