Senior Business Intelligence Engineer
Business Impact New York, NY
- Expired: over a month ago. Applications are no longer accepted.
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!
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.
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
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
Bachelor’s Degree in Computer Science, Mathematics and Statistics, or Management Information Systems
Business ImpactWhy 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.
Work from HomeNew York, NY