Infrastructure & Data Analyst – AWS, SQL, ERP & POS

Range USA

Blue Ash (OH)

Presencial

USD 70 000 - 110 000

Tempo integral

Há 11 dias

Recebe uma resposta deste empregador

O teu currículo e carta de apresentação, adaptados exatamente ao que estão a contratar.

Ultrapassa os filtros ATS

Vantagens oferecidas por esta oferta de emprego

Medical, Dental, and Vision health ins
Unlimited Shooting – Free Classes
Industry-leading discounts
Manufacturer rewards and points
Paid training

Resumo da oferta

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.

Qualificações

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

Responsabilidades

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

Conhecimentos

SQL proficiency
AWS knowledge
BI tools
Scripting (Python)
Documentation

Ferramentas

Acumatica ERP
Power BI
SSRS
AWS cloud

Descrição da oferta de emprego

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.

Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

Infrastructure Specialist and Data Analyst
Infrastructure Specialist and Data Analyst

Range USA • Blue Ash (OH)

Presencial
USD 70 000 - 110 000
Medical, Dental, and Vision health ins
Unlimited Shooting – Free Classes
Industry-leading discounts
+2
Infra & Data Analyst — AWS, SQL, POS Insights
Infra & Data Analyst — AWS, SQL, POS Insights

Range USA • EUA

Presencial
USD 90 000 - 120 000
Medical, Dental, and Vision health保险
Unlimited Shooting – Free Classes
Industry-leading online and in-store t
+1
ERP & BI Applications Specialist
ERP & BI Applications Specialist

United Performance Metals • Hamilton (OH)

Presencial
USD 70 000 - 100 000
Remote POS Analyst: Troubleshooting, Data Insight & Optimization
Remote POS Analyst: Troubleshooting, Data Insight & Optimization

Ringside Talent • Columbus (OH)

Teletrabalho
USD 60 000 - 90 000
IT Systems Analyst: ERP & Enterprise Apps (Cleveland)
IT Systems Analyst: ERP & Enterprise Apps (Cleveland)

Ohio Cat • Broadview Heights (OH)

Presencial
USD 90 000 - 120 000
401(k) match
Health insurance
Educational scholarships
+1
Data Center Operations Specialist
Data Center Operations Specialist

Ark • Akron (OH)

Presencial
USD 65 000 - 90 000
Junior Project Manager
Junior Project Manager

Range USA • Blue Ash (OH)

Presencial
USD 50 000 - 70 000
Medical, Dental, and Vision health ins
Unlimited Shooting – Free Classes
Discounts
+1
ERP Solutions Specialist | BI/SQL | Flexible Schedule
ERP Solutions Specialist | BI/SQL | Flexible Schedule

United Performance Metals • Hamilton (OH)

Presencial
USD 65 000 - 85 000
Quarterly Bonus Opportunity
Flexible Work Schedule
Tuition Reimbursement
+1
Onsite ERP Administrator: Drive System Improvements & Data Integrity
Onsite ERP Administrator: Drive System Improvements & Data Integrity

Ringside Talent Acquisition Partners • Columbus (OH)

Presencial
USD 75 000 - 105 000
Sr. PHP Web Developer
Sr. PHP Web Developer

Range USA • Cincinnati (OH)

Presencial
USD 110 000 - 150 000
Medical, Dental, and Vision health ins
Unlimited Shooting – Free Classes
Discounts – online and in-store
+2