Hotline: 404-491-0865

Business Intelligence Developer

**THIS JOB REQURES THE CANDIDATE TO REPORT TO OUR CORPORATE OFFICE, MELBOURNE, FL – IT IS NOT REMOTE**

About Us: CMS/Nextech is a world-class commercial HVAC/R service provider. We started over 20 years ago with just one truck and since then, became the largest nationwide HVAC/R contractor! There are currently 16 operational locations and are operating and providing services in every state throughout the United States. Come join our growing company!

Summary: The Business Intelligence Developer will be responsible to build and maintain data intelligence systems. The candidate will be in charge of all aspects of the intelligence stack including data analytics, report and dashboard creation, data warehouse creation and maintenance. This position will be part of a team that designs, develops, and maintains multiple applications that supports CMS/Nextech and its customers.

Job Responsibilities:

  • Work with executive management and department heads to define and build data analytics
  • Work with current DevOps team to ensure consistency in relating data to end users
  • Perform daily maintenance of the OLAP and data warehouses.
  • Modify and maintain SSAS databases and schedules
  • Analyze data for data integrity and accuracy
  • Create data warehouse databases, cubes, and OLAP systems.
  • Create reports and dashboards utilizing Power BI, SSRS, and mobile reports
  • Work with Developers to create dashboards and reports for inhouse applications
  • Maintain revisions of BI reports
  • Research and debug issues with BI reports and systems.
  • Work independently to fine-tune, advance, and design data analytics
  • Always be looking for a better way to report and convey analytics to end users
  • Define better ways to look at data to improve understanding.
  • Qualifications:

  • Experience with Microsoft products SQL Server, SSMS, Power BI, SSRS, SSIS
  • Experience with coding with T-SQL, Views, and Stored Procedures
  • In-depth understanding of T-SQL, DML, and DAX languages
  • Experience in Query Performance tuning
  • Ability to create advanced SSRS reports.
  • Ability to build Power BI reports and Dashboards from scratch.
  • Experience with Data warehousing creation and maintenance tools (OLTP / OLAP), SSMS, SSAS, Query Analyzer, SQL Profiler, Query Optimizer and Execution plans.
  • Understanding of SSAS databases, creation, partitioning, and data loading
  • Ability to understand data structure by researching current data systems
  • Strong critical / analytical thinking and problem-solving skills
  • Ability to multi-task and thrive in fast paced, rapidly changing and complex environment
  • Ability to learn new skills quickly and apply these skills to a production environment
  • Job Type: Full-time

    Benefits:

  • 401(k) matching
  • Dental insurance
  • Health insurance
  • Life insurance
  • Paid time off
  • Vision insurance
  • Schedule:

  • 8 hour shift
  • Day shift
  • Monday to Friday
  • Ability to Commute/Relocate:

  • Melbourne, FL (Preferred)
  • Education:

  • Bachelor’s (Preferred)
  • Experience:

  • Creating data warehouse databasees: 3 years (Required)
  • Create dashboards using Power BI or SSRS, or Mobile reports: 3 years (Required)
  • Work Location:

  • One location
  • Company’s website:

  • https://www.cmsmechanical.com/
  • Work Remotely:

  • No
  • Email Me Jobs Like These
    Share this job

    Contact Us

    Eltas EnterPrises Inc.
    3978 Windgrove Crossing
    Suite 200A
    Suwanee, Georgia
    30024, USA
    contact@eltasjobs.com

    NOO Mailchimp Widget require active plugin MC4WP: Mailchimp for WordPress.