Position: Business Intelligence Engineer /Business Intelligence Developer
Company: IVIA
Experience required: 3y
English level: upper

Job Description: 
The Business Intelligence Engineer (BI Engineer) will play a critical role in bringing data and intelligence into the decision-making process across Omni Logistics, on both day-to-day tactical issues as well as big-picture strategic matters. We are a Power BI shop that relies on accurate and timely data produced in a variety of systems associated with our various business units, regions, and newly acquired businesses. The BI Engineer will be responsible for the key data flows and connections between our data warehouse, enterprise data model, and Power BI interface. This includes redesigning our existing enterprise data model to optimize BI performance and enhance reporting capabilities. On an ongoing basis, the BI Engineer will be the go-to expert for Omni’s key operating systems, and their interface with our data warehouse and Power BI.
 
Position Responsibilities and Duties:

- Become a subject matter expert on the organizations Operational and BI systems, processes, and reporting solutions in order to facilitate streamline development and growth within the BI environment
- Redesign, document, cleanse and optimize current Enterprise Data Model.
- Create and maintain Data dictionary
- Continued management and expansion of Data models and Data flows
- Work With the data warehouse team to enhance and expand the models.
- Design and deploy self-service service models using Power BI
- Create detailed logical models identifying all the entities, attributes and their relationships along with the characteristics associated with each of those.
- Management of row level and object level security within the data models
- Continuously monitor, tune and develop best practices around maximizing existing applications under the BI umbrella
- Expertise in creating Power BI reports and visualizations that tell a useful story to senior management.
- Manage and fulfill ad hoc information requests submitted to the BI team
- Organize and plan all facets of application upgrades within the BI ecosystem
- Articulating modelling principles to other modelers and business users.
- Support design and develop high-performance data visualizations, reports and dashboards utilizing Power BI or other analytics-focused tools, including the structuring of complex problems
- Use advanced statistical methods to analyze data and generate useful business insights, including algorithms such as clustering, time series, classification, and other machine learning approaches 

Required Qualifications:

- 5+ years’ experience designing business intelligence reporting solutions to include Entity Relationship Models, Star Schema, Dimensional Modeling, and other Data Modeling Techniques and Methodologies
- Advanced Proficiency in data modeling including both the design and implementation of tables, views, and stored procedures within a AAS and Power BI Environment
- Advanced Proficiency in data analytics, including – but not limited to – Power Query, Dax, SQL scripts, and Microsoft Suite tools
- Advanced capabilities
- Demonstrated ability to anticipate and manage change in a highly dynamic environment
- Strong analytical and problem-solving skills.
- Proven track record of managing and executing projects from start to finish, including project management, data gathering and modeling, problem solving and communicating recommendations to internal or external clients
- Excellent communication skills, and proven experience in working with business stakeholders to extract and document requirements. 

Preferred Qualifications:
- 3+ years of experience at a logistics environment and demonstrated knowledge of the industry’s dynamics
- Proficiency in data analytics, including – but not limited to - SQL, R , and Python scripts, ML, Regression