Business Intelligence Analyst III

South Jersey Industries - Folsom, NJ

Full-time - Mid Level

Folsom, NJ

1,001-5,000 employees

Utilities

About the position

South Jersey Industries (SJI) is an energy holding company that delivers clean energy services to over 700,000 customers and businesses throughout 14 counties in New Jersey. As part of our core values, SJI is dedicated to being a community partner and developing innovative clean energy solutions to meet the needs of the future. To do this, we depend on our workforce of over 1,100 talented, diverse employees who help us deliver safe, reliable, affordable clean energy for a better today and tomorrow. At SJI, we believe that our employees are our most valuable asset. Whether you're a seasoned operations technician or an early-career legal professional, our culture, inclusive workforce, and leadership development and training programs will provide you with the tools you need to either kickstart your career or bring it to new heights. The Business Intelligence Analyst III position is a critical role within our Data & Analytics team. This position provides the opportunity to design, develop, test, deploy, and monitor standardized or ad hoc reports, dashboards, or data requests. The analyst will be responsible for developing and maintaining report forms, layouts, formats, information dashboards, data generators, standardized reports, and other end-user access to data for analytical purposes. This role involves working with databases, data warehouses, queries, and scripts, and reporting information for end-users. Analysts will also integrate data from multiple sources to produce requested or required data elements, metrics, KPIs, reports, or visualizations. In this role, the Business Intelligence Analyst III will own development standards and be responsible for the quality of all ETL/ELT routines developed for the Datawarehouse. The analyst will also manage the operations of our integration platform, troubleshoot data-related issues using SQL and other integration monitoring tools, and maintain data-related documentation. Additionally, this role will create requirements and specifications for reports based on business requests and install and maintain Informatica IICS agents on Linux and Windows. This is an individual-contributor role with high visibility that will also require production support and maintenance.

Responsibilities

• Design, develop, test, deploy, and monitor standardized or ad hoc reports, dashboards, or data requests.
• Develop and maintain report forms, layouts, formats, information dashboards, data generators, and standardized reports.
• Integrate data from multiple sources to produce requested or required data elements, metrics, KPIs, reports, or visualizations.
• Own development standards and ensure the quality of all ETL/ELT routines developed for the Datawarehouse.
• Manage operations of the integration platform and troubleshoot data-related issues using SQL and other monitoring tools.
• Create requirements and specifications for reports based on business requests.
• Install and maintain Informatica IICS agents on Linux and Windows.
• Build and maintain data pipelines using IICS/Snowflake.
• Support deployment and monitoring of AI/ML models in production.
• Implement best practices for utilization of Cortex and other Snowflake functions.
• Partner with users and analysts to complete functional specifications and translate them to technical specifications for development work.
• Maintain documentation for all routines developed.

Requirements

• 3-5 years of experience in data engineering with significant focus on Snowflake.
• 3-5 years expertise with complex SQL.
• 3-5 years expertise on stored procedures using Javascript or Python.
• 3-5 years experience supporting AI initiatives in a data engineering or data scientist role.
• Proficiency in Pandas, Pyspark, Snowpark ML.
• Knowledge of Snowflake Cortex LLM functions and statistical modeling.
• Proficient with configuration of REST/SOAP APIs and parsing of XML/JSON data.
• Strong ability to carry out assigned tasks independently with little supervision.
• Extensive experience with data warehousing concepts and performance optimization.
• Extensive experience in ETL/ELT tools, IICS platform is a plus.
• Proactive with a can-do attitude and willingness to learn new technologies.
• Excellent communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams.

Nice-to-haves

• Utility domain knowledge.
• Certification related to Snowflake, AI/ML.
• 3-5 years experience with Informatica Cloud Application Integration.
• 3-5 years experience with Java, VB Script.