Posted 3 months ago
SQL Server Data Architect
AustinOn-siteFull-time
AI Summary
A SQL Server Data Architect designs and delivers data solutions including data warehouses, ETL/ELT frameworks, and SSRS reporting, while tuning MSBI workloads and improving existing BI processes.
About this role
SQL Server Data Architect
Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
- Experience with SQL Server features like store indexes/partitioning, in live projects
- Good experience on SSRS
- Data warehousing knowledge and background
- Asp.net or MVC experience
- Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
- Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
- Ability to work in team in diverse/ multiple stakeholder environment
- Experience in Finance domain
- Strong analytical skills
- High impact communication
- Ability to ramp up in new technologies
- Experience and desire to work in a Global delivery environment.
Qualifications
- Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider one year of relevant work experience in lieu of every year of education.
- At least 7 years of working experience with SQL Server and MSBI suite, especially SSIS.
- At least 5 years of experience working with SQL.
- Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using MSBI Suite
- At least 4 years of hands on experience in Development & Build activities in MSBI - MUST.
- Experience in performance tuning for MSBI jobs especially SSIS – MUST.
- Must have experience in analyzing existing ETL and BI processes, suggesting and implementing performance improvement measures.
- Experience in conducting code reviews and providing guidance to development team
- Very good understanding of SQL Server is MUST and good knowledge on other major RDBM systems, i.e., DB2, Oracle.
Additional Information
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a Full-Time Permanent job opportunity for you.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD, TN Visa & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
Skills
ASP.NETData WarehousingDB2Dimensional ModelingELTETLMSBIOracleSQL ServerSSISSSRS
Explore related jobs
More jobs at Sonsoft Inc
Similar ASP.NET jobs
Jobs in Austin
- UAssociate - Litigation and/or Merger Control - Antitrust & CompetitionUs Associatelw · Austin, TX
- UAssociate - Litigation & Trial - Securities and M&A LitigationUs Associatelw · Austin, TX
- SLeasing Consultant - Settler's RidgeSimpsonhousing · Austin, TX
- WSales Consultant - West TexasWerfen · Austin, TX
- EManager - Vehicle Engineering (M.S./Ph.D.)Exponent · Austin, TX
- EVehicle Engineer/Sr. Vehicle Engineer (M.S./Ph.D.)Exponent · Austin, TX
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.