Mears Group, A Quanta Services Company

At Mears, we believe in developing and retaining the best people in the industry and providing the best value services to our customers in the natural gas and electric industries.  We take pride in developing the infrastructure of our country by connecting people and resources.  As an industry leader over the last 65 years, we have built our reputation as a premier provider of services with a solid track record of performance, integrity and – above all – a commitment to safety, quality, and our people. 

 

IT Business Intelligence Developer / Analyst

The ideal candidate must be able to fluidly transition between handling SSIS packages, data analysis, while building reports and Dashboards. PowerBI is our preferred platform for Business Intelligence reports / Dashboards and we are looking for an experienced individual to join this team. Strong experience with SQL Server Reporting services or a similar reporting tool, experience in Power BI or similar tool is important. Mears IT is a hybrid cloud and on-prem environment and the ideal candidate must be comfortable with (or willing to quickly learn) Azure and AWS. Additionally, working in a team setting with developers who use DevOps, Scrum, and CICD is helpful. This position will report to IT Director.


What Do You Offer Us? 

  • 3+ years of experience in BI tools such as Reporting Services, PowerBI, or similar tools such as Tableau
  • 3+ years of experience in SSIS, SSAS, SSRS components of SQL Server.
  • 3+ yrs experience in building ETL data flows using SSIS, creating workflows / data mapping to extract or push data from / to SQL Server - design, develop, schedule, troubleshooting and monitoring.
  • Strong experience using PowerBI and SSRS with report designer, report manager and report server. Experience in developing Enterprise reports, drill down reports, linked reports and charts using PowerBI.
  • Proficient in making DAX queries in Power BI desktop.
  • Create dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Design, build and deploy BI solutions
  • Evaluate and improve existing BI systems
  • Experience with cloud platforms such as Azure and AWS EC2, S3 etc.
  • Good working knowledge of Microsoft SQL Server environment, query optimization, performance tuning of stored procedures is a big plus.
  • Good understanding of database environments, online analytical processing (OLAP) and ETL (Extract, transform, load) frameworks
  • Develop Cubes using SQL server Analysis Services (SSAS) and experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
  • Any experiencing in SQL tools will be helpful.
  • Translate business needs to technical specifications
  • Experience in writing complex SQLs and Stored procedures
  • Handling Dev and Prod environments and the promotion of code components between Dev & Prod.
  • Experience handling enterprise security requirements such as reporting hierarchy, regional hierarchy for reports and Dashboards will be helpful.
  • Experience working in a SOX compliant environment and keeping the environment compliant is a plus.

What We Offer You: 

  • Paid on-the-job technical and professional training 
  • Defined career path for future growth 
  • Competitive wages and industry-leading benefits including Retirement Plan

What is Required? 

  • Experience with Database on-Prem and in Azure, with data handling through the database gateway will be a plus.
  • Good familiarity with developing in a Microsoft technical environment, including Windows Server admin and SQL Database administration.
  • Familiarity with troubleshooting user requests and prioritizing the workload will be helpful.
  • The job requires working with Remote & distributed users across the US. Experience communicating with users via phone/MS Teams etc, understanding their requirements, following SDLC cadence to deliver project requests on time is plus.
  • Ability to work with off-shore teams is a preferred.
  • Ability to work in a fast-paced challenging environment - accountable for your own actions and able to take ownership of the BI environment, keep it healthy and also contribute for the improvement of DW & BI (Power BI) in the company.
  • Fluent in English with excellent written and verbal communication skills

Working Environment/Physical Demands:

General office physical demands which can include: the ability to sit, stand, stoop, kneel, bend and walk. The ability to lift or carry up to 25 pounds. The ability to sit for sustained periods of time. The ability to demonstrate the manual dexterity necessary to operate a keyboard, calculator, and/or typewriter.

Equal Opportunity Employer, including disabled and veterans.

To see other positions, click here.