Business Intelligence Developer- Onsite Required

Title: 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) Data Analyst 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 Data Analyst, 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

· Work with stakeholders to define business and systems requirements for information technologies, particularly in the areas of BI, analytics, and data warehousing.

· 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.

· 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.

· Conduct in-depth evaluations of various data sources and their associated business functions.

· Develop integrations for BI platforms with enterprise systems and applications.

· Design, code, test, and document all new or modified BI systems, applications, and programs.

· Develop the semantic layer, metadata, reports, and report definitions.

· Assist in the design of databases and data warehouses.

· Create models for new database development and/or changes to existing models.

· Monitor database system details within production systems, including stored procedures and execution time, and implement efficiency improvements.

· Analyze user requirements and based on findings, design functional specifications for BI front-end applications and analytical tools.

· Produce ETL design guidelines and maintain ETL pipeline processes to ensure a robust and manageable ETL infrastructure for BI systems.

· Provide and apply quality assurance best practices for data analysis services across the organization.

· Develop SQL queries and reports to meet the analytical needs of the business.

· 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.

Position Requirements

· 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

· 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.

· Strong understanding of relational database structures, theories, principles, and practices.

· Extensive knowledge of SQL, T-SQL, OLAP Cubes, data manipulation languages, and programming languages.

· Database Structure knowledge (Relational, Columnar, MongoDB, Hadoop).

· 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 MS Power BI, Sisense, Tableau, and MS SSRS

· Experience/exposure working with data lake concepts like Snowflake or Azure Synapse Analytics is a plus.

· Demonstrated ability to effectively leverage a variety of enterprise ETL/ELT tools on-premises and/or SaaS based.

· Experience working with Informatica, Azure Data Factory, Talend, pipeline solutions is a plus.

· 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 and configure MS Windows operating systems.

· Demonstrated knowledge of scripting languages such as VB, Python, and Java.

· Working technical experience with designing, building, installing, configuring, and supporting database servers

· 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.

· 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.

· Experience within the convenience and retail fuel industry is a plus.

· Highly self-motivated and self-directed.

Job Type: Full-time

Pay: $125,000.00 - $140,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Employee discount
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Parental leave
• Referral program
• Tuition reimbursement
• Vision insurance

Compensation package:

• Weekly pay
• Yearly bonus

Experience level:

• 6 years

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Worcester, MA 01606: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• Are you willing to work on-site 5 days a week in the Worcester Ma Support Center?

Experience:

• Implementing BI Development: 6 years (Required)
• SQL: 6 years (Required)
• Data warehouse: 6 years (Required)

Work Location: In person