Business Analyst - On-site Position
Business Analyst - On-site Position
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Mesa Energy Systems is a wholly owned subsidiary of EMCOR Group Inc. EMCOR is the worlds leading provider of mechanical and electrical construction and facilities services including planning consulting and operations and maintenance. Mesa Energy Systems is a HVAC mechanical services company that provides fully integrated solutions for preventative maintenance and repair upgrading existing mechanical electrical and controls systems to provide the most efficient economic solutions to meet customer expectations.
Job Title: Business Analyst
Principal Duties and Responsibilities
- Develop improve and maintain financial operational and sales incentive reports models and dashboards.
- Assist in transition from Excel/CSV based data sources to SQL and Microsoft Fabric.
- Build out current Excel based reporting in Power BI.
- Gain expert level insight into the data flow between all systems to allow for data sharing and integration.
- Assist UX team with necessary financial/operational reporting needed for Power Apps.
- Publish periodic financial and operational reports creating commentary and insight and reporting on variances mix etc.
- Analyze data for trends exceptions and/or opportunities to assist in development of Key Performance Indicators (KPIs).
- Assist in improving efficiencies through simplifying and/or automating the financial and other reporting process.
- Work with Management and organizational units to identify and solve business system issues.
- Assist in the budgeting and forecasting process through reporting.
- Perform various duties and provide input concerning the design and improvement of business systems.
Job Specifications (incl. Education requirements minimal experience computer skills required etc.
- Bachelors degree in Finance or Accounting
- 4 years of on the job experience in financial analysis or data analysis resulting in actionable operational reports.
- Excel: Advanced Excel functions (e.g. Power Query dynamic arrays pivot tables XLOOKUP etc.
- Power BI: Advanced skills in transforming data and creating formatting and managing dashboards data models and reports. Must know DAX and M Code. Must be able to implement RLS in reports.
- SQL and/or MS Fabric: Knowledge of database querying relational models and management.
- Must be proficient with Microsoft applications.
- Must have strong quantitative and analytical abilities.
- Must have excellent oral and written communication skills.
- Must be collaborative and enjoy working with others.
As a leading provider of mechanical and electrical construction facilities services and energy infrastructure we offer employees a competitive salary and benefits package and we are always looking for individuals with the talent and skills required to contribute to our continued growth and success. Equal Opportunity Employer/Veterans/Disabled.
Compensation Range: $100000 $125000 per year
Benefits: We are committed to providing employees a comprehensive benefits package which includes medical dental and vision coverage along with health savings and flexible spending accounts life insurance disability a 401(k) Savings Plan College Coach and employee assistance program.
Notice to prospective employees: There have been fraudulent postings and emails regarding job openings. EMCOR Group and its companies list open positions here. Please check our available positions to confirm that a post or email is genuine.
#Mesa
#LImesa
#LIhvacjobs
#LIOnsite
Required Experience:
IC
Employment Type
Full-Time
