Skip to Main Content

Senior Business Intelligence Engineer

Business Impact New York, NY

  • Expired: over a month ago. Applications are no longer accepted.
Job Description

OUR PEOPLE ARE OUR GREATEST ASSET

At Business Impact, we value IQ, but being brilliant is only half the battle. In order to provide world class service to our clients, our people must be flexible, creative, collaborative, and friendly. In short, we hire well-rounded people with an entrepreneurial motor. Our clients value these difference makers and we’re confident that you will too!

POSITION PURPOSE

The Sr Data Engineer designs, develops and optimizes data warehouses with scalable data and ETL architecture to provide enterprise data services for business users and applications. This infrastructure is the backbone for delivering dynamic reporting, analytics, and business intelligence. This position is a key lead in the analysis, definition and development of a long-term data plan that will meet the analytical needs our customer’s organizations.

CULTURE FIT

As a Senior Team Member, the business depends on you to provide leadership in the following areas:

  • Ability to communicate information clearly, concisely, and effectively both orally and in writing
  • Comfortable with ambiguity, and changes in priority
  • Establish standards, direct continuous improvement initiatives, and develop scalable processes
  • Comfortable working in a collaborative, team-centric environment
  • Ability to work well with a wide variety of people with varying technical skill sets and business knowledge
  • Experience in complex, cross-departmental projects involving multiple platforms

PRIMARY RESPONSIBILITIES:

  • Design and oversee development of ETL and other data movement systems related to data warehousing and analytics solutions

  • Create logical and physical data models that align to client’s business requirements

  • Follow best practices for data creating and managing the data extraction, transformation and loading (ETL) framework

  • Design and build Data Warehouse structures (databases and SSAS cubes)

  • Support the development and validation required throughout the entire lifecycle of the data warehousing and business intelligence systems.

  • Develop unique, simple solutions to meet the immediate and long-term needs of information customers and stakeholders

  • Knowledge of performance tuning to optimize load and query performance in data warehousing and analytics systems. Ability to analyze, diagnose, and recommend solutions for performance issues Review user requests, create project specifications, estimate time and cost to fulfill client requirements, and write-up SOW’s

  • Assess emerging technologies in the data storage/management space and make recommendations to senior leadership

  • Create and manage architecture documentation and project artifacts such as data models, data dictionaries, ETL data maps, performance requirements

  • Additional tasks and duties as assigned

REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES

  • Five or more years of experience as a Data Warehouse architect and ETL developer

  • Five or more years of experience with the Microsoft Data Warehousing and Business Intelligence stack (SQL Server, SSIS, SSRS, SSAS)

  • Five or more years of experience with data analysis and data profiling using SQL and other tools.

  • At least three years of data modeling experience, and knowledge of 3NF, Star-Schema and other data warehousing modeling techniques.

  • Knowledge of relational data, data warehousing and OLAP concepts (star/snowflake schema design)

  • Familiarity and experience with Transact-SQL, triggers, indexes, views and stored procedures based on business logic

PREFERRED KNOWLEDGE, SKILLS, AND ABILITIES

  • Experience with business processes and functions performed by ERP/accounting systems a plus

  • Ability to understand client business data and integrate multiple sources into optimal data structures

  • Work with APIs (Rest, SOAP, ODATA, others) to receive and send

  • Meet with client decision-makers and analysts to define requirements and prepare deliverable estimates

  • Familiarity with Wherescape, .NET, C#

  • Working experience with Dynamics NAV, AX, GP, CRM, Ross, QuickBooks, SAP or JDE a plus

  • Experience with various BI reporting tools

EDUCATIONAL REQUIREMENTS

  • Bachelor’s Degree in Computer Science, Mathematics and Statistics, or Management Information Systems

 

 

Company Description
Business Impact is a group of data artisans, dedicated to flexible, easy to use data delivery for clients in many fields - manufacturing, food, wine, pharma, retail and other industries. We work to organize data for reporting - from many systems - to one data repository. We've partnered with Adaptive Insights for financial planning and analysis plus the many other budgets/goals/plans it allows in its driver based modeling tool.

Business Impact

Why Work Here?
Premier business intelligence group of professionals; all A players; be apart of something bigger

Business Impact is a group of data artisans, dedicated to flexible, easy to use data delivery for clients in many fields - manufacturing, food, wine, pharma, retail and other industries. We work to organize data for reporting - from many systems - to one data repository. We've partnered with Adaptive Insights for financial planning and analysis plus the many other budgets/goals/plans it allows in its driver based modeling tool.

Business Impact's Logo

Address

Work from Home

New York, NY
USA
View all jobs at Business Impact