Infrastructure Specialist and Data Analyst

Range USA•Blue Ash, OH

4d•Onsite

About The Position

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. The role connects IT infrastructure operations with data-driven business intelligence and helps ensure enterprise platforms—including cloud infrastructure, ERP/payroll systems, and point-of-sale solutions—remain performant, secure, and well-documented. The position is based on-site at the Support Center in Blue Ash, Ohio, and reports to the IT Infrastructure Manager. It is classified as full-time, exempt, and salaried. The role aligns with Range USA’s values of curiosity, passion, doing things right, and service.

Requirements

2–4 years of experience in IT infrastructure, systems administration, or a related technical role.
Proficiency in SQL (T-SQL or ANSI SQL) and hands-on experience with at least one major RDBMS, such as SQL Server or MySQL.
Hands-on experience with AWS services, including EC2, RDS, S3, IAM, VPC, and CloudWatch.
Strong analytical and troubleshooting skills, including the ability to diagnose complex cross-system issues.
Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders.
Experience 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.

Nice To Haves

Acumatica ERP experience.
Familiarity with BI tools such as Power BI or SSRS.

Responsibilities

Write complex SQL queries and ETL processes to aggregate, clean, and transform data from multiple source systems.
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.
Develop and maintain stored procedures, views, and scheduled jobs; perform database backups, test restores, and maintain disaster recovery runbooks.
Provide technical support for POS systems across retail locations, troubleshooting hardware, software, and integrations.
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, and act as a technical liaison with ERP and payroll vendors for issue escalation and enhancement requests.
Build and maintain ERP reports, dashboards, and data extracts; document ERP workflows, data flows, integration points, and runbooks for common issues.
Administer AWS infrastructure, 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 and recovery; assist with cloud migrations and evaluation of new AWS services.
Analyze business processes, recommend system or workflow improvements, and gather requirements and document specifications for system changes.