Fisher Investments

Data Engineer

Fisher Investments

full-time

Posted on:

Origin:  • 🇺🇸 United States • Washington

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $110,000 - $160,000 per year

Job Level

SeniorLead

Tech Stack

AzureCloudETLInformaticaITSMKafkaMS SQL ServerNoSQLOraclePythonScalaSparkSQLSSISVault

About the role

  • The Data Engineer is an enterprise expert for designing, developing, and optimizing data processing systems and pipelines used to populate data into transactional databases, data warehouses, data marts, or other data repositories.
  • You will build systems to create and improve data sets and data systems for operating applications, performing analysis, or identifying business or technology issues.
  • Responsible for operational support and incident/problem management, from creating logging instrumentation to analysis and process improvements.
  • Coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems.
  • Report to the Business Intelligence Team Lead.
  • Use Agile practices to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing, and delivering enterprise data asset solutions in collaboration with business intelligence teams or other IT teams.
  • Develop, configure, customize, and manage integration tools, databases, warehouses, and analytical systems with the use of data related software.
  • Design, build, and deploy data extraction, transformation, and loading processes and pipelines from various sources including databases, APIs, and data files.
  • Develop and deploy structured, semi-structured, and unstructured data storage models such as data vault or dimensional modeling on a variety platform to meet our requirements.
  • Coordinate security, application monitoring, development tooling, and related capabilities with responsible teams.
  • Provide operational support and incident management for data pipelines and data flows, including proactively updating internal clients and relevant parties on status changes and issues encountered.
  • Author and maintain accurate and up-to-date documentation for processes, procedures, and technical designs.
  • Work onsite, under guidance, in a team-based and open office environment.

Requirements

  • 10+ years' experience developing data-related solutions and software
  • 9+ years of experience working with relational databases and applying it in various applications, including within the Microsoft Azure platform
  • 4+ years of experience with multiple cloud technologies in the Microsoft Stack (Azure IaaS and PaaS) along with familiarity with alternative cloud technologies
  • 3+ years of experience designing and development on-premises and cloud-based (Azure) infrastructure and platform components
  • 3+ years of hands-on development and deployment experience with Azure cloud using T-SQL, Azure SQL, Azure Storage, Azure Data Factory, Azure Synapse, Cosmos DB, GitHub, Azure DevOps, and CI/CD pipelines
  • Advanced knowledge of Extract/Transform/Load (ETL) and/or Extract/Load/Transform (ELT) tools, including both batch and real-time data transmission applications such as SSIS, Informatica, Kafka, Spark, MuleSoft, or equivalent software
  • Advanced knowledge of database technologies such as Microsoft SQL Server, Oracle, or NoSQL databases
  • Advanced knowledge of multiple programming languages, such as C#, Python, SQL, Scala, or similar
  • Intermediate knowledge of IT infrastructure standards and tools, such as application performance monitoring, IT service management, or DevOps software
  • Experience with Power BI
  • Bachelor's degree in computer science, Information Technology, or another relevant field