1. This job opportunity is for employment type W2.
2. Candidates who are willing to apply must hold US work authorization.
Job Title: Data Engineer
Job Location: Remote
# Positions: 2
Employment Type: W2
Duration: Long term
Work Eligibility: All Work Authorizations are Permitted – No Visa Transfers
Key Technology: SQL, Excel
Job Responsibilities:
Design and support the database and table schemas for new and evolving sources of data being brought into the data warehouse.
Create and support the Analysis Services.
Monitor and troubleshoot performance issues.
Define and promote the team’s design principles and best practices.
Work with business teams to define requirements for real-time reporting.
Skills and Experience Required:
Required:
Very Strong in SQL (2012 or better): stored procedures, functions, views, joins, import/export data, and the ability to develop queries from SQL.
Broad Knowledge of BIDS (Business Intelligence Development Studio) with heavy concentration in SSIS.
Experience in Tableau and Power BI.
Expertise in Excel and advanced Excel skills, must be able to connect to various data sources, conditional formatting, pivot tables & pivot reporting, functions & formulas, and sorting & filtering.
Ability to identify data anomalies in a timely manner.