Cloud BI Information Engineer - API Enablement Lead

Key Skills

Amazon RedShift, API, AWS, Azure, Big Data Technology, ETL/ELT technologies, SQL

Job Description

Produces reports utilizing databases and applications to provide information to business leaders. Reports may be in the form of standardized dashboards or customized views of data upon request. Ensures data pulled is consistent with business needs/requests.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

• Applies knowledge of the business to customize reports and deliver meaningful information. Reviews reports to identify data integrity issues and provides feedback to application/database administrators to ensure any issues are addressed. Answers questions from end-users of reports to provide additional context. Reporting may be focused on regulatory matters, operational metrics, and productivity metrics.
• Applies foundational knowledge to develop, optimize and maintain reports and dashboards. Analyzes information to recommend solutions to solve problems.
• Analyzes information to determine business needs from requests and implement effective technical solutions by providing problem analysis and resolution in a timely manner and explain and interpret complex, difficult, or sensitive information.
• Leads small projects and plays significant role in larger, more complex initiatives.

• Design, develop, test and implement solutions for self-service reporting architecture for modern business analytics using BI Tools , API Enablement and Common Semantic Model

• Assist in migrating and scaling from an on-premise to Cloud infrastructure and data footprint.

• Evaluate and Prototype next-generation tools in Truist environment for feasibility and functionality

QUALIFICATIONS

Required Qualifications:

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor's degree or equivalent and five years of related experience or an equivalent combination of education and experience
• Foundational understanding of applicable principles, practices, theories, and/or methodologies (e.g., information technology, project management, finance, risk management, etc.)
• Specialized knowledge of SQL, relational databases, ETL/ELT architecture and concepts, data integration concepts, big data concepts and reporting tools
• Previous experience in managing and planning projects. Effective verbal and written communication to provide information to others

Preferred Qualifications:

• 3+ years of hands experience with Modern BI tools like Microsoft Fabric , Sigma,etc and/or BI Semantic implementation

• 2+ years of hands on experience with Cloud data technologies like Snowflake, AWS Redshift, Azure Onelake

• Experience or exposure on building semantic models , SDK and/or API enablement

• Bachelor's degree and six years of related experience

• Banking or financial services experience

OTHER JOB REQUIREMENTS / WORKING CONDITIONS

Sitting

Constantly (More than 50% of the time)

Visual / Audio / Speaking

Able to access and interpret client information received from the computer and able to hear and speak with individuals in person and on the phone.

Manual Dexterity / Keyboarding

Able to work standard office equipment, including PC keyboard and mouse, copy/fax machines, and printers.

Availability

Able to work all hours scheduled, including overtime as directed by manager/supervisor and required by business need.

Travel

Minimal and up to 10%