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 supply branded and unbranded fuel to 300+ locations across New England and New York. We are ranked within the top 50 largest convenience store chains in the country, operating 150+ company-operated locations throughout New England and ranked within the top 10 largest car wash chains in the country

Business Intelligence Developer

Nouria Energy is a fast-growing family-owned company that is transforming into a data-first organization with aims to empower employees to effectively leverage data to not only make more insightful business decisions but also streamline operations and propel our business.

Description
 

The Business Intelligence (BI) Developer role at Nouria Energy 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 softwareTroubleshoot 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 knowledgeStrong 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 SSRSExperience/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 serversPrior 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.

Nouria Energy is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.