RESPONSIBILITIES:

• Using Power BI, create dashboards and interactive visual reports.
• Recognize project requirements in the context of BI and create data models to transform raw data into relevant insights.
• Define key performance indicators (KPIs) with specific objectives and track them regularly.
• Analyze data and display it in reports to aid decision-making.
• Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis.
• Use Power BI to run DAX queries and functions.
• Create charts and data documentation with explanations of algorithms, parameters, models, and relationships.
• Construct a data warehouse.
• Use SQL queries to get the best results.
• Make technological adjustments to current BI systems to improve their performance.
• For a better understanding of the data, use filters and visualizations.
• Analyze current ETL procedures to define and create new systems.

REQUIREMENTS:

Minimum/preferred experience required for the position:

• 3+ years working with Power BI and DAX.
• 4+ years of experience working in an analyst role or related education.
• 4+ years of experience in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX.
• Strong experience in excel (pivots, formulas, and charts) to dissect preexisting stakeholder workflows.
• 2+ years of experience in EPC (Engineering, Procurement and Construction) Project environment is preferred.

Minimum/preferred knowledge, skills and abilities required of the position:

• Background with BI tools and systems such as Power BI.
• Prior experience in data-related tasks.
• Understanding of the Microsoft BI Stack.
• Be familiar with MS SQL Server BI Stack tools and technologies, such as SSRS and TSQL, Power Query, MDX, Power BI, and DAX.
• Analytical thinking for converting data into relevant reports and graphics.
• Capable of enabling row-level data security.
• Knowledge of Power BI application security layer models.
• Ability to run DAX queries on Power BI desktop.
• Proficient in doing advanced-level computations on the data set.
• Good communication skills are required to communicate with project team.
• Judgement, trust, and carefulness in handling sensitive and confidential information.
• Strong organizational and time management skills to prioritize workload during peak periods.
• Ability to identify and implement actions with minimum directions.

Required/preferred education:

• Bachelor’s in computer science, or information system, or engineering, or construction management, or business.

TRAVEL REQUIREMENTS:

Assignment in Houston may need to visit to project site during construction phase.

Work Environment

This position operates in a professional office environment with occasional work within or outside of a complex construction environment. This role routinely uses standard office equipment such as computers, phones, photocopiers/fax, filing cabinets, etc. This is primarily a sedentary role; however, the incumbent must be able to stand and/or sit continuously to perform all essential job functions for a full shift.

Able to meet the following physical demands of the job, with or without reasonable accommodations:

• Ability to lift up to 20 lbs. as required in order to lift files, boxes and office equipment as necessary.
• Ability to open filing cabinets and bending, standing on a stool, or climbing as necessary to perform these functions.
• While performing the duties of this role, the incumbent may be required to talk or listen.
• Vision abilities include close vision, distance vision, color vision, and the ability to adjust focus.
• The incumbent is required to stand, walk, use hands to handle or feel; and reach with hands and arms.
• Ability to move throughout all areas of each office/site location and facilities.
• Able to wear all necessary PPE equipment to perform job functions.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

ADDITIONAL INFORMATION:

• Communicates effectively at all levels of the organization to ensure clarity in expectations requirements, and deliverables. Excellent analytical skills.
• Team Player, good communication and reporting skills
• Welcomes working in a fast paced challenging and diverse entrepreneurial environment
• Hands-on type of personality
• This Position Description is not an exhaustive list of the duties and responsibilities, and the employee is expected to perform other duties as necessary and assigned. The duties and responsibilities of this position may be modified at any time to meet changing business needs.