logo

View all jobs

BI Data Engineer 

Raleigh, NC
Amick Brown is seeking an experienced BI Data Engineer for our direct client.

Location: Raleigh, NC or Sunnyvale, CA
Duration: 5 Months


Job Description
  • We need an experienced BI Data Engineer to work on Snowflake and SQL server platforms.
  • The resource should have experience primarily in business intelligence, data warehousing and ELT development on the Snowflake platform using Snowflake capabilities like Snow SQL, Tasks, and Streams, Time travel, Data sharing and stored procedures.
  • The resource should also have experience in MS SQL server, T-SQL Scripts and Stored Procedures.
  • Strong SQL development skills are a requirement of this position.
  • The engineer will be part of a development team using an agile methodology to continuously deliver business value.
  • The person should also possess the ability to analyze business requirements and ask clarifying questions.
  • He/she should be able to work independently with minimum supervision and provide a structured development effort to ongoing/new projects.
 
Roles and Responsibilities
  • Design and develop data movements using Snowflake capabilities like Snow SQL, Tasks, Streams, Time travel, Data sharing and stored procedures
  • Deliver ETL, BI Data models and Analytic solutions using Snowflake data platform and Microsoft SQL Server Business Intelligence tools.
  • Design and build data models to conform with our existing EDW architecture
  • Work with teams to deliver effective, high-value reporting solutions by leveraging an established delivery methodology.
  • Perform data mining and analysis to uncover trends and correlations to develop insights that can materially improve our decisions.
  • Familiarity with SAP, Salesforce.com
  • Writing analytics programs (transformations/calculations) using T-SQL and Python or comparable
 
Required Skills
  • 5+ years Business Intelligence / Data Warehouse development experience
  • 2+ Years of experience in data warehousing and ELT development on Snowflake data platform
  • 3+ Years of experience in data warehousing and ELT development (T-SQL, PLSQL, and/or SQL scripts)
  • Require knowledge and experience with Apache Airflow, SAP BODS and Microsoft Integration Services 2005 or greater (SSIS).
  • Python experience required, R is a plus
  • Experience visualizing data in business intelligence tools such as Tableau, Business Objects or Hana Analytics
  • Experience creating test plans, testing and resolving data discrepancies
  • Must be a self-motivated, energetic, detail oriented team player passionate about producing high quality BI & Analytics deliverables
  • Strong sense of customer service for internal customers
 
Amick Brown is an Information Technology consulting company specializing in ERP, Data Analytics, Information Security, Application Development, Networking, and Cloud Computing. The company was founded in 2010 and is headquartered in San Ramon, California.

Regular full-time employees are eligible for the following Amick Brown provided benefits: 
  • Health
  • Vision
  • Dental
  • 401k with company match
  • Paid time off
  • Sick Leave
  • Short-Term Disability
  • Life Insurance
  • Wellness & Discount Programs

Share This Job

Powered by