IT Data Modeler (Hybrid)
Eversource
- Westwood, MA
- Permanent
- Full-time
- Design, create, and implement logical and physical data models for both IT and business solutions to capture the structure, relationships, and constraints of relevant datasets.
- Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions.
- Effectively collaborate and communicate with various stakeholders to understand data and business requirements and translate them into data models.
- Create entity-relationship diagrams (ERDs), data flow diagrams, and other visualization tools to represent data models.
- Collaborate with database administrators and software engineers to implement and maintain data models in databases, data warehouses, data lakes, and data flows.
- Define and govern data modeling and design standards, tools, best practices, and use these standards to identify and resolve data modeling issues and conflicts.
- Conduct performance tuning and optimization of data models for efficient data access and retrieval.
- Identify the architecture, infrastructure, and interfaces to data sources, analytic models, and data visualization.
- Incorporate core data management competencies, including data governance, data security and data quality.
- Evaluate data models for variances, discrepancies to improve efficiency and aligning with standards.
- Review existing source systems or database to reverse engineer into data models.
- Expert knowledge of data modeling concepts, methodologies, and best practices.
- Proficiency in data modeling tools such as Erwin or ER/Studio.
- Knowledge of relational databases and database design principles.
- Experience with data warehouse, data lake, and enterprise data platforms in Cloud technologies is preferred.
- Experience in data querying, manipulation, and optimization, and knowledge of other data science languages, including JavaScript, Python, or R is desired.
- Ability to collaborate with cross-functional teams and stakeholders to gather requirements and align on data models.
- Excellent analytical and problem-solving skills to identify and resolve data modeling issues.
- Strong communication and documentation skills to effectively convey complex data modeling concepts to technical and business stakeholders.
- Work proactively to address project requirements and articulate issues/challenges to reduce project delivery risks.
- At least three years of experience in data modeling, database design, or related field
- Hands-on relational, dimensional, and analytical project experience using RDBMS, data platform technologies, ETL and data ingestion protocols.
- Must be available to work emergency restoration assignment as required.
- Must be available to travel between MA/CT/NH as necessary.
- Know the business plan and how your role connects to it
- Identify problems, issues; take responsibility for resolution
- Set high standards for self; deliver quality performance
- Raise ideas for improvement
- Communicate, communicate, communicate
- Follow through on commitments made to manager, colleagues, and customers.
- Address difficult or controversial issues and encourage others to do the same.
- Have honest dialogue with others
- Set performance goals that align with department and company goals
- Meet regularly with your supervisor/manager to discuss your performance
- Seek opportunities to develop skills and gain knowledge through on the job opportunities, i.e. working on projects, attending meetings, etc.
- Work collaboratively within and across the organization to achieve “One Company” and other goals
- Recognize and address cross functional implications of your work
- Incorporate the diverse ideas and perspectives of team, colleagues, and customers in your work
- Proactively seek out opportunities to improve business performance and customer service.
- Respond positively to new demands or circumstances
- Exhibit a “can-do” attitude to support changes in priorities and work processes
- Deliver superior service to our customers, both internal and external, in a reliable, attentive, courteous, quality, proactive and timely manner