Data Architect

Job ID: 26-20552Location: Irving, TXContact: Kumaresh PiyushContact Email: View email address on click.appcast.io Phone: 732 3595241Company: Mindlance LEAD DATA ENGINEER At U.S. Bank, we’re on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each person is unique in their potential. A career with U.S. Bank gives you a wide, ever-growing range of opportunities to Client what makes you thrive at every stage of your career. Try new things, learn new skills and Client what you excel at—all from Day One. Job Description *** is building a team to launch a new platform for BNPL and Point Of Sale Lending Products (Avvance). As a Lead Data Engineer/Architect, you will be responsible for big data/analytics projects that gather and integrate large volumes of data. Specializes in developing and programming methods, processes, and systems to consolidate and analyze unstructured, diverse big data sources to generate insights and solutions for client services and product enhancement. Acquires data from multiple data sources to perform analysis. Implements and validates predictive models as well as create and maintain statistical models with a focus on big data. Identifies, analyzes and interprets trends or patterns in complex data to provide answers to business questions as well as provide recommendations for action. Interprets data and analyzes results using various advanced statistical techniques and tools. Presents data and analysis in a clear and concise manner allowing the audience to quickly understand the results and recommendations and make data driven decisions. Collaborates with various partners to prioritize requests/needs and provide a holistic view of the analysis. Measures and monitors results of applied recommendations and present adjustments. Ensures all data acquisition, sharing and results of applied recommendations are compliant with company standards. Basic Qualifications Bachelor's degree in a quantitative field such as statistics, computer science, engineering or applied mathematics, or equivalent work experience Ten or more years of relevant experience Preferred Skills/Experience Strong experience in analytics, advanced analytics/statistics, predictive modeling, machine learning, data visualization Good experience and expertise in Synapse, Presto , Spark SQL , Druid , SuperSet Strong experience and expertise in Java, SQL and Azure Cloud technologies Prior experience in Azure Synapse Analytics, Azure Data Factory, SSIS, Azure Spark pool and building / managing large scale data warehouse is a plus Very knowledgeable in Apache Airflow Previous experience in building data products Understanding of machine learning techniques and algorithms Experience in python/R/SAS/SQL for data extraction, data mining, and predictive analytic Proficient understanding of algorithms, data structures, architectural design patterns and best practices Effective communication, presentation, leadership, problem-solving and analytical skills Is this a remote position? If not, what *** locations can a resource work and how many days a week will they be required to work onsite? We would prefer to start with this as a HUB based position. If we cannot get a good candidate pool, then we can explore Remote candidates. Can you please provide a summary of the project/initiatives which describes what’s being done? The Avvance Data & Analytics team is building a scalable data platform to support one of the bank’s complex B2B2C products. Today, the data lake operates on‐premises, integrating data across multiple systems that span the full merchant and consumer lifecycle. The team is actively migrating this platform to Azure to improve scalability, reliability, security, and long‐term extensibility. As the migration is completed, the focus shifts to scaling and maturing the platform—keeping data pipelines and transformations aligned with rapidly evolving product features, expanding data coverage, and strengthening data modeling and governance. The team will be enabling standardized analytics and self‐service reporting to support key business initiatives. The next phase of the roadmap includes integrating richer event‐level and behavioral data, improving platform reliability and automation, and building data science and machine learning use cases using Azure services and more. The Lead Data Architect / Engineer will play a critical role in shaping this post‐migration phase by driving architecture decisions, scaling the data foundation, and enabling advanced analytics on top of the modernized platform. What are the top 5-10 responsibilities for this position? (Please be detailed as to what the candidate is expected to do or complete on a daily basis) SQL Data analytics including ad-hoc SQL queries, data transformations, extraction script analysis, Synapse data layer analysis and planning What skills/technologies are required (please include the number of years of experience required)? SQL database and query analysis - 5+ years, Synapse data layering - 2+ years, Unix OS - 5+ years, Python 2+ years What skills/attributes are preferred (these are a desired, not required)? Team leadership and mentoring What does the interview process look like? o How many rounds? 2 - first technical with two panel members, second with Product/BL team o Video, phone, or in person? Video o How technical will the interviews be? First technical - potential hands on SQL skill evaluation ------------------------DO NOT EDIT BELOW THIS LINE, PLEASE INSERT JOB DESCRIPTION ABOVE--------------------------------- Designs and builds relational database models and defines data requirements to meet the business needs. Develops strategies for data acquisitions, archive recovery, and implementation of databases. Foster value creation from the use of the internal organization's data assets, as well as from the external data ecosystem. Source the value through envisioning data-enabled strategies as well as enabling all forms of business outcomes through analytics, data and analytics governance, and enterprise information policy. ESSENTIAL FUNCTIONS: ? Creates design principles and prepares technical and infrastructure architecture deliverables that meet business requirements and customer needs. ? Participates in product design recommendations that span the entire infrastructure framework. ? Develops logical and physical database models. Writes scripts and commands for data manipulation. ? Plans and conducts database unit and systems tests; monitors results and takes corrective actions. Monitors and resolves database performance, capacity, data integrity, and replication issues. ? Serve as a central point of access to data across the organization ? Drives prioritization of data requests, considering organizational goals and strategic plan ? Assists with evaluation, participation in, and management of comparative databases to reduce duplication and ensure maximum return on investment ? Responsible for data governance, ensuring accuracy, integrity, and consistency of data definitions across the organization when possible ? Sustains knowledge of current trends as it relates to data analytics ? Supports the gathering and interpretation of data; draws conclusions and formulates recommendations to assist in quality, safety and strategic initiatives ? Recognizes the strengths and weaknesses of various data sources; works with stakeholders to recommend utilization of specific data sources to most effectively capture desired information ? Communicate the benefits of the enterprise data architecture to various stakeholders in order to focus on meeting business and IT needs while assisting developers in the use of architecture ? Builds technical relationships with business, operations, and technical teams and leads design efforts that provides innovative solutions and complex architectures Shift: ['Azure', 'SQL, Synapse, Power BI, Oracle, Postgres, Python, Unix'] Start: ['AutoSys, DevOps understanding'] EEO: “Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”