NISC is hiring: Data Analyst - Data Modeling (Data Warehousing) in Bismarck

Data Analyst - Data Modeling (Data Warehousing)

Company Overview: For more than 50 years, NISC has developed and implemented enterprise-level and customer-facing software solutions for over 960+ utilities and broadband providers across North America. Our mission is to deliver technology solutions and services that are Member‑focused, quality driven and valued 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 ComputerWorld’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 who receive power, internet, television and/or telephone services, and our enterprise software solution enables them to compete effectively while excelling in customer service.

Position Overview: We are seeking an experienced Data Analyst to join our growing team of data analytics experts. The hire will design, curate, communicate and optimize our data models and data architecture for reporting and analytics use cases. The Data Analyst will support application experts, software developers, database architects and data engineers in building functional data assets and products to meet end‑user and application requirements. The role requires comfort supporting the data needs of multiple teams, systems and products, learning quickly, helping others, and contributing to common goals in both small teams and broader group environments. The ideal candidate is excited by the prospect of optimizing or redesigning the company’s data architecture and enjoys the challenge with a sense of fun.

Primary Responsibilities

• Work with stakeholders including Executive, Product, Data and Design teams to understand the value drivers related to data requirements from the business and end‑user perspective.
• Design and create data models that meet specific short and long‑term business needs in an agile, 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.
• Collaborate with other data professionals to enhance 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.
• Perform some data governance responsibilities (maintain data catalogs and data definitions, define data quality rules, etc.).
• Engage closely with the Product Owner and stakeholders to understand, document and define the specific data and business logic required to achieve product objectives.
• 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.
• Create visualizations to communicate insights from data analysis.
• Leverage 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 aligned with NISC’s Statement of Shared Values.
• Commitment to NISC’s Statement of Shared Values.
• Other duties as assigned.

Desired Experience and Skills

• 5+ years of experience in a data analyst or database/data engineer related position.
• Experience analyzing data requirements from business users and application experts across functional areas.
• Proficiency in data languages (SQL, Python, etc.) to analyze, model, structure, extract and gain insight from varied sources.
• Ability to create and utilize an array of visualization tools and techniques to properly show and communicate data concepts to end users.
• Experience performing root‑cause analysis on internal and external data and processes to answer specific business questions and identify improvement opportunities.
• Strong analytic skills with unstructured datasets.
• BS or MS degree in Data Analysis, Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
• Experience with cloud analytics environments (Azure, AWS, GCP, etc.).
• Experience querying and analyzing data from relational SQL and NoSQL databases (Oracle, PostgreSQL, Cassandra, DynamoDB).
• Experience with Databricks and Delta Lake.
• Nice‑to‑have: Experience with Python, SQL, R, DAX and similar technologies.
• Strong verbal and written communication skills.
• Ability to remain composed and think analytically under high‑pressure situations.

Work Schedule

• Hybrid from one of our office locations:
• Cedar Rapids, IA
• Lake Saint Louis, MO
• Mandan, ND
• Hybrid schedule: Minimum of 3 days per week from an office location, with flexibility to work up to all 5 days from an office.
• Required days from an office location: Tuesday and Wednesday, with the third required day chosen by the candidate and supervisor.

NISC's Shared Values & Competencies

• Integrity – We are committed to doing the right thing – always.
• Relationships – We are committed to building and preserving lasting relationships.
• Innovation – We promote the spirit of creativity and champion new ideas.
• Teamwork – We exemplify the cooperative spirit by working together.
• Empowerment – We believe individuals have the power to make a difference.
• Personal Development – We believe the free exchange of knowledge and information is absolutely necessary to the success of each individual and the organization.

Benefits

• Medical, Dental and Vision Insurance.
• Health Savings Account (HSA) with $100 monthly contributions from NISC. [Additional $800 can be earned annually through the Wellness Rewards program.]
• Dependent Care Flexible Spending Account (FSA) via Paylocity.
• Fully covered life insurance up to 3x annual base salary.
• Fully covered short‑ and long‑term disability.
• 401(k), traditional or Roth, with employee match up to 6% and employer 4% salary base contributions.
• PTO accrual levels depend on years of service, 120 Life Leave Event hours, and 9 paid holidays.
• $2,500 interest‑free technology loan program.
• $25,000 employee educational assistance program.
• Volunteer, wellness, family events and other employee fun supplied by our committees.
• Employee Assistance Program for virtually any life event.
• Benevolence Committee to support employees with financial hardships.

Education Preferred

• Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems or similar discipline.

Minimum Physical Requirements

The physical demands described here represent those that must be met to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the essential functions of this position, employees must be able to see, communicate, maintain a stationary position, move, and operate computer keyboards or office equipment.

Disclaimer: Management may modify this job description by assigning or reassigning duties and responsibilities at any time.

Key Words

• SQL
• Data
• Analyst
• Big Data
• Databricks
• ETL
• BI
• DBA
• Data Modelling
• Data Curation
• Data Product
• Data Governance
• Data Quality

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

• Information Technology
• Software Development