South Jersey Industries - Folsom, NJ

posted 3 months ago

Full-time - Mid Level
Folsom, NJ
1,001-5,000 employees
Utilities

About the position

South Jersey Industries (SJI) is seeking a Business Intelligence Analyst III to join our Data & Analytics team. This role is pivotal in designing, developing, testing, deploying, and monitoring both standardized and ad hoc reports, dashboards, and data requests. The successful candidate will be responsible for developing and maintaining report forms, layouts, formats, and information dashboards, as well as ensuring end-user access to data for analytical purposes. The position requires working with databases, data warehouses, queries, and scripts to report information effectively for end-users. The Business Intelligence Analyst III will own the development standards and ensure the quality of all ETL/ELT routines developed for the Data Warehouse. This role also involves managing the operations of our integration platform, troubleshooting data-related issues using SQL and other integration monitoring tools, and maintaining data-related documentation. The analyst will create requirements and specifications for reports based on business requests and will be responsible for installing and maintaining Informatica IICS agents on both Linux and Windows platforms. This is an individual-contributor role with high visibility that will also require production support and maintenance. Essential functions include building and maintaining data pipelines using IICS/Snowflake, integrating various sources into Snowflake for model validation and deployment, supporting the deployment and monitoring of AI/ML models in production, and implementing best practices for utilizing Cortex and other Snowflake functions. The analyst will partner with users and analysts to complete functional specifications and translate them into technical specifications for development work, while also maintaining documentation for all routines developed.

Responsibilities

  • Design, develop, test, deploy, and monitor standardized or ad hoc reports, dashboards, or data requests.
  • Develop and maintain report forms, layouts, formats, and information dashboards.
  • Integrate data from multiple sources to produce requested data elements, metrics, KPIs, reports, or visualizations.
  • Own development standards and ensure the quality of all ETL/ELT routines developed for the Data Warehouse.
  • 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 into 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.

Benefits

  • 401(k) matching
  • Dental insurance
  • Disability insurance
  • Paid time off
  • Vision insurance
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service