Data Modeler - AWS/Python (10-15 yrs)

Role : Data Modeler

Location : Boston, MA 02135 (Onsite)

Interview Mode : In Person (Final Round)

NOTE : Client looking for excellent data modeler here with 10+ Years of good experience in python, AWS, and good financial domain experience.

Position General Duties and Tasks :

- Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS,AWS Redshift Data Warehouse, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).

- Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices.

- The candidate must be able to work independently and collaboratively.

- Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).

- Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models

- Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.

- Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.

- Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.

- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.

- Understand business requirements and define entities, attributes, mapping, relationships, and integrity rules with the proper naming conventions/standards

- To assist business analysts and developers to understand and use data models that organize the data into tables and accounts for access.

Required Skills and Experience :

- 10+ years of experience in data modeling and database design.

- Strong understanding of data modeling methodologies (i.e., Kimball, Inmon).

- Proficiency in SQL and database design (relational and NoSQL).

- Experience with data warehousing and data lake architectures.

- Knowledge of data integration and ETL tools.

- Experience with cloud platforms (AWS, Azure, GCP) is a plus.

- Strong analytical and problem-solving skills.

- Excellent communication and interpersonal skills.

Preferred Skills :

- Experience with data modeling tools (i.e., Erwin Data Modeler, ERwin Data Intelligence).

- Knowledge of data visualization and reporting tools (i.e., Tableau, Power BI).

- Experience with data governance and data quality tools