Bank of America is looking to develop and deliver complex data solutions to accomplish technology and business goals by integrating, cleaning, transforming, and controlling data in operational and analytical data systems.
Requirements
- Full Cloudera software stack experience in a 24x7 production environment
- 6+ years with Cloudera implementations
- Exceptional SQL development and performance tuning skills
- Experience architecting a large-scale production database platforms
- Expertise with Postgres system metrics and optimization strategies
- Familiarity with system level metrics and practical use of common Linux utilities
- Mastery of one or more of the following scripting languages: Python, Bash, etc
Responsibilities
- Codes complex solutions to integrate, clean, transform, and control data, builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management, assembles complex data sets, and communicates required information for deployment
- Leads documentation of system requirements, collaborates with development teams to understand data requirements and feasibility, and leverages architectural components to develop client requirements
- Leads testing teams to develop test plans, contributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies test issues and errors, and leads triage of underlying causes
- Leads work efforts with technology partners and stakeholders to close gaps in data management standards adherence, negotiates paths forward by thinking outside the box to identify and communicate solutions to complex problems, and leverages knowledge of information systems, techniques, and processes
- Leads complex information technology projects to ensure on-time delivery and adherence to release processes and risk management and defines and builds data pipelines to enable data-informed decision making
- Proactively monitoring database performance and troubleshooting issues
- Optimize queries, fix performance bottlenecks, improve existing schemas and design new ones
Other
- Leads story refinement and delivery of requirements through the delivery lifecycle and assists team members in resolving technical complexities
- Mentors Data Engineers to enable continuous development and monitors key performance indicators and internal controls
- Able to create various Cloudera Clustering configurations
- Creating and maintaining change control and testing processes, reviewing and approving database modifications
- Able to create enterprise backups and restore procedures
