FirstBank Jobs

This job was posted by https://www.arjoblink.arkansas.gov : For more information, please see: https://www.arjoblink.arkansas.gov/jobs/4238090 Description:

Summary

The Advanced Data & Analytics Architect participates in the design, implementation, and support of Smiley\'s transactional and dimensional data warehouse development efforts, providing guidance and direction to clients and project team members. The Advanced Data & Analytics Architect interacts with all levels of technical and business resources to meet operational and strategic reporting and analytical needs.

• Provide warehouse design, architecture, reporting, analytics, implementation, and integration efforts that include data sourcing and transformation.
• Help define the process to ensure that the client\'s business goals and objectives are met by the proposed data warehouse architecture and design.
• Leverage knowledge of current data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.

Responsibilities

• Support database development and requests in MS SQL Server and DB2
• Develop conceptual, logical, and physical data models
• Design and develop new data structures in online transaction (OLTP) and data warehouse (OLAP) databases
• Build and maintain ETL SSIS packages (Current need in SSIS, but Azure Data Factory experience preferred)
• Perform impact analysis on data structure changes
• Define and enforce database standards including sensitive personally identifiable information (SPII), Payment Card Industry Data Security Standard (PCI DSS), and data security compliance
• Review SQL for performance improvements
• Manage automated database job schedules
• Support global metadata data dictionary repository
• Identify logical issues between database models and reports
• Follow change management procedures
• Manage Database project changes with GIT branching and integrations
• Provide cross-training and mentor other team members as needed
• Provide after-hours support based on the on-call rotation
• Support infrastructure changes as needed
• Advise on new technology trends and possible adoption to maintain a competitive advantage
• Other duties as assigned

\

Requirements:

Required Education and Experience

• A Bachelor of Science Degree or Master\'s Degree in Computer Science or a related technical discipline is required

Required Knowledge, Skills, and Abilities

Expert with OLAP dimensional database design

Advanced SQL programming background

Expert in creating reports and dashboards in industry-standard tools, Tableau (preferred), PowerBI, SSRS

Expert experience with MS SQL Server and SSIS/Azure Data Factory

Knowledge of the software development lifecycle including systems analysis, design, development, testing, and deployment

Expert in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools

Strong communication skills including facilitation, presentation, and documentation

Ability to capture and transform business requirements into functional and data specifications

High level of initiative, self-starter, flexible, proactive, and a team player

Expert in handling large data volumes

Deep understanding of data marts, data warehouse architecture, multidimensional databases, data\ \

PI242591658

\ \ Smiley Technologies, Inc is an Equal Opportunity Employer and does not discriminate against any applicants for employment based on their race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, physical or mental disability, genetic information, veteran status, uniformed service member status, r any other status protected by law.