Senior Business Intelligence Engineer
Milwaukee, Wisconson
Job Description:
Position- Senior Business Intelligence Engineer
Location- Milwaukee, WI
Duration-6 Months
In this role, the BI Engineer will be responsible for:
· Executing and facilitating 4-8 concurrent BI Projects, as well as ongoing pre-sales support.
· Maintaining a solid understanding of traditional enterprise data warehousing and next generation data platforms to meet use case specific requirements of multiple vertically aligned customers.
· Facilitating data platform discussions and working with data owners to define and understand business requirements of a future state Enterprise Data Platform.
· Understanding of disparate data sources and integrating them into a meaningful platform to support reporting and analytical needs of customers and audiences.
· Understanding of complex data relationships and business requirements that formulates new technologies to reduce overall cost and ROI for customers.
· Ability to present and communicate between all levels of an organization that would include C-Level Executives, Directors, Management, Analysts, Business Users, etc.
· Strict understanding of traditional Kimball / Inman architecture designs and Data Modeling efforts.
· Articulating data definitions, content domains, data classes, subject area classification, and conformed dimensions.
· Experience in collecting, maintaining, and publishing corporate data models related to database architectures.
· Enforcing data governance standards, policies, and procedures for the design and proper use and care of a customer’s data sets.
· Developing, managing, and updating data models, including physical and logical models of traditional data warehouse, data mart, staging area, and the operational data store and source system designs.
· Understanding a company's transactional systems and data sources and identifying gaps in business processes and recommend solutions to close those gaps.
· Assisting in the design of a company's data extraction, staging and loading to a data warehouse processes to ensure that data is as consistent, clean and accurate as possible.
· Acting as a key business partner to the company's Data Management Team and developers, to design solutions to correct problems, increase efficiency and performance, as well as recommending best practices for a next generation data platform that supports and drives reporting and analytic needs.
· Developing technical documentation including requirements documents, process overviews, data models /data flows from source to target, and design specifications
QUALIFICATIONS:
· Bachelor's degree in Computer Science, Engineering, or related field (MS Candidates Preferred)
· 5+ years of experience in Enterprise Data Warehousing, Architecture and Analytics
· 5+ years of data integration and architecture
· 5+years of data integration and non-traditional data platforms
· 5+years of design and implementation of enterprise-level data platforms that support a variety of business intelligence initiatives.
· Hands on experience with data modeling software tools
· Strong grasp of advanced SQL writing and query tuning / optimization
· Strong documentation skills
· Strong written / oral communication and organizational skills
· Excellent communication skills and ability to articulate modern data integration strategies
· Excellent problem solving skills
· Excellent relationship building skills
· Excellent white boarding skills
· Ability to educate and knowledge transfer
· Team player and collaborator
· Experience in code migration, database change management and data management through various stages of the development life cycle
· Understanding of architecture of next generation HA / DR Data Platforms
REQUIRED TECHNOLOGY STACK:
· Database Experience – Oracle, DB2, MS, Netezza, GreenPlumb
· BI Tools – Tableau, Qlik, Business Objects, Essbase, Microstrategy, Cognos, PowerBI, BOBJ
· Modeling Tools – Erwin, Embarcadero
· ETL Tools – Alteryx, Informatica, Talend, SSIS, DataStage, Pentaho
EXPOSURE PREFFERRED:
· Hadoop – IBM BigInsights, Cloudera, Horton Works, MapR
· Cloud – IBM (DashDB), AWS (Amazon Web Services), Microsoft (Azure)
· Predictive Analytics – Python, R, Jupiter Notebooks
· Statistical Modeling – Linear Regression, Decision Tree, Neural Network, Logistic Regression
Key Skills:
- ETL, Tableau, Qlick, Business Objects, Essbase, Microstrategy, Cognos, PowerBI, BOBJ