Data Analyst - Data Modeling (Data Warehousing)

NISC•Lake Saint Louis, MO

47d•Hybrid

About The Position

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.

Requirements

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 Haves

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.

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.

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.