Data Engineer II
-
IT/Tech
Job Description & How to Apply Below
Job Summary:
The Data Engineer II supports the Bank's business intelligence and enterprise reporting capabilities by designing, developing, enhancing, and maintaining reliable reporting and analytics solutions. The role partners with business and technology stakeholders to translate reporting requirements into actionable dashboards, operational reports, and governed data products using the Bank's business intelligence platforms, including SQL Server Reporting Services (SSRS), Tableau, and Oracle Business Intelligence Enterprise Edition (OBIEE).
This position is responsible for report development, data analysis, validation, troubleshooting, performance optimization, documentation, and production support to ensure that accurate, timely, secure, and consistent information is available to authorized users.
- Designs, develops, and maintains enterprise reporting solutions as a primary responsibility of the Data Engineer role.
- Supports the reporting and analytics needs of business units and internal stakeholders.
- Designs, develops, tests, deploys, and maintains enterprise reports, dashboards, visualizations, and analytics solutions using SSRS, Tableau, OBIEE, and other approved business intelligence tools.
- Gathers and analyzes business requirements and translates them into technical specifications, report layouts, data definitions, calculations, filters, prompts, and acceptance criteria.
- Develops and optimizes SQL queries, stored procedures, views, datasets, and reporting data sources that support accurate and efficient business intelligence solutions.
- Creates and maintains operational, management, regulatory, and ad hoc reporting solutions that meet established business, security, and governance requirements.
- Builds and supports SSRS reports, shared datasets, data sources, parameters, schedules, and subscriptions, including data-driven subscriptions, where appropriate.
- Develops and maintains Tableau dashboards and published data sources, applying effective visualization standards, calculations, filters, and performance optimization practices.
- Validates report results and reconciles data to authoritative sources; investigates and resolves data discrepancies, calculation issues, failed report executions, and production incidents.
- Monitors report usage, execution performance, refresh schedules, and distribution processes, and recommends improvements that enhance reliability, scalability, and user experience.
- Applies source control, peer review, testing, release management, and documentation standards throughout the business intelligence development lifecycle.
- Partners with data engineering, database, application, governance, security, and business teams to ensure reporting solutions leverage approved, reliable, and well-defined data sources.
- Maintains technical and user documentation, including data mappings, report specifications, business rules, support procedures, and knowledge transfer materials.
- Provides production support and responds to business inquiries related to report functionality, data interpretation, user access, and scheduled distribution.
- Promotes governed self-service analytics by educating users on available reporting capabilities, appropriate data usage, and approved enterprise reporting practices.
- Leverages AI-enabled capabilities to modernize enterprise reporting products and services by identifying opportunities to enable self-service reporting and near real-time business insights.
- Utilizes modern data preparation, integration, automation, and AI-enabled metadata management tools and techniques.
- Works with data science teams, business analysts, and other stakeholders to refine data requirements for strategic data and analytics initiatives.
- Proposes innovative and scalable data ingestion, preparation, integration, transformation, and operationalization techniques.
- Trains and mentors data scientists, data analysts, line-of-business users, and other data consumers on data preparation, integration, and pipeline development practices.
- Ensures that data consumers use provisioned data responsibly by supporting data governance, compliance, security, and data quality initiatives.
- Participates in evaluating, promoting, and curating analytical content for inclusion in the enterprise data catalog to support governed reuse.
- Serves as a data and analytics evangelist by promoting available data and analytics capabilities to business leaders and educating stakeholders on…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction