Data Engineer - III

Pay Range: $90/hr - $100/hr on W2. Qualifications:Job Profile SummaryThe Data Engineer designs and develops data pipelines (data ingestion and extract, transform, load processes) that are scalable, repeatable, and secure for stakeholder needs.This position is considered intermediate level and performs work of moderate-complexity. The incumbent works under general supervision and may take direction from a more senior team member. This job does not have any direct reports.Job DescriptionPRINCIPAL DUTIES AND RESPONSIBILITIES • Creates data management strategies to support business intelligence efforts for various stakeholders. • Builds out data architecture to support data strategy. • Performs the design of logical data model and implements the physical database structure. • Ensures the quality, security, and reliability of data and analytics systems and software across the organization is being followed and troubleshoots any issues that may arise. • Constructs and implements operational data stores and data marts. • Provides support for deployed data applications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution. • Creates real-time and batch enable, transform, load (ETL) data processes aligned with business needs. • Supports optimization of data pipelines by reducing complexity, improving readability and increasing performance. • Builds technical requirements relative to their respective domain and applicable applications, solutions, and/or systems. • Augments data pipelines from raw Online Transaction Processing (OLTP) databases to data solution structures. • Performs design reviews regarding code, tables, and databases regarding the overall architecture of the data warehouse. • Documents data flow diagrams, security access, data quality and data availability across all business systems. • Develops and maintains a query library to support recurring data requests.EDUCATION AND EXPERIENCE • Bachelor's degree in a related field, or commensurate specialized training, certification, or work experience • Minimum one year of work experienceKNOWLEDGE AND SKILLS • Intermediate understanding of data warehouse technical architectures and extract, transform, load (ETL) or extract, load, transform (ELT) processes • Intermediate knowledge and experience with data warehouse design, data modeling, and data processing pipelines • Knowledge of scripting languages • Intermediate knowledge and understanding of big data tools and software • Familiar with Continuous Integration (CI) and Continuous Delivery (CD) tools and pipelines • Intermediate knowledge of cloud-based data platforms Intermediate understanding of data security and privacy regulations • Intermediate understanding of software development lifecycle (SDCLC) and Agile methodologies • Intermediate critical thinking and decision-making abilities • Strong written and verbal communication skills • Excellent attention to detail Job Profile NameData AnalystJob Profile SummaryPlays a key role in the department's data analytics by designing and implementing processes to inspect clean transform and model data to Client useful information, inform conclusions, and support decision making.Provides strategic thought leadership around the department's goals pertaining to data collection, analysis, reporting tools and best practices. Contributes significantly to and seeks out opportunities to lead department, Bank, and System workgroups and committees and as well as local and Client System-wide projects and initiatives.Essential Accountabilities • Works independently, with guidance only in the most complex situations, to make sound decisions. Exercises considerable latitude when determining the objectives of assignments. Work is generally reviewed for desired results. • Leads the development of solutions to complex problems. Solutions are imaginative, thorough, practical, and consistent with functional objectives and keep the customer in mind. • Considered an expert in the data analytics discipline and applies that knowledge through work products. • Responsible for more complex activities associated with data analytics and may assist less experienced staff. • Leads the development and refinement of analysis, reports, and dashboards of key department performance and risk indicators. • Leads and may assist less experienced staff in visualizing and reporting data findings creatively in a variety of visual formats (i.e. reports, dashboards, etc) that meet Bank and business function needs. • Leads and may assist less experienced staff in telling stories” with data for both technical and non-technical audiences that meet Bank and business function needs. • Leads the research and analysis needed to respond to surveys and requests for information from key stakeholders. • Leads and may assist less experienced staff in translating departmental scenarios and requirements into technical specifications. • Identifies best practices and standards in data analysis and visualization and leads their implementation in the department. • Influences strategy by either managing or facilitating district or System data analytics-related initiatives. • Establishes and maintains effective relationships with business functions and other stakeholders to understand data analysis and visualization needs to ensure data strategies support business goals. • Leads the development of training resources and delivers them to stakeholders. • Leads the development of new processes, standards, and operational plans at the Department-level.Job Description • Seeks out opportunities to lead projects/initiatives/workgroups in the department, Bank, and/or System. • Completed a leadership training / development program. • Performs other duties as assigned or requested.Education & Experience • Bachelo's Degree and 7 years of related work experience OR • Master's degree and 5 years of related work experience • Related certification, active participation in an industry organization, or advanced degree requiredKnowledge & SkillsKnowledge Areas - Expert Level • Business Operations / Business Acumen • Project Management • Data analysis tools (i.e. SQL, SQL Server, Tableau, ACL, PowerBI) • Data visualization and modeling • Microsoft Office 365 application (Teams, Excel, PowerPoint, Word, etc.)Skill Areas - Expert Level • Action Oriented • Collaborates • Communicates Effectively (with influence) • Customer Focus • Ensures Accountability • Values Differences • Drives Results • Manages Complexity • Critical Thinking and Judgement • Relationship building • Embraces changes and innovation