Application Systems Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

INSPYR Solutions · 18 hours ago

Application Systems Analyst

INSPYR Solutions is a national expert in delivering flexible technology and talent solutions. The Application Systems Analyst will serve as the primary technical resource between the business and execution teams, responsible for translating high-level data strategies into tactical technical requirements and overseeing data integration and governance processes.

Information TechnologyProfessional ServicesStaffing Agency
badNo H1Bnote

Responsibilities

Data Engineering Integration & Pipeline Oversight
Medallion Architecture Implementation: Involved in the tactical execution of the Medallion data design (Bronze/Silver/Gold) to modernize the organization’s data lakehouse environment
ETL/ELT Logic Design: Architect and manage complex Extract, Transform, Load (ETL) specifications and transformational logic to automate multi-directional data flows
Persistent Staging & Data Lifecycle: Oversee the technical requirements for staging and landing zones to ensure high-availability and historical data integrity for downstream consumption
Technical Scalability & Performance Tuning: Optimize data system performance by identifying bottlenecks in data processing and ensuring the technical framework supports high-volume, diverse data sets while adhering to security protocols
Technical Data Governance & Mapping
This role focuses on executing source-to-target mappings and defining the logic needed for data transformations, including type conversions and business rules. You will be responsible for setting up automated quality checks to ensure all ingested data is accurate and auditable. A key part of the position involves integrating data privacy and regulatory standards into the system design while using Master Data Management (MDM) and data cataloging tools to document technical metadata and maintain clear data lineage from start to finish
Reporting & Advanced Analytics Enablement
Technical Requirements Engineering: Bridge the gap between business ambiguity and technical execution by converting stakeholder needs into detailed Functional Specification Documents (FSD) and Technical Design Documents (TDD)
BI Stack Optimization: Manage and optimize the semantic layers of reporting tools (Power BI and Business Objects) to ensure performant data modeling and self-service scalability
AI Analytics Readiness: Architect the data environment for AI/ML consumption by ensuring "clean-room" data availability, feature set readiness, and robust dashboarding
SQL Querying: Execute SQL scripting to validate data sets and perform root-cause analysis on data discrepancies
Technical Oversight
Data Flow & Pipeline Optimization: Analyze existing data pipelines to identify opportunities for latency reduction and systemic throughput efficiency
Technical Liaison: Act as the technical point of contact for data projects, synchronizing efforts between Business Process Analysts, Data Engineers, and DevOps teams

Qualification

Data ArchitectureETL/ELT Logic DesignSQLPower BIData GovernanceAzure SynapseSnowflakeDatabricksPythonDAX/M-CodeAgile Scrum

Required

US Citizen, GC Holders or Authorized to work in the U.S
A minimum of 5 years of proficiency in Data Architecture and platforms like Azure Synapse, Snowflake, or Databricks
7 years of SQL skills for data validation and root-cause analysis
A minimum of 5 years of experience with ETL/ELT logic design and managing multi-stage data flows
2 years of expertise in data governance frameworks and tools like Purview, Alation, or Collibra
7 years of technical documentation (FSD/TDD) creation and 5 years of PowerBI related data research and mapping experience
Must be able to pass a criminal background check before starting work
You must be able to work Pacific Time work hours Mon Fri, 8AM 5PM on site

Preferred

Python (preferred) for data analysis
Experience with Data Classification tools and implementation

Benefits

Comprehensive medical benefits
Competitive pay
401(k) retirement plan
...and much more!

Company

INSPYR Solutions

twittertwitter
company-logo
INSPYR Solutions is a information technology staffing service providers.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Gregg Straus
Executive Vice President & Chief Financial Officer
linkedin
leader-logo
Michelle Wren
Chief Operating Officer
linkedin
Company data provided by crunchbase