SonsoftInc

Senior Data Warehousing Engineer

  • Atlanta, GA
  • full time
  • Posted over a year ago
  • Staffing / consulting
Apply on SonsoftInc's site ↗Checked today on the employer's career site. We never take applications.

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:-

  1. This is a Full Time & Permanent job opportunity.
  2. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD can apply.
  3. H1B Visa Transfer can also apply for this position.
  4. No OPT-EAD and TN Visa candidates please.
  5. Please mention your Immigration Status while applying .
  6. All your information will be kept confidential according to EEO guidelines.

Similar open jobs

Talend ETL

SonsoftIncPiscataway Township, NJ

Employerover a year ago

All H-1B data engineer jobs in Georgia →