BI Data Engineer

Company: Solution Partners, Inc.
Location: Naperville
Posted on: April 10, 2021

Job Description:

We are seeking a seasoned Business Intelligence Data Engineer to join our client's Data Analytics team. Their analytics and data engineering teams operate as an engine for tackling cross-functional, high-profile business problems that add value, build new expertise, and establish innovative, competitive advantages for our business partners. We are looking for you to be a thought-leader, building solutions from the ground up, and advancing our business intelligence capabilities to be industry changing. You will engage in developing and deploying a variety of business intelligence solutions and capabilities that will deliver impactful results to help drive sales and insights. Azure Cloud experience is helpful as well as DataLake, DataBrick, Data Catalogue, and ML Services. Our client is 80% done with migrating off of Tableau to Power BI. You will work on ad-hoc data requests, onboarding and supporting new business users, and making sure all models are updated. Salary up to 155K plus bonus 30K-50K.

Primary Responsibilities: --- Work collaboratively with our business partners to understand business needs and objectives, then design and deploy business intelligence solutions and models to solve relevant business issues using appropriate data strategy methods and business intelligence tools. --- Design and develop Business intelligence data schemas, and models, for advanced reporting via Power BI. --- Design and develop data extracts, transformation, and load (ETL) mappings, procedures, and schedules. --- Design and develop Power BI reports, dashboards, KPIs, and data extracts. --- Deliver ad-hoc data extracts for day-to-day business decision making. --- Responsible for data governance and master data managements standards and best practices and operates as the liaison to the Data Governance Board. --- Responsible for integration and validation of third-party data sets to our core business intelligence solutions, data eco-system and core corporate applications i.e., CRM Dynamics etc. --- Leverage experience working with many types of data, including unstructured and structured, to support analytics. Identify key data requirements and acquire data; harmonize, rescale, and cleanse data for statistical techniques. --- Lead data driven projects, or the analytics portion of projects, by communicating and reporting status to key business stakeholders, including status, budget, risks, issues, etc. --- Hands-on experience with multivariate analytic techniques such as linear and logistic regression, decision tree, cluster and factor analysis, time-series forecasting methods etc.
Minimum Qualifications: --- MS or Bachelors' degree with equivalent experience Business Analytics and Data Science, or related disciplines such as Statistics, Mathematics, Operations Research is preferred. --- A minimum of 7+ years of experience working in business intelligence, data analytics, managing and/or coaching one or more analysts. Asset and Wealth Management experience and/or Financial Service exposure are preferred.
Must have skills:---ETL tools (Informatica, Talend, IBM DataStage, Snowflake, Azure Data Factory, AWS Glue, etc.), ---Database Platforms (Oracle Snowflake, Redshift, or Azure)---Business Intelligence reporting tools (detailed work experience in one of the following capabilities ? Tableau, IBM Cognos, SAP Business Objects, Microsoft Reporting Services, Power BI (including knowledge of DAX) or MicroStrategy).---Microsoft SQL Server platform (2016 or later). ---Microsoft Office products especially Excel and PowerPoint are required.---Good knowledge of standard concepts, best practices, and procedures within a data warehousing and Business Intelligence (BI) environment. ---Experience performing data migration, modeling, mining / extracts, and master data management (MDM) to and from disparate data sources / platforms.---Azure cloud services i.e., data lake, data bricks etc.---Python is a plus.

Keywords: Solution Partners, Inc., Naperville , BI Data Engineer, Engineering , Naperville, Illinois