Astir IT Solutions, Inc. · 3 days ago
Data Architect/Senior Data Analyst(Only w2)
Astir IT Solutions, Inc. is seeking a Data Architect/Senior Data Analyst to maintain and document enterprise data and support data warehouse development. The role involves partnering with business SMEs, designing reports, and providing advanced SQL Server expertise.
Responsibilities
Maintain and document the enterprise data dictionary and business rules
Partner with business SMEs to validate data definitions, calculations, and logic
Design and maintain reports using Power BI and SSRS
Support report conversion efforts related to system migrations
Provide advanced SQL Server expertise, including performance tuning and stored procedures
Support data warehouse development, optimization, and data quality initiatives
Translate business requirements into technical reporting and analytics specifications
Document data lineage, transformations, and report logic
Qualification
Required
Minimum 10+ Years of Experience required
7+ years of professional data analysis or BI experience
Advanced SQL Server expertise (queries, tuning, partitioning)
Strong experience with Power BI and/or SSRS
Data warehouse experience
Proven ability to gather and document requirements from business stakeholders
Experience working in active production environments under time constraints
Preferred
Experience with financial, tax, or property-related systems
Experience supporting system migrations or large-scale report conversions
Public sector or highly visible environment experience
Strong documentation and communication skills
Company
Astir IT Solutions, Inc.
Astir IT Solutions, Inc. (www.astirit.com) is a fast growing IT consulting, services, and outsourcing firm.
H1B Sponsorship
Astir IT Solutions, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (119)
2024 (46)
2023 (67)
2022 (121)
2021 (117)
2020 (194)
Funding
Current Stage
Growth StageCompany data provided by crunchbase