Data Engineer - Automated Cloud Warehouse - FinTech
Smiley Technologies Inc - little rock, AR
Apply NowJob Description
Job Type Full-time Description Summary The Advanced Data 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 lakes, and data migration Mainframe and DB2 experience a plus Linux/Unix experience a plus Strong technical aptitude and professional maturity Expert with ITIL, Agile, SDLC, and DevOps as a methodology Willingness to be On-Call and to work with different teams for rotations for the data catalog Expert in administration, security, API integration, creating reports, dashboards, and worksheets in Tableau (Preferred) or PowerBI Expert in handling large data volumes, deep understanding of data marts, data warehouse architecture, multidimensional databases, data lakes, and data migration Experience in Azure Stack - Synapse, Data Lake, Data Factory, Databricks, Stream Analytics, EventHub, etc. DevOps Mindset, Infrastructure as Code, and Data Ops for the data warehouse
Created: 2024-09-21