SIRITECH SOLUTIONS

60 jobs near Columbus, OH

Net web application development, database architecture, SQL-based analytics, and reporting solutions. The candidate will be responsible for designing, developing, and supporting web-based systems ...

No travel anticipated for this engagement Requested Qualifications: * 36 months experience developing dynamic reports using a business intelligence reporting solution * 24 months experience producing ...

Systems Architect

Albany, NY ยท On-site

$241K/yr

Architect enterprise technology solutions aligned with agency standards and business requirements * Design, document, and maintain enterprise technical and security architectures * Install, configure ...

next page

Showing results 1-20

Senior SSIS/SSAS Data Warehouse Developer

SIRITECH SOLUTIONS CORP

Austin, TX โ€ข On-site

Full-time

Posted 12 days ago


Job description

Job Summary:
SIRITECH SOLUTIONS CORP is seeking an experienced Senior SSIS/SSAS Data Warehouse Developer to support enterprise data warehouse and business intelligence initiatives. The role involves maintaining, enhancing, and optimizing backend data processes that power enterprise Power BI dashboards while developing scalable ETL and analytical solutions using Microsoft SQL Server technologies.
Responsibilities:
โ€ข Develop, maintain, and enhance SSIS ETL packages.
โ€ข Design, develop, and support SSAS cubes and tabular models.
โ€ข Maintain backend data warehouse processes supporting Power BI dashboards.
โ€ข Develop and optimize SQL Server databases, stored procedures, and queries.
โ€ข Create deployment packages and migration instructions for test and production environments.
โ€ข Prepare and maintain technical documentation and system specifications.
โ€ข Participate in business requirements gathering and solution analysis.
โ€ข Evaluate dashboard enhancement requests and provide feasibility assessments.
โ€ข Estimate development effort and implementation timelines.
โ€ข Support dashboard governance activities and technical reviews.
โ€ข Optimize ETL performance and data processing workflows.
โ€ข Troubleshoot production issues and implement corrective solutions.
โ€ข Collaborate with business users, developers, and technical teams.
โ€ข Ensure data integrity, quality, and consistency across reporting platforms.
Qualifications:
Required:
โ€ข SQL Server Integration Services (SSIS)
โ€ข SQL Server Analysis Services (SSAS)
โ€ข SQL Server 20192022
โ€ข Microsoft .NET
โ€ข ETL Development
โ€ข Data Warehouse Development
โ€ข SQL Programming
โ€ข Stored Procedures
โ€ข Database Performance Tuning
โ€ข Technical Documentation
โ€ข Requirements Gathering
โ€ข Data Modeling
โ€ข Deployment Management
โ€ข Production Support
โ€ข Dashboard Data Processing
โ€ข Minimum 10 years of experience with SQL Server Integration Services (SSIS).
โ€ข Minimum 10 years of experience with SQL Server Analysis Services (SSAS).
โ€ข Minimum 6 years of experience with SQL Server 20192022.
โ€ข Minimum 5 years of experience with Microsoft .NET development.
โ€ข Minimum 5 years of experience preparing technical documentation.
โ€ข Minimum 5 years of experience working with the Ed-Fi Data Standard.
โ€ข Minimum 5 years of experience with the Educator Preparation Data Model (EPDM).
โ€ข Strong experience developing and supporting enterprise data warehouse solutions.
โ€ข Experience participating in requirements gathering and technical solution design.
Preferred:
โ€ข Power BI
โ€ข Ed-Fi Data Standard
โ€ข Educator Preparation Data Model (EPDM)
โ€ข Business Intelligence
โ€ข Data Governance
โ€ข Reporting Solutions
โ€ข Dashboard Development
โ€ข Performance Optimization
Company:
SiritechSolutions Corp (โ€œSiritechโ€) is an IT professional services firm providing expertise to empower clientsโ€™ businesses. Founded in 2023, the company is headquartered in Tampa, Florida, US, , with a team of 51-200 employees. The company is currently Growth Stage.