Colliers Engineering & Deisgn is seeking a Power BI Analyst that will deliever business intelligent services and will tackle exciting challenges in colloborate teams. The primary responsibility of a Power BI Analyst is to lead the development of BI software, and generate Power BI reports. In essence, the role involves transforming raw data into organized and valuable reports that gather meaningful business insights. Offereing results-driven people a place where they can truly make a difference on a daily basis, this is an oppotunity you wont want to miss!

• Work as a Program Analyst/Power BI developer in Software Development Department.
• Perform tasks on Power BI desktop (Basic to Advance) like ETL (Extract Transform and Load), Manage Relationship and creating Visuals.
• Will establish logic and primary keys for table relationship in Power BI.
• Perform tasks independently using advance Power Query steps, DAX formulas, Measures etc.
• Keep track of various dashboards created and targets.
• Execute agile type of task under typical program/portfolio.
• Work on advance excel & Power BI to carry out any type of project analysis.
• Connecting various data sources to Power BI (SQL based BST, Files, SharePoint folder, Azure, or such databases).Analytical thinking for translating data into meaningful statistics & information.
• Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.
• Deployment of Dashboard and Maintenance of Power BI Services for internal clients. Handling Admin activities of Power BI workspace.
• Understand Power BI REST APIs to capture additional information that might be useful in understanding Colliers Power BI environment.
• A large emphasis will be on DAX formulas.
• Help to make BST BI data available in Power BI.
• Includes data validation, Power Query transformations, creating additional columns/measures, testing, etc.
• Developing and implementing data analyses, data collection systems, and other strategies that optimize statistical efficiency and quality of data.
• Acquiring data from primary or secondary data sources and partnering with a data warehouse team to maintain databases.
• Filtering and cleaning data to ensure accuracy.
• Creating visualizations and reports for internal and external stakeholders.
• Developing dashboards and other tools to help stakeholders understand key metrics.
• Documenting requirements for data visualizations.

• 3+ years of experience.
• Bachelor's degree in Computer Science or IT related field, or equivalent work experience and/or education.
• Data Visualization Tools (Tableau or Power BI).
• SQL Databases.
• Should have experience in Power BI advance.
• Power BI Certification preferred.
• Ability to identify patterns in large datasets.
• Interpreting results using statistical techniques and communicating findings effectively.
• Identifying, analyzing, and interpreting trends or patterns in complex data sets.
• Effective Verbal & Written Communication, Proactiveness & ownership attitude is required.
• Should be creative in terms of producing visuals and showing data in presentable format.

At Colliers Engineering & Design, our people are our most important resource. That's why we are committed to providing all our employees with a safe, comfortable work environment, potential for career advancement, and the ability to impact society through their projects as well as Company sponsored activities.

This dedication begins with supporting a work life balance through a generous compensation package that includes: company paid medical, dental, and vision coverage; paid pregnancy disability leave; short- and long-term disability insurance; life insurance; a company-matched 401(k)/Roth; paid time off that includes parental and military leave; employee referral and professional license bonuses and a straight time policy that compensates exempt employees for billable hours worked in excess of 40 billable hours within a work week.

We have also created an internal culture that provides the resources and technology needed to encourage personal and professional growth opportunities through reimbursement for education; a free in-house resource for hundreds of educational and self-enrichment courses; mentorship program; wellness program; Women's Organization and ongoing philanthropic opportunities.

Apply today to learn how you can join our team of professionals, so we can help you Accelerate Your Success!