Business Intelligence Analyst II
Position Summary:
A career in Data Services at South Jersey Industries will provide the opportunity to design, develop, test, deploy, and monitor standardized or ad hoc reports, dashboards, or data requests. Additionally, this role develops and maintains report forms, layouts, formats, information dashboards, data generators, standardized reports, and other end-user access to data. The role involves working with our databases, data warehouses, queries, and scripts, and reporting information for end-users. This team member will also integrate data from multiple sources to produce requested or required data elements, metrics, KPIs, reports, or visualizations.
Location:
Folsom, NJ - Hybrid Schedule
Essential Functions:
- Develop and implement database objects (tables, views, stored procs, etc.), data integration routines, visualizations and reports
- Identify, analyze, and interpret trends or patterns in complex data sets
- Collaborate with the business and other IT colleagues to identify opportunities for improvement
- Establish KPIs and dashboards to measure the effectiveness of business processes
- Interpret data and analyze results using statistical techniques
- Resolve assigned tickets for user issues with reporting and data analysis
- Implement security on Power BI
Qualifications:
Required Skills:
- Technical expertise with data models, database design development, data mining, and segmentation techniques
- Talented with SQL (Oracle, SQL Server, Snowflake), ETL frameworks (Informatica, SSIS), and reporting solutions (Power BI, SSRS)
- Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, Python, SAS, etc.)
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
- Skilled at queries and report writing
- Interpersonal and written communication skills
Required Background:
- Bachelor’s degree with 2 years of relevant experience as a Data Analyst, Business Data Analyst, or similar; or Master's degree with 0-2 years of experience
- Equivalent work experience may be considered in lieu of degree
- 2 or more years of proficiency with the following: SQL on Oracle, SQL Server, or Snowflake; reporting solutions (Power BI, SQL Server); integration solutions (Informatica, SSIS); statistical packages using Python, SAS or similar; and data modeling
Explore the Possibilities:
South Jersey Industries employs a diverse range of talent – from construction contractors to environmental specialists. Regardless of the position, mentoring and networking, hands-on experience, gaining industry knowledge and the opportunity to make a meaningful impact on our business and in our communities are all exciting ways that we welcome our employees at SJI. And as a company committed to creating an engaging culture built on inclusion and diversity, you’re sure to find an opportunity that makes you feel included, empowered, and ready to “bring your whole self to work” every day.
Equal Opportunity/Affirmative Action Employer:
At this time, SJI is only considering applicants authorized to work in the United States currently and in the future without the need for visa sponsorship.
Benefits Package Overview:
SJI offers a competitive and comprehensive benefits package to eligible employees.
The SJI “Total Rewards” Benefits Package include:
- Flexible vacation, Paid Time Off, and Sick Leave package
- Comprehensive Health, Dental, and Vision Insurance
- Short-term and Long-term Disability Insurance
- 401(k), with generous company match
- Employee Resource Groups to encourage employee engagement, nurture professional development, and foster an inclusive environment.