Design and implement data warehouses and dimensional models using the MSBI stack. Develop ETL (SSIS), tabular and multidimensional cubes (SSAS), SSRS reports, Power BI artifacts, and MDX queries. Support production, performance tuning, KPI and calculation development, PowerPivot/SharePoint integration, and coordinate with customers and global onshore/offshore teams.
Company Description
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.
- Good awareness on DW architecture and design using MSBI
- Strong knowledge of Dimension Modeling
- Good knowledge of MSBI suite of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
- Proficient in creating different types of cubes/schemas in Analysis Services
- Proficient in creating and testing new KPI's, perspectives and calculations
- Experience in creating SSRS reports from cubes
- Experience in PowerPivot and its Integration with SharePoint
- MDX Query writing experience
- Strong verbal and written communication skills as well as good time-management and organizational skills.
- Coordinate with customer, vendor and onsite/offshore folks
- Knowledge of Data Warehousing and Data Modeling concepts, specifically designing and populating normalized data warehouses and star schema based data marts
- Experience and understanding of in Production support and performance engineering
- Technical Skills
- Ability to work in team environment and client interfacing skills.
- Analytical skills
- Experience and desire to work in a Global delivery environment
- Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
- At least 4 years of experience with Information Technology.
- At least 3 years of experience in MSBI suite of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
- At least 3 years of experience in Software development life cycle.
** 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 job oppurtunity.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN VIsa can apply.
- No OPT-EAD & H1-B for this position.
- Please mention your Visa Status in your email or resume.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Design, develop and support MSBI-based data warehousing solutions including SSIS ETL, SSAS cubes, SSRS reports and Power BI/PowerPivot integration. Perform dimensional modeling, MDX queries, KPI creation, production support, performance tuning, and coordinate with customers and global teams.
Top Skills:
Analysis ServicesData MiningData WarehousingDimension ModelingDqsMdsMdxPerformancepointPower Bi (Power ViewPower Map)Power PivotPower QueryPowerpivotSharepointSsasSsisSsrsStar Schema
Artificial Intelligence • HR Tech • Information Technology • Machine Learning • Software • App development • Industrial
Lead GTM strategy and revenue operations to build an automated revenue operating system. Own GTM cadence, forecasting, tech stack, AI-driven scoring/enrichment, cross-functional initiatives, commission and territory design, and recruit and scale a RevOps/Strategy team.
Top Skills:
ClaudeClayGongHightouchMetabaseNooksSalesforceSQL
Aerospace • Hardware • Robotics • Software • Manufacturing
Design, analyze, size, and test primary and secondary flight structures (thrust structure, tanks, interstage, fairing). Use CAD (NX/Creo/SolidWorks), perform FEA (Nastran/ANSYS) and hand calculations, release drawings, support manufacturing process development and hardware test campaigns, and own designs from requirements through production.
Top Skills:
AnsysCreoFinite Element Analysis (Fea)Gd&TNastranNxSolidworksTeamcenter
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
