Data Analyst - Data Modeling (Data Warehousing) at National Information Solutions Cooperative (NISC)

United States

Apply Now

Not SpecifiedCompensation

Mid-level (3 to 4 years)Experience Level

Full TimeJob Type

UnknownVisa

Utilities, Broadband, TechnologyIndustries

Requirements

Experienced in data analytics, particularly designing, curating, communicating, and optimizing data models and data architecture for reporting and analytics
Comfortable supporting data needs of multiple teams, systems, and products (e.g., application experts, software developers, database architects, data engineers)
Ability to learn quickly, collaborate in small teams and broader groups, and contribute to common goals
Excited about optimizing or re-designing company data architecture
Knowledge of data modeling techniques including Star Schema/Snowflake Schema, relationship diagrams, metrics, measures, dimensions, data joins, aggregations, and calculations
Ability to analyze relationships between data fields and tables in Transactional and Analytical layers
Serve as Subject Matter Expert for a specific business domain (e.g., Sales, Marketing, Broadband)
Familiarity with data governance (e.g., maintaining data catalogs, definitions, quality rules)
Skills in translating business requirements into technical requirements (e.g., access/security, frequency/latency, compliance/PII, Unity Catalog schema)
Proficiency in providing example queries, testing, validating, and documenting deliverables
Experience building visualizations, performing analysis with BI tools, and leveraging analytical methodologies

Responsibilities

Work with stakeholders (Executive, Product, Data, Design teams) to understand value drivers and data requirements from business and end users
Design and create data models meeting short- and long-term business needs in an agile environment
Create and define data models combining multiple data sources
Define data joins, aggregations, metrics, and calculations
Perform data modeling and relationship creation (e.g., diagrams, Star/Snowflake Schemas, metrics, measures, dimensions)
Collaborate with data professionals to improve functionality, discoverability, trustworthiness, and security of data
Collaborate on best practices and standards for Data Analysis
Serve as Subject Matter Expert for a specific business domain
Analyze relationships between data fields and tables in Transactional and Analytical layers
Mentor and enable other Data Analysts
Work with Data Scientists to define advanced data needs and analysis
Handle some Data Governance responsibilities (e.g., data catalogs, definitions, quality rules)
Engage with Product Owner and stakeholders to understand, document, and define data and business logic
Translate data/business requirements to technical requirements for Data Engineers and Developers
Provide example queries and data examples for Data Engineers
Test, validate, and document deliverables
Build and maintain business-relevant metrics, measures, views
Build visualizations for communicating insights
Perform analysis using BI and other analytical tools/methodologies
Update, maintain, and manage business requirements and documents

Skills

Key technologies and capabilities for this role

Data ModelingData WarehousingData ArchitectureSQLAnalyticsReportingStakeholder CollaborationDatabase Design

Questions & Answers

Common questions about this position

What are the primary responsibilities of this Data Analyst role?

The role involves designing and creating data models, defining joins, aggregations, metrics, and calculations, creating data model diagrams like Star Schema/Snowflake Schema, collaborating with stakeholders and data professionals, serving as a subject matter expert, mentoring other analysts, and working with data scientists.

What skills or experience are needed for this position?

Experience in data modeling, data architecture, Star Schema/Snowflake Schema, relationship diagrams, metrics, measures, dimensions, and analyzing relationships between data fields and tables in transactional and analytical layers is required, along with the ability to work in an agile environment and collaborate across teams.

Is this a remote position or does it require office work?

This information is not specified in the job description.

What is the salary or compensation for this role?

This information is not specified in the job description.

What kind of team environment can I expect at NISC?

The role involves working with a growing team of data analytics experts, supporting multiple teams like application experts, developers, architects, and engineers, collaborating in small team and broader group settings, mentoring others, and contributing to common goals with some fun along the way.

National Information Solutions Cooperative (NISC)

Software solutions for broadband and utilities

About National Information Solutions Cooperative (NISC)

National Information Solutions Cooperative (NISC) provides software solutions for the broadband and utility industries, helping clients like electric cooperatives and telecommunications companies improve customer engagement and service efficiency. Their products include tools for capital credit management, consumer analytics, and service provisioning, which assist clients in managing operations and providing detailed energy usage data to customers. NISC operates on a subscription-based model, offering ongoing support and updates, which ensures a steady revenue stream. The company's goal is to maximize client return on investment through exceptional customer support and tailored software solutions.

Lake Saint Louis, MissouriHeadquarters

2000Year Founded

VENTURE_UNKNOWNCompany Stage

Data & Analytics, Enterprise SoftwareIndustries

1,001-5,000Employees

Benefits

Hybrid Work Options

Risks

Emerging tech startups pose competition in the utility and broadband sectors.

Rapid technological advancements may strain NISC's resources for software updates.

Potential regulatory changes could necessitate costly adjustments to NISC's solutions.

Differentiation

NISC is a cooperative, owned by its Member-Owners, ensuring deep industry insight.

Over 11 million consumers use NISC's IT systems across multiple regions.

NISC offers a comprehensive suite of SaaS solutions tailored for utility and broadband industries.

Upsides

Increased demand for smart grid technology aligns with NISC's energy management solutions.

The rise of 5G technology benefits NISC's telecommunications clients.

NISC's DERMS program addresses the expansion of distributed energy resources.

Land your dream remote job 3x faster with AI

Try Jobo Free