What are the responsibilities and job description for the Data Modeler position at Compunnel Inc.?
Candidate Profile
What are the top three MUST haves:
- SQL, must be expert level and will be asked to write complex code/queries
- Experience with ERD/Data Modelling tools (SAP Power Designer or Erwin).
- OLAP modeling experience in: (Erwin / Power Center)
- Analytical problem solver
Biggest NICE TO HAVE would be: Snowflake and AWS exp.
The Expertise Required
- Bachelor’s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structures, or data modeling.
- Proven track record of solving real world problems using data.
- Understanding of different database platforms (e.g. Oracle, MySQL) usages (OLTP Recordkeeping, ODS, MDM, Warehousing and Data Lakes).
- Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).
- Demonstrated experience in SQL.
- Experience with ERD/Data Modelling tools (SAP Power Designer or Erwin).
- Experience in executing projects in an Agile environment.
The Necessary Skills
- As an experienced analyst with outstanding interpersonal and communication skills who possess experience collaborating and influencing across all levels the organization.
- Excellent communication skills including written, verbal, and technology illustrations.
- The desire and aptitude for learning new technologies to solve problems and formulate recommendations.
- A proven track record of working in reciprocal teams to deliver high quality data solutions in an agile environment.
- A fearless approach to challenge the legacy design and seek opportunities to design better models and better code.
- A passion for data analysis with the ability to navigate and master complex transactional and warehouse databases.
- A love working with data and are confident in your SQL skills.
- Technically adept in learning new technologies and architectural methodologies and adapting our practices to support frequent changes in the technical environment.
- A strong interest in playing a technical data steward role and across our business and technology partners to understand and detail our data, appropriate data usages and helping FI derive the maximum value from its data.
- The ability to take a broad view of data from creation to consumption and understand how data design patterns affect data quality and the ability of users to easily consume data.
- Experience with cloud native data warehousing and data lake solutions using Snowflake is a plus.
- Exposure to working with a Data Scientist team and knowledge of Feature Engineering is a plus.
- Experience of database design through the full development lifecycle is a plus: from requirements to conceptual, logical and physical data model design and implementation.
