The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.

BI/ Data Engineer

Job Description

***Must be eligible to work in the US without sponsorship due to client requirements***

***NO THIRD PARTY VENDORS***

Our client, located in Queens NY, is seeking a Business Intelligence (BI) Engineer to partner with our business intelligence team on building the data sources required for Tableau reporting. You will maintain data extraction, transformation and publishing of raw data from various data sources into our data warehouses for consumption through Tableau. You will own master data management and the buildout of ETL solutions to bring data from our partners into our data lake. The ideal candidate will enjoy working on a variety of projects at once, with lots of different software services and data sources.

Top Skills Needed:

  1. Hands on experience writing SQL queries and working with cloud based ETL tools like Alteryx or Matillion.
  2. Experience integrating data sources with BI systems such as PowerBI or Tableau
  3. Strong SQL integration knowledge with SQL Server, MySQL, or another RDBMS.

Responsibilities:
* Lead data administration, modelling and integration activities in data warehouse systems
* Manage and contribute to the strategy and engineering of the data life cycle management
* Analyze user requirements and translate into database requirements and implement in database code
* Build the infrastructure required for optimal extraction, transformation, and loading (ETL/ELT) of data from a wide variety of data sources and optimizing data delivery, re-designing infrastructure for greater scalability
* Create and optimize SQL queries and stored procedures
* Maintain business intelligence solutions to achieve data reporting and analysis goals in Tableau
* Coordinate with the business units to identify new data requirements, analysis strategies, reporting mechanisms and automate report delivery
* Conduct unit testing and troubleshooting
* Experience building/deploying software using toolsets within common cloud infrastructures such as Amazon Web Services (AWS) or Azure

Requirements/Qualifications
* 3 years minimum hands on experience database administration, configuration and query
* Ability to work with multiple versions of SQL: Microsoft SQL Server, MySQL, or another RDBMS
* Experience in supporting data pipeline into Tableau or Power BI cloud platforms
* Background in data warehouse design (e.g. dimensional modeling) and data mining
* A successful history of manipulating, processing and extracting value from large disconnected data sets
* Strong analytical and organization skills including ability to document and analyze business processes
* Bachelor's degree in Engineering, Computer Science, Data Scientist, Statistics, Information systems or quantitative related field
* Snowflake Data Warehouse, Python, MapReduce a plus
* Familiarity with modern source control systems, Git a plus



The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems .com for other accommodation options.

Job Requirements

 

Job Snapshot

Location US-NY-Whitestone
Employment Type Full-Time
Pay Type Year
Pay Rate $90,000.00 - $110,000.00 /Year
Store Type IT & Technical, Other
Apply

Company Overview

TEKsystems, Inc

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company. Learn More

Contact Information

US-NY-Whitestone
Evan Shanahan
2122925206
Snapshot
TEKsystems, Inc
Company:
US-NY-Whitestone
Location:
Full-Time
Employment Type:
Year
Pay Type:
$90,000.00 - $110,000.00 /Year
Pay Rate:
IT & Technical, Other
Store Type:

Job Description

***Must be eligible to work in the US without sponsorship due to client requirements***

***NO THIRD PARTY VENDORS***

Our client, located in Queens NY, is seeking a Business Intelligence (BI) Engineer to partner with our business intelligence team on building the data sources required for Tableau reporting. You will maintain data extraction, transformation and publishing of raw data from various data sources into our data warehouses for consumption through Tableau. You will own master data management and the buildout of ETL solutions to bring data from our partners into our data lake. The ideal candidate will enjoy working on a variety of projects at once, with lots of different software services and data sources.

Top Skills Needed:

  1. Hands on experience writing SQL queries and working with cloud based ETL tools like Alteryx or Matillion.
  2. Experience integrating data sources with BI systems such as PowerBI or Tableau
  3. Strong SQL integration knowledge with SQL Server, MySQL, or another RDBMS.

Responsibilities:
* Lead data administration, modelling and integration activities in data warehouse systems
* Manage and contribute to the strategy and engineering of the data life cycle management
* Analyze user requirements and translate into database requirements and implement in database code
* Build the infrastructure required for optimal extraction, transformation, and loading (ETL/ELT) of data from a wide variety of data sources and optimizing data delivery, re-designing infrastructure for greater scalability
* Create and optimize SQL queries and stored procedures
* Maintain business intelligence solutions to achieve data reporting and analysis goals in Tableau
* Coordinate with the business units to identify new data requirements, analysis strategies, reporting mechanisms and automate report delivery
* Conduct unit testing and troubleshooting
* Experience building/deploying software using toolsets within common cloud infrastructures such as Amazon Web Services (AWS) or Azure

Requirements/Qualifications
* 3 years minimum hands on experience database administration, configuration and query
* Ability to work with multiple versions of SQL: Microsoft SQL Server, MySQL, or another RDBMS
* Experience in supporting data pipeline into Tableau or Power BI cloud platforms
* Background in data warehouse design (e.g. dimensional modeling) and data mining
* A successful history of manipulating, processing and extracting value from large disconnected data sets
* Strong analytical and organization skills including ability to document and analyze business processes
* Bachelor's degree in Engineering, Computer Science, Data Scientist, Statistics, Information systems or quantitative related field
* Snowflake Data Warehouse, Python, MapReduce a plus
* Familiarity with modern source control systems, Git a plus



The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems .com for other accommodation options.

Job Requirements

 
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
BI/ Data Engineer Apply now