Infrastructure Specialist and Data Analyst

Range USA

Blue Ash (OH)

On-site

USD 70,000 - 110,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 ins
Unlimited Shooting – Free Classes
Industry-leading discounts
Manufacturer rewards and points
Paid training

Job summary

Range USA, the nation’s largest operator of indoor shooting ranges, is seeking an IT Infrastructure Specialist & Data Analyst in Blue Ash, OH. This role links IT infrastructure operations with data analytics, ensuring cloud platforms, ERP/payroll, and POS systems are performant, secure, and well-documented.

The successful candidate will manage SQL-based data pipelines, maintain ERP reports, and support BI initiatives while collaborating with operations, finance, and HR.

Qualifications

  • 2–4 years of IT infrastructure or systems administration.
  • Proficiency in SQL (T-SQL or ANSI SQL) with hands-on experience in at least one major RDBMS.
  • 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 written and verbal communication skills; ability to translate technical concepts for non-technical stakeholders.
  • Experience in maintaining technical documentation, runbooks, and system diagrams.

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.

Skills

SQL proficiency
AWS knowledge
BI tools
Scripting (Python)
Documentation

Tools

Acumatica ERP
Power BI
SSRS
AWS cloud

Job description

Job Details: Job Location: Support Center (Blue Ash, OH) - BLUE ASH, OH 45242, Infrastructure Specialist and Data Analyst

Range USA is the nation’s largest operator of indoor shooting ranges — a friendly and safe place to shop, shoot, and learn. We’re committed to making every visit easy, welcoming, and memorable, and we believe every member of our team plays a direct role in that. We’re 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 • United States

On-site
USD 90,000 - 120,000
Medical, Dental, and Vision health保险
Unlimited Shooting – Free Classes
Industry-leading online and in-store t
+1
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
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
Store Operations Specialist
Store Operations Specialist

Range USA • Lenexa (KS)

On-site
USD 28,000 - 42,000
Medical insurance
Dental insurance
Vision insurance
+2
Sr. PHP Web Developer
Sr. PHP Web Developer

Range USA • Blue Ash (OH)

On-site
USD 95,000 - 130,000
Medical, Dental, and Vision insurance
Unlimited Shooting - Free Classes
Industry-leading online and in-store ?
+2
Infrastructure & Data Analyst – AWS, SQL, ERP & POS
Infrastructure & Data Analyst – AWS, SQL, ERP & POS

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 • 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

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
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
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