What are the responsibilities and job description for the Data Modeler position at Popular Community Bank?
The Opportunity
Data Modeler is an integral role within the Enterprise Data & Analytics function of Popular, responsible for designing and maintaining data models that support the firm's data management and analytics objectives. This role involves actively working with data architects, data analysts, and business units to create data models that ensure data integrity, accuracy, and compliance with financial regulations. The Data Modeler plays an essential role in translating complex financial data into structured formats that can be used for analysis, reporting, and decision-making.
Your key responsibilities:
You will be part of diverse teams of professionals across different geographies to deliver a wide range of data and analytics services. You will be solving complex issues and driving growth across the Enterprise Data & Analytics function.
Specifically:
- Design and develop data models that effectively support the financial firm's data management, analytics, and reporting goals
- Collaborate with data architects, data analysts, and business units to understand data requirements and translate them into data models
- Perform rigorous data analysis to understand the data nuances and apply learnings to data models and data designs
- Work with the business team to design conceptual and logical data models, data flows, data designs and source-to-target data mapping.
- Collaborate with Business teams and Data Stewards to determine and manage data cleaning requirements, data security needs and implement security solutions as part of the data designs.
- Develop data model designs iteratively in an agile fashion incorporating collaboration, iteration, feedback, and continuous improvement throughout the data modeling lifecycle.
- Ensure that data models comply with financial regulations, data governance policies, and industry standards
- Validate data models for data integrity, accuracy, and consistency
- Assist in the selection and implementation of data modeling tools and methodologies
- Assist in defining and implementing data standards for systems and applications including data object naming conventions, data standardization, data integrity, and data usage.
- Work closely with the Data Modeling Lead to align data models with the overall data strategy of the company
- Facilitate integration of data models into data warehousing, reporting, and analytics solutions
- Assist in defining data dictionary and business glossary to ensure consistent terminology and information across the organization.
- Collaborate with data governance teams and data stewards to document data models including data dictionaries, data lineage, and metadata
- Provide input to data governance teams to ensure that data models align with data governance policies and standards
- Bachelor’s or master’s degree in information management, Computer Science, Data Science, or a related field.
- 7 years of experience in data modeling with strong understanding of data architecture and data governance principles and practices.
- Strong experience in data warehousing, BI & Analytics and designing data products.
- Extensive experience in designing domain-based data models.
- 7 years of experience in data modeling practices including conceptual, logical, physical modeling in varied data modeling patterns such as 3NF, Data Vault 2.0 and dimensional modeling, with the ability to apply these skills at both project and enterprise levels.
- Solid experience in dimensional modeling with a proven track record of designing conformed dimensions that are applicable across various Business Units.
- Solid experience in data modeling tools such as Erwin, PowerDesigner, IBM Data Architect, or Oracle Designer.
- Strong Financial and Insurance industry domain knowledge.
- Experience in data governance and data management and using tools such as Alation, Collibra, Informatica, Atlan, IBM IGC.
- Strong experience working in data lake, data lake house, data warehouse, data mesh, and operational data stores.
- Experience designing models to be leveraged for data as a product and data marketplace.
- Proficiency in developing data designs, data mapping and data flow logic to support the implementation of data structures designed.
- Strong experience in data governance and data management.
- Experience in a metadata field of work (ontology, taxonomy, or semantics).
- Knowledge of W3C standards including linked and canonical data and ontologies (JSON, XML, RDF, RDFS, OWL, and SKOS).
- High proficiency in data analysis and profiling using SQL and Python.
- Strong experience with cloud platforms such as AWS, Azure, GCP and analytical data stores: Data Lake, Snowflake, Redshift, Hadoop.
- High proficiency in relational databases and data structures, including structured and unstructured data formats.
- Experience with working with data integration tools such as Informatica, Talend, CloverDX, DBT.
- Proficiency in reporting tools such as Tableau and PowerBI.
- Experience in technology assessment and proven ability to make recommendations to senior members of the team.
- Understanding of data privacy laws and regulations including knowledge on FCRA, CRA, GLBA, Data Privacy rules in addition to CCPA and GDPR.
- Experience collaborating with IT, Data Analytics, and Business teams, contributing to cross-functional projects and initiatives.
- Proficiency in Agile-based development methodologies, including Scrum and Kanban for collaborating, developing, and delivering data products.
- Excellent communication, collaboration, and problem-solving skills.
- Strong analytical and time management skills.
What we look for:
We are seeking enthusiastic and proactive leaders who have a clear vision and an unwavering commitment to remain at the forefront of data technology and science. Our ideal candidates are those who aim to foster a team spirit and collaboration and have a knack for adept management. It is essential that you showcase comprehensive technical proficiency and possess a rich understanding of the industry.
If you have a genuine drive for helping Popular achieve the full potential of their data while working towards your own development, this role is for you!