INSPYR Solutions · 4 hours ago
Data Analyst Programmer
INSPYR Solutions is a national expert in delivering flexible technology and talent solutions. They are seeking a skilled Data Analyst Programmer to design, build, and maintain end-to-end data pipelines and analytics solutions across on-premises and cloud environments.
Information TechnologyProfessional ServicesStaffing Agency
Responsibilities
Design, develop, and maintain ETL/ELT pipelines using both on-premises and cloud-based tools, including IBM InfoSphere DataStage, Microsoft SSIS, and Azure Data Factory (ADF), based on the project plan
Build and manage scalable data pipelines and storage solutions using Azure Synapse Analytics and Azure Data Lake Storage, ensuring efficient data ingestion, transformation, and retrieval, based on the project plan
Develop and optimize data solutions using Python, R, T-SQL, and PL/SQL to support analytics, reporting, and downstream applications
Work with traditional on-premises relational databases such as Oracle, SQL Server, and DB2, including performance tuning and data integration
Design and implement data models, data warehouses, and architectural frameworks that support enterprise reporting and analytics needs
Create and maintain Power BI datasets, data models, and reports, ensuring optimized performance and accurate business insights
Ensure data quality, accuracy, and reliability across all data pipelines by implementing validation, monitoring, and governance processes
Support trustworthy and compliant data analytics by maintaining traceable data lineage and enforcing governance standards throughout the data lifecycle
Collaborate with stakeholders, analysts, and data consumers to understand requirements and translate them into scalable data solutions
Deliver weekly progress reports for development team code review
Analyze and correct technical issues as found, providing weekly bug status updates
Qualification
Required
US Citizen, GC Holders or Authorized to Work in the U.S
At least 3 years of professional experience in designing, building, and maintaining end-to-end data pipelines and analytics solutions across on-premises and cloud environments
Strong ETL expertise
Hands-on experience with Azure data services
Solid data modeling and warehouse design skills
Strong commitment to data quality, governance, and compliance
Expert level/Minimum three (3) years' experience in ETL development using on-premises and cloud tools
Expert level/Minimum three (3) years' experience in Python, R, T-SQL, and/or PL/SQL
Expert level/Minimum three (3) years' experience in Azure Synapse Analytics and Azure Data Lake Storage
Expert level/Minimum three (3) years' experience in design and implement data pipelines following Medallion Architecture (Bronze, Silver, Gold layers)
Advance level/Minimum one (1) year' experience in on-premises databases (Oracle, SQL Server, DB2)
Advance level/Minimum one (1) year' experience in Power BI and Power BI data modeling
Minimum one (1) year' experience in data modeling and data warehouse design and architecture for on-premises and cloud environments
Minimum one (1) year' experience in data governance, validation, monitoring, and lineage management
Preferred
Experience supporting predictive analytics or advanced analytics workloads
Familiarity with cloud-based data governance and monitoring frameworks
Demonstrates professional organization, documentation, communication, and interpersonal skills
Strong communication and collaboration
Maintain and communicate status of work performed bi-weekly at minimum
Benefits
Comprehensive medical benefits
Competitive pay, 401(k)
Retirement plan
And much more!
Company
INSPYR Solutions
INSPYR Solutions is a information technology staffing service providers.
Funding
Current Stage
Late StageLeadership Team
Recent News
2025-09-12
Company data provided by crunchbase