Data engineer

This job opportunity is for employment type W2.

Candidates who are willing to apply must hold US work authorization.

Job Title: Data Engineer

Job ID: 2022-11238

Job Location: Secaucus, NJ or remote

Job Travel Location(s):

# Positions: 1

Employment Type: W2

Candidate Constraints:

Duration: Long Term

# of Layers: 0

Work Eligibility: All Work Authorizations are Permitted – No Visa Transfers

Key Technology: SQL Server, SSAS and SSMS

Job Responsibilities:

• Analysis, design, coding, performance tuning, and implementation of new BI solutions.
• Evaluation, maintenance, and enhancement of existing ETL processes and model/cube structures.
• Creation of BI dashboards and workbooks using Power BI, Tableau, and Excel.
• Code data ingest solutions (C#, NodeJS) leveraging 3rd party APIs.
• Daily triage of bugs and tasks.
• Create documentation for applications and processes.
• Enforce best practices in all aspects of work and evaluate new data warehousing platforms and solutions.

Skills and Experience Required:

• 5+ years’ experience in a data warehouse team environment.
• Advanced level of experience with Microsoft SQL Server, SSAS and SSMS (Management Studio).
• Hands-on experience with SSIS or other similar ETL tools.
• Demonstrated strength with T-SQL for database queries, procedures, tables, views, etc.
• Proven skills with data visualization tools: Microsoft Excel (PowerPivot, Pivot Tables, Slicers), Power BI and Tableau (dashboard design, configuration and advanced calculations).
• Ability to work with .Net development tool Visual Studio 2017 to write code, make changes, and deploy updates.
• Experience with cloud platforms such as Azure, AWS, or GCP and their storage devices and connectivity tools such as AWS development tools: NodeJS and Lambda Functions.
• Experience with SSAS and/or Tabular data warehouse design experience including: an understanding of MDX/DAX, calculated measures, hierarchies, slowly changing dimensions, and date/time dimension analysis.
• A basic understanding of HTML, CSS, and web page deployment.
• Excellent written and verbal skills and the ability to present to upper management.

Education:

• Bachelor’s Degree in Computer Science or related field preferred.