Data Analyst - Data Modeling; Data Warehousing

Data Analyst - Data Modeling (Data Warehousing)

Join to apply for the Data Analyst - Data Modeling (Data Warehousing) role at NISC

For more than 50 years, NISC has developed and implemented enterprise‑level and customer‑facing software solutions for over 960+ utilities and broadband services across North America. Our mission is to deliver technology solutions and services that are Member‑focused, quality‑driven and value‑priced. We exist to serve our Members and help them serve their communities through innovative software products, services and outstanding customer support.

NISC has been ranked in Computer World’s Best Places to Work for twenty‑two years, and we are looking for qualified individuals to join our team.

Our Members have over 16 million end customers (residential and businesses that receive power, internet, television and/or telephone services) that our enterprise software solution enables our Members to compete effectively in the industry while excelling in customer service.

We are seeking an experienced Data Analyst to join our growing team of data analytics experts. The hire will be responsible for designing, curating, communicating and optimizing our data models and data architecture for reporting and analytics use cases. The Data Analyst will support our application experts, software developers, database architects, and data engineers in building out functional data assets and products to meet our end‑user and application requirements.

They must be comfortable supporting the data needs of multiple teams, systems, and products. We look for individuals who can learn quickly, help others and contribute to our common goals in both a small team and broader group environment and are excited by the prospect of optimizing or even re‑designing our company’s data architecture.

• Work with stakeholders including the Executive, Product, Data and Design teams to understand the value drivers related to data requirements from the business and end‑users’ perspective.
• Design and create data models that meet specific short and long‑term business needs in an agile and fast‑paced environment.
• Create and define data models that properly combine multiple data sources.
• Define data joins, aggregations, metrics and calculations.
• Data modelling and relationship creation – Data model diagrams, Star Schema/Snowflake Schema, relationship diagrams, metrics, measures, dimensions, etc.
• Work with other data professionals to strive for greater functionality while making data more discoverable, addressable, trustworthy, and secure.
• Collaborate on best practices and standards for data analysis at NISC.
• Serve as a subject‑matter expert for a specific business domain (e.g., Sales, Marketing, Broadband).
• Analyze and understand relationships between data fields and tables in the transactional and analytical layers.
• Mentor and enable other data analysts within the team.
• Work with data scientists to define more advanced data needs and analysis.
• Some data governance responsibilities may be part of this role (maintain data catalogs and data definitions, define data quality rules, etc.).
• Closely engage and interact with the product owner and stakeholders to understand, document and define the specific data and business logic required to achieve the product objective.
• Translate data and business requirements and work with data engineers and developers to determine technical requirements, including access and security requirements, frequency and latency requirements, compliance and PII requirements, Unity Catalog schema preferences, etc.
• Provide example queries and data examples for data engineers to reference.
• Test, validate and document deliverables.
• Build and maintain business‑relevant metrics, measures and views.
• Build visualizations for communicating insights from data analysis.
• Perform analysis leveraging BI and other analytical methodologies and tools.
• Update, maintain and manage business requirements and documents as required.
• Maintain constant communication and collaboration with the team.
• Create and maintain a culture of engagement and one that is conducive to NISC’s Statement…