Data Modeler

Cliff Services Inc • weehawken, nj, us • 3m ago

Position: Data Modeler/Architect with Azure

Location: Minneapolis, MN

Duration: Long Term

Our Challenge:

We are looking for a talented and experienced Data Architect to join our dynamic team and help us design and implement complex data models, lead our data analytics initiatives, and provide data architecture support to our clients. The ideal candidate will have a strong understanding of data modeling principles and techniques, create and maintain complex data models, including conceptual, logical, and physical data models, to support various business processes and applications, extensive experience in designing and implementing data models that support our large-scale, complex datawarehouses and data lakes. You will work closely with data engineers, analysts, and stakeholders to ensure that our data architecture is robust, scalable, and aligned with our business needs. A strong SQL skill with Azure knowledge is a definite plus and experience in Banking KYC is advantageous but not essential.

Responsibilities:

• Data Model Design: Design, develop, and maintain complex data models for large data warehouses and data lakes, ensuring they meet business needs and support data-driven decision-making.

• Data Architecture: Develop and document data architecture, including data flow diagrams, entity-relationship diagrams, and data dictionaries, to support comprehensive and efficient data management.

• SQL Development: Write, optimize, and troubleshoot SQL queries and scripts to support data extraction, transformation, and loading (ETL) processes.

• Collaboration: Work closely with data engineers, analysts, and business stakeholders to understand requirements and translate them into effective data models and solutions.

• Performance Tuning: Analyze and optimize data model performance, addressing any issues related to data processing, retrieval, and query execution.

• Quality Assurance: Conduct data quality assessments and ensure data models adhere to data governance and quality standards.

• Technology Integration: Utilize Azure technologies and services (such as Azure Data Factory, Azure Synapse, or Azure SQL) where applicable to enhance data integration and processing.

• KYC Domain Knowledge: Apply knowledge of Banking KYC requirements to ensure data models support compliance and regulatory needs (preferred but not required).

• Best Practices: Stay current with industry best practices, emerging technologies, and methodologies in data modeling and apply them to improve data architecture and practices.

• Bachelor’s degree in Computer Science, Information Systems, or related field.

• Proven experience as a Data Modeler/Architect with strong proficiency in SQL and database design.

• Proven experience as a Data Modeler with expertise in data modeling and database design.

• Proficiency in data modeling tools such as ERwin, ER/Studio, or similar.

• Strong understanding of relational databases, SQL, and database management systems.

• Proficiency in data modeling tools and techniques.

• Strong understanding of data governance, data quality, and data security principles.

• Experience with Azure technologies (e.g., Azure Data Factory, Azure Synapse, Azure SQL) is preferred.

• Experience or familiarity with the Banking KYC domain is preferred but not required.

• Strong analytical and problem-solving skills, with the ability to translate complex business requirements into effective data models.

• Excellent communication skills, with the ability to convey technical concepts to both technical and non-technical stakeholders.

• Relevant certifications in SQL and Azure are a plus.