Logo of Huzzle

Home

Matches

Explore

Manage

Sr Data Engineer (Hybrid in PHX, LA and Charlotte)

image

Sumitomo Mitsui Trust Bank Limited New York Branch

Aug 5

  • Job
    Full-time
    Senior & Expert Level
  • Phoenix

AI generated summary

  • You need solid database design, data warehousing, API/REST, and cloud experience (GCP, Azure, AWS). Familiarity with Java/C/C++, Docker, shell scripting, and Power Apps is essential.
  • You will design and maintain data pipelines, optimize database performance, ensure data quality, create Power BI reports, and collaborate within an Agile team while staying updated on industry trends.

Requirements

  • - Solid experience with Database design practices and data warehousing concepts.
  • - Experience with API/REST, JSON
  • - Experience in Banking and Financial Domains.
  • - Experience in Cloud environment like GCP, Azure and AWS.
  • - Familiarity with a variety of programming languages, like Java, JavaScript, C/C++.
  • - Familiarity with containerization and orchestration technologies (Docker, Kubernetes) and experience with shell scripting in Bash, Unix or windows shell is preferable.
  • - Experience with Power Automate and Power Apps.
  • - Education: Bachelor’s degree in computer science or information system along with work experience in a related field.

Responsibilities

  • Solid experience with Database design practices and data warehousing concepts.
  • Design, develop, and maintain data pipelines and ETL processes to extract, transform, and load data from various sources into our data warehouse.
  • Expertise with coding and implementing data pipelines in cloud-based data infrastructure in batch and streaming ETL using Data Factory, Spark, Python, Scala on Databricks.
  • Experience working with Google Big Query, Dataflow and Dataproc.
  • Optimize data ingestion and transformation processes to ensure efficient and scalable data flows, Monitor and optimize database performance, including query tuning and index optimization.
  • Develop and maintain data models, schemas, and data dictionaries for efficient data storage and retrieval.
  • Perform data analysis, data profiling, and data cleansing to ensure data quality and accuracy, data validation, quality checks, and troubleshooting to identify and resolve data-related issues.
  • Develop Power BI dashboards, reports, and visualizations to effectively communicate data insights. Implement data transformations, data modeling, and data integration processes in Power BI.
  • Create and maintain technical documentation related to database structures, schemas, and Reporting solutions.
  • Experience with MS office tools like excel, word, power point.
  • Experience working with build and deploy tools Azure DevOps, GitHub, Jenkins.
  • Experience working on an Agile Development team and delivering features incrementally.
  • Stay up to date with industry trends and best practices in data engineering, Power BI and proactively recommend and implement improvements to our data infrastructure.
  • Ability to multi-task, be adaptable, and nimble within a team environment.
  • Strong communication, interpersonal, analytical and problem-solving skills.

FAQs

What are the primary responsibilities of the Sr Data Engineer position?

The primary responsibilities include designing, developing, and maintaining data pipelines and ETL processes, optimizing data ingestion and transformation processes, performing data analysis, developing Power BI dashboards, and maintaining technical documentation.

What technologies and tools should candidates be familiar with for this position?

Candidates should have expertise in Database design, data warehousing concepts, cloud-based data infrastructure (especially Azure, GCP, and AWS), Data Factory, Spark, Python, Scala, Google Big Query, Power BI, and tools like Azure DevOps, GitHub, and Jenkins.

Is experience in the banking and financial domains required for this role?

Yes, experience in banking and financial domains is preferred for candidates applying for this role.

What educational qualifications are required for this position?

A Bachelor's degree in computer science or information systems along with relevant work experience in the field is required.

What is the anticipated salary range for the Sr Data Engineer role?

The anticipated salary range for this role is between $126,000.00 and $196,000.00, depending on individual qualifications and experience.

Does the company offer benefits in addition to salary?

Yes, SMBC offers a competitive portfolio of benefits to its employees in addition to cash compensation.

What kind of working environment does the Sr Data Engineer role offer?

The role offers a hybrid working environment with opportunities to work in-person and remotely in locations like Phoenix, Los Angeles, and Charlotte.

Are there opportunities for professional development in this position?

Yes, the company encourages employees to stay up to date with industry trends and best practices, offering opportunities to recommend and implement improvements to the data infrastructure.

Is there a preference for familiarity with programming languages?

Yes, familiarity with programming languages such as Java, JavaScript, and C/C++ is preferred.

How does the company handle equal employment opportunities?

The company is an equal employment opportunity employer and considers all qualified applicants regardless of race, color, religion, gender, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Sumitomo Mitsui Trust Bank Limited New York Branch

Finance
Industry
201-500
Employees
1925
Founded Year

Mission & Purpose

Sumitomo Mitsui Trust Bank, Limited (SuMi TRUST) was established through the merger of The Sumitomo Trust and Banking Co., Ltd. with Chuo Mitsui Trust and Banking, Ltd. and Chuo Mitsui Asset Trust and Banking Company, Ltd. on April 1, 2012. SuMi TRUST is Japan’s largest trust bank, with AUM of more than $800 Billion USD. SuMi TRUST provides an assortment of financial solutions and manages a broad spectrum of financial products across its global branches. The SuMi TRUST NY Branch manages a $35 Billion USD portfolio of corporate debt investments in the United States, with an emphasis on stable income generation, with decades of proven business success. Our areas of expertise include leveraged loans, CLOs, middle-markets, corporate bonds and project financing. SuMi TRUST continues to strive towards excellence and future growth with dedication to our employees and customers.