Data Engineer jobs

Senior Data Warehousing Engineer

Sonsoft Inc (agency)Atlanta, GAFull-time

Pay not listed

Key facts

Experience
6+ years
Degree
Bachelor's degree
US visa
No US visa sponsorship

2 things to check before you apply.

On Sonsoft Inc’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 9 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 60 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • 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.

Sign in to check your match

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
  • 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.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Senior Data Engineer

The Weather Company · Atlanta, GA +1 place

Pay not listedHybrid

Looks good2 to checkChecked open todayPosted 9 months ago

Sr. Data Engineer

Florence Healthcare - US · Atlanta, GA

StrongPay not listedChecked open todayPosted 1 month ago

Lead Data Engineer

Honeywell · Atlanta, GA

Hybrid

Looks goodPay not listedChecked open todayPosted 13 days ago

Medicaid Data Lead

Abt Global · Rockville, MD +3 places

$110k–$155k/yr

StrongChecked open todayPosted 9 days ago

See more like this