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

, , -

Full Time

Start Date

Immediate

Expiry Date

17 Feb, 26

Salary

0.0

Posted On

19 Nov, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Analysis, Data Modeling, SQL, Python, Data Governance, Data Quality, Business Intelligence, Visualization Tools, Cloud Analytics, Root Cause Analysis, Unstructured Data, Data Architecture, Metrics, Data Catalogs, Collaboration, Mentoring

Industry

Software Development

Description

Company Overview: For more than 50 years, NISC has developed and implemented enterprise-level and customer-facing software solutions for over 960+ utilities and broadbands 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 our 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 (residential and businesses who 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. Position Overview: 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 and have some fun along the way. Primary Responsibilities: 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. (i.e. Sales, Marketing, Broadband, etc.) 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.). To 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, Views, etc. 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 of 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 working in data analyst or database/data engineer related position. Experience analyzing data requirements from business users and application experts for a variety of functional areas. Ability to leverage Data languages (SQL, Python, etc.) to analyze, model, structure, extract and gain insight from different sources and use cases. Able to create and utilize an array of visualization tools and techniques to properly show and communicate data concepts to end users and model possible insights Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Candidate with experience in a Data Analyst role, who has attained a BS or MS degree in Data Analysis, Computer Science, Statistics, Informatics, Information Systems, or another quantitative field. They should also have experience using the following software/tools: Experience with Cloud environments for Analytics (Azure, AWS, GCP, etc) Experience querying and analyzing data from relational SQL and NoSQL databases, including Oracle, Postgres Cassandra, and DynamoDb. Experience with Databricks and Delta Lake. Nice-to-have: Experience with data analysis tools and languages such as: Python, SQL, R, DAX, and similar technologies. Strong verbal and written communication skills. Ability to demonstrate composure and think analytically in 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 working 3 day per week out of an office location and ability to work up to all 5 days a week from an office location. Required Days from an Office Location: Tuesday and Wednesday - the third required day will be up to the candidate and their supervisor to choose NISC’s Shared Values & Competencies: We’re a cooperative, which means we’re owned by the Members we serve. It also means that our focus is on taking care of our Members and our employees, rather than having a big bottom line. Quality service and innovative technology starts with happy and dedicated employees. Join our team and learn for yourself what sets NISC apart. 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. Like to walk? Improve your overall wellness knowledge? Ability to earn up to $800 additional dollars into your HSA each year through our Wellness Rewards program. Dependent Care Flexible Spending Account (FSA) thru Paylocity. Fully covered life insurance up to x3 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 dependent 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; assisting employees and dependents with virtually any life event Benevolence Committee to support employees with financial hardships like unexpected medical bills, funerals and other unfortunate hardships. Education Preferred: Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, or similar discipline, preferred. Minimum Physical Requirements: The physical demands described here are representative of those that must be met by an employee 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 and communicate. Employees are regularly required to 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

Responsibilities

The Data Analyst will design, curate, communicate, and optimize data models and architecture for reporting and analytics. They will collaborate with various teams to understand data requirements and support the development of functional data assets.