# Senior Data Warehousing Engineer — SonsoftInc

- Location: Atlanta, GA
- Posted: Dec 15, 2016
- Status: open (checked Nov 20, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/sonsoftinc/104034604
- Employer record: https://visajobs.io/company/sonsoft.md

## Sponsorship history
- Tier: Employer history only
- Occupation (SOC): Database Architects (15-1243)
- Employer's certified LCAs for this occupation in GA, FY2024–FY2026: 0
- …in the whole US: 0
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $109k / $126k
- Staffing / consulting firm: 100% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
Job Description
Responsibilities
• As an engineer, the incumbent would be responsible for evaluating, developing, maintaining and testing BI solutions for various analytics projects
• Be responsible for building data warehouses, data marts & OLAP solutions
• Plan, create, coordinate, and deploy data warehouse and business intelligence solutions.
• Create best practices for data loading and extraction (ETL framework).
• Develop data architecture, data modeling, and ETL mapping solutions and data warehouse consistency.
• Would have a strong focus on collecting, parsing, managing, analyzing and visualizing large sets of data to turn information into insights using multiple platforms
Qualification & Experience
• 6+ years of experience as a Data Warehouse Architect / Developer and SQL server
• 4+ years of data modeling experience, and knowledge of 3NF, Star-Schema and other data
• 6 + years of experience working in SQL Server, SSIS and SSAS or SSRS
• Ability to work with multiple data sources
• Ability to develop, execute and analyze Multidimensional expressions (MDX) and DMX queries
• Ability to quickly create Analysis Service objects like data source views, dimensions and cubes and do enhancements to existing objects.
• Experience creating Tabular models is an advantage.
• Proven ability with SQL Server database design best practices and performance tuning
• Demonstrated solid understanding of Data Warehouse design theory, including dimensional data modeling
• Significant experience developing logical / physical dimensional models, OLAP processes
• Proven ability using SQL Server 2012 (or 2014), SSIS Packages, Procedures, Functions, SQL, and other SQL Server Database Objects
• Proven individual contributor and team player with effective communication skills
• Experience working collaboratively with Stakeholders, Business Analysts, Project Managers, Designers and DBAs with the common goal of delivering value to the business
Qualifications
Education: BS/MS in Computer Science or related technical degree
Additional Information
** U.S. citizens and those who are authorized to work independently in the United States are encourage to apply. We are unable to sponsor at this time .
Note:-
This is a Full Time & Permanent job opportunity.
Only US Citizen , Green Card Holder , GC-EAD , H4-EAD , L2-EAD can apply.
H1B Visa Transfer can also apply for this position.
No OPT-EAD and TN Visa candidates please.
Please mention your Immigration Status while applying .
All your information will be kept confidential according to EEO guidelines.

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
