BUSINESS INTELLIGENCE- POWER BI AND SQL

basic qualifications

• Bachelor's degree BSCIS/BSCS/ BSCE or relevant experience.
• 2+ years of experience developing reports and analytical dashboards using PowerBI or SSRS and SQL.
• Demonstrated understanding of data analysis and relational data models.

Essential job functions

Essential activities include but are not limited to:

• Design and develop new solutions that satisfy the objectives stated in the business requirements; follow industry best practices, techniques, and ITS Logistics standardized processes to deliver improved data analytics solutions
• Evaluate and select process and logic patterns, data storage methods, and operating environment interfaces that effectively satisfy required business KPIs and metrics
• Collaborate with the solutions team in the deployment/implementation of data analytics solutions
• Introduce new industry standards and techniques that deliver improved business intelligence solutions; evaluate new technologies for inclusion in developed solutions
• Certify the proper functioning, data accuracy and performance of components using repeatable, reproducible, and reportable testing methodologies; support data architecture by identifying and diagnosing data problems
• Become intimately familiar with our business model and processes to influence the strategy and direction of product development
• Interact daily with coworkers and leadership
• Develop advanced queries, views and stored procedures using MS-SQL

Understand dimensional modeling concepts and design patters for enterprise data warehouse structures