IT Developer II - Business Intelligence

• Collaborate with Business and IT SMEs to articulate solutions while ensuring the business requirements are met.
• Perform Data profiling to identify and understand the data thoroughly before implementing a solution.
• Develop logic by writing T-SQL queries to create data sets on ad hoc basis based on requirements from business.
• Create reports and dashboards using reporting tools like Power BI/SSRS as per business requirements.
• Prepare Test plans and test cases for functional scenarios and perform testing effectively.
• Responsible for peer code review and provide improvements (if necessary).
• Responsible for creating a continuous improvement process, investigating problems, generating recommendations, and implementing solutions based on the use of reporting tools like Power BI and SSRS.
• Identify and implement process improvements making the organization more effective and efficient.
• Perform other duties as assigned including mentoring low-level peers.
• Ensure data security is enforced concerning all confidential information including but not limited to internal use and restricted information.
  
  

Job Qualifications/Requirements

Education/Credentials

• Minimum Education Level: Bachelor’s Degree
  
  

Prior Experience

• Minimum Job Experience: 2+
  
  

Technical Skills

• Language requirements: English Written, Advanced Verbal
• Computer/software skills: Microsoft Office 365 (Outlook, Word, Excel, Visio, Power point),
• Required:
• Writing functional specification documents and testing use cases.
• Expertise in writing T-SQL queries, stores procedures. Understand data optimization, query profiling and performance improvement.
• Good hands-on experience in data visualization tools like Power BI, Tableau etc
• Understanding of database management systems like Microsoft SQL Server, Oracle etc, online analytical processing (OLAP) and ETL (Extract, Transform and Load) framework.
• Experience in effectively translating concepts into non-technical terms to business owners in a clear and concise manner.
• Experience in managing project timelines and ability to effectively self-prioritize and execute tasks in a high-pressure, fast-paced environment.
• Strong interpersonal, presentation and relationship building skills.
• Exhibit strong desire to learn, adapt to new technologies and grow.
  

Preferred

• Any experience in Snowflake is a plus.
  
  

The salary range for this full-time position is $70,000.00 annually - $85,000.00 annually + bonus + benefits

Salary ranges are determined based on qualifications, level, and location.

Exact compensation may vary based on your skills and experience.

Bank of Hope is an equal employment opportunity employer and does not discriminate on the basis of race, color, gender, religion, age, sexual orientation, genetic information, national or ethnic origin, disability, marital status, veteran status or any other basis protected by federal, state, or local law.