Evaluate, develop, maintain, and test BI solutions for analytics projects.
Build data warehouses, data marts, and OLAP solutions; plan and deploy data warehouse and BI solutions.
Create ETL best practices and develop data architecture, data models, ETL mappings, and warehouse consistency.
Collect, parse, manage, analyze, and visualize large datasets to produce insights.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
6+ years of experience as a Data Warehouse Architect/Developer and with SQL Server
4+ years of data modeling experience
6+ years working with SQL Server, SSIS, and SSAS or SSRS
Significant experience developing logical and physical dimensional models and OLAP processes
Experience with SQL Server 2012 or 2014, SSIS packages, procedures, functions, SQL, and other SQL Server database objects
Experience collaborating with stakeholders, business analysts, project managers, designers, and DBAs
Experience creating Tabular models (preferred)
Education
BS or MS in Computer Science or a related technical degree
Skills
Knowledge of 3NF, Star Schema, and other data modeling approaches
Ability to work with multiple data sources
Ability to develop, execute, and analyze MDX and DMX queries
Ability to create Analysis Services objects such as data source views, dimensions, and cubes, and enhance existing objects
SQL Server database design best practices and performance tuning
Understanding of data warehouse design theory, including dimensional data modeling
Other requirements
Eligible work status: U.S. citizen, Green Card holder, GC-EAD, H4-EAD, L2-EAD, or H1B visa transfer; no OPT-EAD or TN visa candidates. Sponsorship is unavailable.
Your match
Sign in and add your resume to see which of this job's requirements it shows.
Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.
Full job description
From Sonsoft Inc’s careers site
Company Description
SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
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).
Show full descriptionShow less
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
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.