Previous Job
BI Data Engineer
Ref No.: 17-00177
Location: Roseland, New Jersey
Position Type:Contract
Experience Level: 11 Years
Start Date: 08/29/2017
  • Bachelor's degree in Computer Science, Engineering, or equivalent education; Master's degree, preferred
  • Minimum 10 years of experience with software development using Microsoft technologies.
  • 6+ years of Data Modeling, Data Warehouse, SSIS, SSRS
  • Demonstrated proficiency with Microsoft Office Suite of products and with Structured Query Language (SQL)
  • Demonstrated ability to write transact-SQL queries
  • SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Data Quality Services.
  • Strong Data Modeling skills to include data quality, source systems analysis, business rules validation, source target, mapping design, performance tuning and high volume data loads.
  • Sr. level understanding of warehousing architectures including ETL design, staging, transformations, delta/change data capture, star-schemas, cubes, and history loading
  • Experience leveraging ETL frameworks to develop scalable solutions using SSIS. Design and develop SSIS packages, configuration files, stored procedures, tables, views and functions;
  • Understand database platform layouts and configurations.
  • Excellent communication skills
  • Experience working in an agile team environment. Understanding of code promotion, code turnover to operations, version control, and QA procedures. Conduct code walkthroughs, peer reviews, and produce technical documentation
  • Strong analytical skills and problem-solving ability, including an expertise in soliciting and interpreting customer. business needs and translating them into application and operational requirements.
  • Demonstrable strong organizational and critical thinking skills with the ability to prioritize and negotiate with stakeholders.
  • Experience in using Cloud based managed services for data warehousing/analytics in Microsoft Azure (Azure Data Lake, Azure Data Lake Analytics, Azure Data Factory, Azure Table Storage, U-SQL, Stream Analytics, HDInsight, etc.) (MUST)
  • Write sophisticated SQL queries to extract data and build models.
  • Build/automate reports/dashboards (in Power BI and Microsoft Analysis Services) that allow the business leaders to get a clear snapshot of their operations.
The BI Data Engineer is responsible for the design and development of Enterprise Data Warehouse, Data Mart, and Business Intelligence Reporting environments.
The BI Data Engineer will be responsible to work on internal, external various data sources and system and integration of those system with company application.  BI Data Engineers will work closely with Enterprise Data Architect, Product Owner and the Center of Innovation (COI) team to design and implement reporting and analytical solutions, including the design and development of table structures and the processes used to populate those structures with data from internal and external sources.
Systems and Standards
  • Completes tasks in a timely manner as instructed by the supervisor.▪ Demonstrated ability to interact cross-functionally at all levels internally and externally, and ability to develop relationships with vendors, customers and prospects, when appropriate
  • Ability to quickly learn and effectively leverage operations, enabling technology, processes and other assets
  • Demonstrated negotiation, facilitation and consensus building skills
  • Cooperates with senior management and coworkers to ensure that services can be adequately maintained and meets the needs of internal and external customers.
  • Treats clients and associates with courtesy, respect and dignity.
  • Interfaces with management and technology support personnel.