Contact Us 877.823.3669

Senior Data Analyst in Colorado Springs, CO at SNI Technology

Date Posted: 10/11/2019

Job Snapshot

Job Description


Our client is seeking a Senior Data Analyst for an exciting contract to hire scenario. As a critical member of the Data Services team, the Senior Data Analyst will be responsible for working closely with other DS team members and with our R&D team to recommend database structures, build complex integration pipelines, clean and analyze large datasets, and build visualizations, based on the data storage and retrieval needs. The SDA will also share responsibility for monitoring our SQL databases and immediately address issues and problems.

DUTIES:

  • Maintain multiple Microsoft SQL Server and Storage environments (On-Prem & Azure).
  • Create new development and production databases, catalogs, and repositories, to include general database maintenance.
  • Write complex SQL queries and create reporting visualizations (PowerBI) to support reporting and data analysis needs.
  • Create and analyze complex data sets, presenting findings to business leaders and external clients.
  • Tune and optimize SQL queries, functions, stored procedures, triggers, and dependent reports.
  • Support the Enterprise Business Integration pipeline by creating new and managing existing bi-directional data pipelines.
  • Collaborate with cross-department staff to automate business processes and workflows.
  • Provide Tier-3 technical support for internal incident and request cases escalated by junior team members.
  • Perform regular code reviews with junior team members, to include version control management.
  • Assist in DR mitigation by creating and managing automated backups and performing DR test scenarios.
  • Provide on-call support for critical outages and issues, as required.
  • All other duties as assigned.



REQUIREMENTS:

  • Bachelor's degree from an accredited college in a related discipline, or equivalent experience/combined education
  • 5+ years of MS SQL Server experience
  • 4+ years of MS PowerBI experience
  • Demonstrated DML/DDL/DCL/TCL experience
  • Experience with Azure Data and Warehousing Solutions
  • Experience presenting to Executives and high-level Stakeholders a plus
  • Experience with Azure Data Factories is a plus
  • In-depth knowledge of data transforms, retrieval, and visualizations