Infrastructure Specialist and Data Analyst

Range USA

United States

On-site

USD 90,000 - 120,000

Full time

11 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, Dental, and Vision health保险
Unlimited Shooting – Free Classes
Industry-leading online and in-store t
Discounts and rewards program

Job summary

Range USA is seeking an Infrastructure Specialist and Data Analyst to maintain and optimize our data and IT infrastructure across retail and corporate environments. You will work across cloud services, ERP/payroll, and POS systems to ensure performance, security, and thorough documentation.

This role blends data analysis with infrastructure operations, requiring SQL, AWS, ERP familiarity, and strong communication to translate technical concepts for stakeholders.

Qualifications

  • 2–4 years IT infrastructure experience.
  • Proficiency in SQL with one major RDBMS.
  • Hands-on AWS experience (EC2, RDS, S3, IAM, VPC, CloudWatch).
  • Acumatica ERP experience is a plus.
  • Familiarity with BI tools such as Power BI or SSRS is a plus.
  • Strong analytical and troubleshooting skills.
  • Excellent written and verbal communication skills.
  • Experience documenting runbooks, data models, and diagrams.
  • Scripting with Python or PowerShell.
  • Willingness to grow into broader infrastructure responsibilities.

Responsibilities

  • Write complex SQL queries and ETL processes to aggregate, clean, and transform data across source systems.
  • Identify and resolve data quality issues at the source system level.
  • Document data models, report definitions, data lineage, and runbooks.
  • Develop and maintain stored procedures, views, and scheduled jobs; perform backups and disaster recovery tests.
  • Provide technical support for POS systems across locations, including hardware and software.
  • Analyze POS transaction data to identify anomalies and surface insights.
  • Support ERP configuration changes, upgrades, and patch deployments; liaise with vendors.
  • Build and maintain ERP reports, dashboards, and data extracts.

Skills

SQL proficiency
AWS familiarity
Analytical thinking
Communication skills
Documentation

Tools

AWS (EC2, RDS, S3)
Acumatica ERP
Power BI/SSRS
Python/PowerShell

Job description

Infrastructure Specialist and Data Analyst

Range USA is the nations largest operator of indoor shooting ranges — a friendly and safe place to shop, shoot, and learn. Were committed to making every visit easy, welcoming, and memorable, and we believe every member of our team plays a direct role in that. Were growing nationwide, and we want the right people with us. At Range USA, your work has real impact.

Position details
Position title

Infrastructure Specialist and Data Analyst

Reports to

IT Infrastructure Manager

Classification

Full-Time / Exempt / Salaried / On-Site

Position overview

The IT Infrastructure Specialist & Data Analyst is a cross-functional technical role responsible for maintaining, supporting, and optimizing the systems and data infrastructure that power day-to-day operations across Range USA's retail and corporate environments. This individual serves as a critical link between IT infrastructure operations and data-driven business intelligence, ensuring that enterprise platforms—including cloud infrastructure, ERP/payroll systems, and point-of-sale solutions—remain performant, secure, and well-documented.

Core values alignment:
  • Curious — ask questions, find and solve problems
  • Passionate — care deeply about the brand, team, and customers
  • Do it Right — take pride in accuracy and credibility
  • Service — put others above ourselves
Key responsibilities
  • Write complex SQL queries and ETL processes to aggregate, clean, and transform data from multiple source systems, and support data migrations and integrations between internal and third-party systems.
  • Identify and resolve data quality issues at the source system level, and support ad hoc data requests from operations, finance, HR, and executive stakeholders.
  • Document data models, report definitions, data lineage, schema diagrams, data dictionaries, and change logs to ensure long-term maintainability.
  • Develop and maintain stored procedures, views, and scheduled jobs; perform regular database backups, test restores, and maintain disaster recovery runbooks.
  • Provide technical support for POS systems across retail locations, including hardware, software, and integration troubleshooting, and maintain network diagrams, device inventories, and store-level support procedures.
  • Analyze POS transaction data to identify anomalies, support audit requests, and surface operational insights.
  • Support ERP configuration changes, upgrades, and patch deployments, serving as technical liaison with ERP and payroll vendors on issue escalation and enhancement requests.
  • Build and maintain ERP reports, dashboards, and data extracts, and document ERP workflows, data flows, integration points, and runbooks for common issues.
  • Administer AWS infrastructure (EC2, RDS, S3, VPC, IAM, Route 53, CloudWatch), monitor resource health and costs, respond to alerts, and document architecture, access policies, and security groups.
  • Support CI/CD pipelines, infrastructure-as-code, and cloud backup/recovery, and assist with cloud migrations and evaluation of new AWS services.
  • Analyze current business processes, recommend system or workflow improvements, and gather requirements and document specifications for system changes.
Desired skills & experience
  • 2–4 years of experience in IT infrastructure, systems administration, or a related technical role.
  • Proficiency in SQL (T-SQL or ANSI SQL) with hands-on experience in at least one major RDBMS (SQL Server or MySQL).
  • Hands-on experience with AWS services, including EC2, RDS, S3, IAM, VPC, and CloudWatch.
  • Acumatica ERP experience is a plus.
  • Familiarity with BI tools such as Power BI or SSRS is a plus.
  • Strong analytical and troubleshooting skills with the ability to diagnose complex cross-system issues.
  • Excellent written and verbal communication skills; ability to translate technical concepts for non-technical stakeholders.
  • Experience in maintaining technical documentation, runbooks, and system diagrams.
  • Scripting experience with Python or PowerShell for automation and data processing.
  • Experience analyzing business processes or documenting system requirements.
  • Willingness to grow into broader infrastructure and architecture responsibilities.
Employee benefits
  • Medical, Dental, and Vision health insurance
  • Unlimited Shooting – Free Classes
  • Industry-leading online and in-store discounts
  • Manufacturer rewards and points program
  • No firearm experience needed — we offer paid training
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Infrastructure Specialist and Data Analyst
Infrastructure Specialist and Data Analyst

Range USA • Blue Ash (OH)

On-site
USD 70,000 - 110,000
Medical, Dental, and Vision health ins
Unlimited Shooting – Free Classes
Industry-leading discounts
+2
Store Operations Specialist
Store Operations Specialist

Range USA • Lenexa (KS)

On-site
USD 28,000 - 42,000
Medical insurance
Dental insurance
Vision insurance
+2
Operations Specialist
Operations Specialist

Range USA • Pittsburgh

On-site
USD 17,000 - 24,000
Medical, Dental, and Vision health ins
Unlimited Shooting – Free Classes
Industry-leading online and in-store  
+2
Operations Specialist
Operations Specialist

University of Illinois Community Credit Union • Greenwood (IN)

On-site
USD 17,000 - 24,000
Health insurance
Free shooting classes
Discounts on store products
+2
Store Operations Specialist
Store Operations Specialist

Range USA • Loveland (OH)

On-site
USD 35,000 - 45,000
Medical, Dental, and Vision insurance
Unlimited Shooting - Free Classes
Online and in-store discounts
+1
Operations Specialist
Operations Specialist

Range USA • Newtown (OH)

On-site
USD 17,000 - 24,000
Health insurance
Free classes (Unlimited Shooting)
Discounts on store purchases
+2
Senior Sales Associate
Senior Sales Associate

Range USA • Milwaukee (WI)

On-site
USD 21,000 - 28,000
Health insurance
Free shooting classes
Discounts
+2
Sr. PHP Web Developer
Sr. PHP Web Developer

Range USA • Cincinnati (OH)

On-site
USD 110,000 - 150,000
Medical, Dental, and Vision health ins
Unlimited Shooting – Free Classes
Discounts – online and in-store
+2
Junior Project Manager
Junior Project Manager

Range USA • Blue Ash (OH)

On-site
USD 50,000 - 70,000
Medical, Dental, and Vision health ins
Unlimited Shooting – Free Classes
Discounts
+1
Senior Sales Associate
Senior Sales Associate

Range USA • Merrillville (IN)

On-site
USD 19,000 - 25,000
Medical, Dental, and Vision health not
Unlimited Shooting – Free Classes
Industry-leading online and in-store</
+2