South Jersey Industries · 4 days ago
Business Intelligence Analyst III
Wonder how qualified you are to the job?
Energy
Insider Connection @South Jersey Industries
Responsibilities
Create and own documentation for Integration development standards and best practices
Design and develop BI integration solutions to populate Snowflake DB
Ensure integration environment security and availability
Complete functional specifications and translate to technical specifications for ETL/ELT development work
Provide performance tuning and enhancement of ETL/ELT processes
Maintain documentation for Batch, Real Time Jobs, and Affected Data Objects
Collaborate with Architect and Engineers to design integration reflecting business needs
Conduct code reviews to ensure ETL/ELT code quality
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Strong analytical skills with ability to design, develop scalable data integration and BI solutions
3-5 years of Information Technology experience with a strong focus on Data Warehousing, ETL, Enterprise Reporting and Dashboards
3-5 years expertise with complex SQL, views, materialized views, stored procedures and functions
3-5 years expertise on Stored procedures using Javascript or Python
3-5 years expertise with database solutions like Snowflake (3 years minimum), Oracle, SQL server
3-5 years working on Informatica Intelligent Cloud -(Cloud Data Integration)
3-5 years working with mass ingestion, Power Apps, Enterprise schedulers
3-5 years expertise with reporting solutions like Power BI, SSRS. Minimum of 3 years on Power BI
1-2 years experience with Python/Selenium
Strong ability to carry out assigned tasks independently with little supervision
Proficient with configuration of REST/SOAP API’s and parsing of XML/JSON data
Expertise in debugging & troubleshooting using IICS platform
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
Bachelor’s degree with 5 years of relevant experience, or Master’s degree with 3 years of relevant experience
An additional 4 years of experience may be considered in lieu of degree
Preferred
Utility domain Knowledge
Portal Development & support
3-5 years experience with Informatica Cloud Application Integration
3-5 years experience with Java , VB Script
Benefits
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.
Company
South Jersey Industries
South Jersey Industries is a publicly held energy services holding company for a natural gas utility and other, non-regulated companies.
Funding
Current Stage
Public CompanyTotal Funding
unknown2023-01-25Acquired· by The Infrastructure Investments Fund
1978-01-13IPO· nyse:SJI
Recent News
2022-10-31
2022-03-12
Company data provided by crunchbase