Business Intelligence Developer

4 days ago


Worcester, United States firstPRO, Inc Full time

The Business Intelligence (BI) Developer is responsible for strategically designing, implementing, and maintaining BI software and systems, including developing integrations with databases, data lakes, and warehouses. This includes selecting, designing, and rolling out BI and reporting solutions to a wide variety of end users. This role is also responsible for ensuring high levels of system availability through support functions, and in-depth testing reporting systems as well as continuous optimization of data processes and technology.

As a Business Intelligence Developer, you will work closely with stakeholders in other departments to conduct needs analyses to identify, recommend, develop, implement, and support analytics solutions that deliver essential information and analytics to their teams. You will also tune production databases to ensure high levels of data availability and mine enterprise systems and applications for knowledge and information that enhance business processes.

Responsibilities

Requirements Analysis and Design

  • Work with stakeholders to define business and systems requirements for information technologies, particularly in the areas of BI, analytics, and data warehousing.
  • Identify, refine, and develop key BI metrics, reporting, and dashboards for various business roles and functions.
  • Evaluate and recommend BI solutions, and database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
  • Analyze user requirements and based on findings, design functional specifications for BI front-end applications and analytical tools.

Standards and Strategies

  • Assist in the development of data management policies, procedures, and corporate data strategy.
  • Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.

Data Engineering

  • Conduct in-depth evaluations of various data sources and their associated business functions.
  • Design of databases and data warehouses to support robust historical and correlative analyses.
  • Create models for new database development and/or changes to existing models.
  • Produce ETL design guidelines and maintain ETL pipeline processes to ensure a robust and manageable ETL infrastructure for BI systems.
  • Monitor database system details within production systems, including stored procedures and execution time, and implement efficiency improvements.
  • Provide and apply quality assurance best practices for data analysis services across the organization.
  • Develop integrations for BI platforms with enterprise systems and applications.

BI Development

  • Design, code, test, and document all new or modified BI systems, applications, and programs.
  • Develop the semantic layer, metadata, reports, and report definitions.
  • Develop SQL queries and reports to meet the analytical needs of the business.

Support

  • Troubleshoot, performance-tune, BI and database tools, systems, and software
  • Troubleshoot and update SQL routines as needed to account for changes in underlying data and needs of the business.
  • Promote BI usage to relevant departments.
  • Mentor and provide leadership to members of the team.
  • Design and deliver end-user training and training materials; provide technical support as necessary.

Perform other related duties as required and assigned.

Position Requirements

Minimum Qualifications

  • Bachelor’s degree in Computer Science, Data analytics, Information Systems, or Mathematics, and a minimum of 6 years of direct work experience implementing and developing BI solutions

Technical Experience

  • Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling for on-premise and SaaS deployments.
  • Proven experience in BI/data warehousing planning and development.
  • Database Structure knowledge
  • Strong understanding of relational database structures, theories, principles, and practices.
  • Extensive knowledge of SQL, T-SQL, OLAP Cubes, data manipulation languages, and programming languages.
  • Experience with data processing flowcharting techniques.
  • Experience with tier-one applications, databases, and data warehouse support.
  • Extensive experience implementing and maintaining Enterprise BI visualization tools such as Sisense, MS Power BI, Tableau, and MS SSRS
  • Experience/exposure working with data lakes such as Snowflake and/or Azure Synapse Analytics is a plus.
  • Demonstrated ability to effectively leverage a variety of enterprise ETL/ELT tools, either on-premises and/or SaaS based.
  • Experience working with CData, DBT, Azure Data Factory, and/or other pipeline solutions and tools.
  • Demonstrated knowledge of scripting languages (such as PowerShell and Python)
  • Working technical experience with designing, building, installing, configuring, and supporting database servers
  • Prior database administrator experience to provide routine maintenance such as recalculating statistics, log space clean out, index rebuilds, and performance tuning.
  • Demonstrated ability to manage, configure and optimize BI related aspects of Microsoft Windows Server operating systems.

Other Skills and Capabilities

  • Full project management and development life cycle experience.
  • Strong ability to conduct a need analysis to obtain and document user requirements.
  • Ability to break down and interpret key business data. Ability to analyze data, employ statistical concepts, and present recommendations based on that data.
  • Strong understanding of retail and/or fuel financial/business processes and associated analytics. Experience within the convenience and retail fuel industry is a plus.
  • Strong presentation, interpersonal, written, and oral communication skills.
  • Exceptional analytical, conceptual, and problem-solving abilities.
  • Able to prioritize and execute tasks in a high-pressure and agile environment.

Highly self-motivated and self-directed.



  • Worcester, Massachusetts, United States Nouria Full time

    Company OverviewNouria Energy Corporation is a multi-generational family-owned wholesale fuel distributor, convenience store operator, and car wash operator in New England. With over 300 locations across the region, we are ranked among the top 50 largest convenience store chains in the country. About the JobWe are seeking an experienced Business Intelligence...


  • Worcester, United States Nouria Full time

    Nouria Energy Corporation is a multi-generational family-owned wholesale fuel distributor, convenience store operator and car wash operator in New England. Our wholesale and retail fuel businesses are multi-branded, which includes Shell, Mobil, Irving, Sunoco, Gulf, Valero, Citgo, Phillips 66, Exxon, and multiple unbranded brands. Our wholesale operations...


  • Worcester County, United States firstPRO, Inc Full time

    firstPRO is now accepting resumes for a BI Developer role in Worcester, MA. This is a direct hire role and onsite 4 days per week.The Business Intelligence (BI) Developer role is responsible for strategically designing, implementing, and maintaining BI software and systems, including developing integrations with databases, data lakes, and warehouses. This...


  • Worcester County, United States firstPRO, Inc Full time

    firstPRO is now accepting resumes for a BI Developer role in Worcester, MA. This is a direct hire role and onsite 4 days per week.The Business Intelligence (BI) Developer role is responsible for strategically designing, implementing, and maintaining BI software and systems, including developing integrations with databases, data lakes, and warehouses. This...


  • Worcester, Massachusetts, United States The Hanover Insurance Group, Inc. Full time

    We are seeking a skilled Senior Business Intelligence Analyst to join our team at The Hanover Insurance Group, Inc. This is a key role that will provide critical support to our Data Scientists in designing, implementing, and evaluating advanced statistical models and applications for complex business issues.The ideal candidate will have a strong background...


  • Worcester, Massachusetts, United States University of Massachusetts Medical School Full time

    Unlock Business Potential with Data AnalysisAs a Data Analyst at the University of Massachusetts Medical School, you will play a pivotal role in transforming data into actionable insights that drive business decisions.We are seeking a highly skilled and motivated individual to join our team. If you have a passion for data analysis and a desire to make a...


  • Worcester, Massachusetts, United States Nouria Full time

    About Our CompanyNouria Energy is a leading wholesale fuel distributor, convenience store operator, and car wash operator in New England. With over 150 company-operated locations throughout the region, we are ranked among the top 10 largest car wash chains in the country.Job DescriptionWe are seeking an experienced Business Intelligence Developer to join our...


  • Worcester, Massachusetts, United States University of Massachusetts Medical School Full time

    About the PositionThis Data Analyst position at the University of Massachusetts Medical School requires a strong analytical mindset and excellent communication skills. As a key member of the NHPRR team, you will be responsible for collecting, analyzing, and interpreting complex data sets to inform business decisions and drive growth.The ideal candidate will...


  • Worcester, Massachusetts, United States Aramark Uniform Services Full time

    Job DescriptionWe are seeking a skilled and ambitious Territory Account Executive to join our team in the Worcester, MA area.The ideal candidate will have a minimum of 18 months of business-to-business sales experience, specifically focused on new account generation. They should be able to develop new business and generate sales leads within an assigned...


  • Worcester, Massachusetts, United States Venture Solar Full time

    Job OverviewVenture Solar is a leading provider of solar energy solutions, and we are seeking a talented Business Development Associate to join our team.The ideal candidate will have a proven track record in sales, with experience in outside sales and a strong understanding of the solar industry. We offer a competitive base salary plus uncapped commission,...


  • Worcester, United States Encompass Health Full time

    The Business Development Director is responsible for hospital inpatient and outpatient census in the IRF and/or LTCH and mix through the design and implementation of referral programs and customer service strategies. This position oversees inpatient admission process. The Business Development Director manages, trains and develops hospital-wide Business...


  • Worcester, Massachusetts, United States Commonwealth Electrical Technologies Full time

    Job DescriptionWe are looking for a Renewable Energy Business Developer to join our team at Commonwealth Electrical Technologies. As a Renewable Energy Business Developer, you will be responsible for identifying and pursuing business opportunities in the renewable energy space.You will work closely with our marketing and technical teams to develop business...


  • Worcester, Massachusetts, United States Amour Marketing Full time

    We are seeking an ambitious Business Development Manager to join our team at Amour Marketing. The successful candidate will have a strong work ethic and be eager to learn all aspects of operations.Key Responsibilities:Manage a team of 10-15 individuals, coaching and motivating them to deliver exceptional customer service and drive sales growth.Negotiate...


  • Worcester, Massachusetts, United States Full Potential Solutions Full time

    Unlock Your Full Potential with Our Exciting Sales OpportunityWe are seeking a highly motivated and results-driven Sales Business Development Manager to join our team at Full Potential Solutions. This is a fantastic opportunity for a sales professional looking to take their career to the next level.About UsFull Potential Solutions (FPS) is a leading...


  • Worcester, United States NTT DATA, Inc. Full time

    Req ID:306746NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Business Systems Analyst - P&C Insurance - REMOTE to join our team in Worcester, Massachusetts (US-MA), United States...

  • Account Executive

    7 days ago


    Worcester, Massachusetts, United States Manufacturing Inc Full time

    We are seeking an experienced sales professional to join our manufacturing team at Manufacturing Inc. The ideal candidate will have a proven track record of success in outside sales and a passion for building strong relationships with clients.OverviewManufacturing Inc is a dynamic and growing company that specializes in producing high-quality products. We...


  • Worcester, Massachusetts, United States Dental Team Finder Full time

    About the PositionThis is a unique opportunity for a skilled Sales Development Manager to join our team in Western Mass. You will be responsible for developing and executing a territory plan to grow existing customers and acquire new ones. You will work closely with Regional Managers to develop and implement coaching and development plans for optimal...


  • Worcester, Massachusetts, United States ICONSTAFF Full time

    Software development company ICONSTAFF offers an onsite position for a Robotics Simulation Software Engineer in Worcester, MA. The salary for this role is estimated at $120,000 annually.About the CompanyICONSTAFF has a passion for working with cutting-edge technologies and boasts a client list that includes NASA. The company has a great track record of...


  • Worcester, Massachusetts, United States Welcome Wagon Full time

    Company OverviewWelcome Wagon is a renowned company in the new mover marketing industry, with a rich history dating back to 1928. We specialize in welcoming new families into their homes by introducing them to local businesses.We are committed to making new movers feel welcome in the community, and we strive to achieve this goal through our innovative...


  • Worcester, Massachusetts, United States SterlingBridge Full time

    Grow Your Career with SterlingBridgeWe are looking for a highly motivated and experienced individual to fill the role of Commercial Lines P&C Account Executive. As a member of our team, you will be responsible for developing and implementing sales and marketing strategies to drive business growth and revenue. You will work closely with our clients to...