Data Engineer

Senior Data EngineerThis job is responsible for driving data engineering efforts to deliver enterprise-wide capabilities and complex data solutions. Key responsibilities include directing code design and delivery tasks associated with the integration, cleaning, transformation, and control of data in operational and analytical data systems and working with the Project Management team to define outcomes and inform work structures. Job expectations include providing technical thought leadership by implementing complex data solutions and interactions across multiple systems and domains.Is there additional variable compensation: YesYearly Base Salary Range: $140000-$160000Other Job Locations:Charlotte, NCDallas, TXEast Hartford, CTProvidence, RIStamford, CTWilmington, DEResponsibilities:The Corporate Audit and Credit Review (CACR) analytics & automation team delivers data-driven, risk-based insights and automation solutions to the CACR organization. The Senior Data Engineer role will be responsible for developing and implement a range of analytics and automation solutions, including data extraction, analysis, reporting, and dashboard design, but could include more advanced analytics including statistical analysis, text mining & NLP, and modeling/machine learning/AI. This role demands interaction with highly experienced audit and/or credit professionals, data experts and technology. Intellectual curiosity will drive critical thinking to produce optimal solutions. Strong time management, coordination, communication, and presentation skills are a must in this role.Assembles large, complex data sets that meet functional and non-functional requirements, ensuring that the design and engineering approach is consistent across multiple systems.Maintains, improves, cleans, and manipulates large data for operational and analytics data systems, builds complex processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management, and communicates required information for deployment, maintenance, and support of business functionality.Utilizes multiple architectural components in the design and development of client requirements and collaborates with development teams to understand data requirements and ensure the data architecture is feasible to implement.Defines and builds data pipelines to enable data-informed decision making, ensuring adherence to release processes and risk management routinesContributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies any test issues and errors, and leads triage of underlying causes.Leads the identification of gaps in data management standards adherence and works with appropriate partners to develop plans to close gaps, leading concept testing and conducting research to prototype toolsets and improve existing processes.Mentors Data Engineers in the delivery and release of continuous integration and continuous delivery events and defines key performance indicators and internal controls.Utilizes sound, seasoned analytical skills to independently develop analytics & automated testing solutions using a variety of tools (Alteryx, Tableau, etc.) and programming languages (SQL, SAS, Python, etc.)Supports the design and execution of new analytics, automated testing tools, and models.Responsible for multiple projects simultaneously, ensuring each one is completed on time and efficiently with a high standard of work.Coordinates, schedules, scopes, and leads large, cross-functional analytics & automation activities.Exercises judgment, critical thinking, and sound communication skills to influence business partners.Coaches/trains junior team members in execution of analytics and automation activities.Managerial Responsibilities:This position may also have responsibilities for managing associates. Here all managers at this level demonstrate the following responsibilities, in addition to those specific to the role, listed above.Diversity & Inclusion Champion: Models an inclusive environment for employees and clients, aligned to company D&I goals.Manager of Process & Data: Demonstrates deep process knowledge, operational excellence and innovation through a focus on simplicity, data-based decision making and continuous improvement.Enterprise Advocate & Communicator: Communicates enterprise decisions, purpose, and results, and connects to team strategy, priorities and contributions.Risk Manager: Ensures proper risk discipline, controls and culture are in place to identify, escalate and debate issues.People Manager & Coach: Provides inspection, coaching and feedback to motivate, differentiate and improve performance.Financial Steward: Actively manages expenses and budgets in alignment with objectives, making sound financial decisions.Enterprise Talent Leader: Assesses talent and builds bench strength for roles across the organization.Driver of Business Outcomes: Delivers results by effectively prioritizing, inspecting and appropriately delegating team work.Skills:Analytical ThinkingApplication DevelopmentData ManagementRisk ManagementSolution DesignAgile PracticesArchitectureCollaborationDecision MakingDevOps PracticesBusiness AcumenData Quality ManagementFinancial ManagementSolution Delivery ProcessTest EngineeringRequired Skills:Intermediate to advanced knowledge of one or more of the following: SQL, SAS, Alteryx, Python, Tableau or related tools.Advanced skills in Microsoft Excel.Advanced analytic skills that demonstrate the ability to navigate systems, access data, reconcile numbers from different sources, identify discrepancies and trends, and understand drivers of changes within dataStrong track record of implementing automated solutions related to data & analytics, including the ability to extract, organize, and present the data in user-friendly reports, dashboards or tools.Ability to work both independently or in teams on multiple projects simultaneously to deliver timely and complete solutions under minimal supervision.Strong written and oral communication skills, with ability to communicate with both technical and executive audience.Desired Skills:Experience with one or more of the following as plus: model development, machine learning/artificial intelligence (AI), and data scienceExperience with one or more of the following a plus: DataRobot, Instabase, and UIPath.