Infrastructure Specialist and Data Analyst

Job Details: Job Location: Support Center (Blue Ash, OH) - BLUE ASH, OH, Salary Range: Undisclosed, 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 Qualifications: