Senior Data Engineer
About The Position
It's an exciting time to be a member of the Fisher Investments Technology Department. We are looking for a Senior Data Engineer to support our Enterprise Data Management team. If you are looking for an opportunity to make a difference as we develop scalable and strategic solutions to support our global growth, we want to hear from you! The Opportunity: Fisher Investments is looking for a Senior Data Engineer to design and provide modern data solutions using cloud-based platforms and AI-driven innovations. You will partner with business, technology, and governance teams to ensure scalable, secure and compliant data platforms that power advanced analytics and AI. You will be the 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 also coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems.
Requirements
- 15+ years' experience developing data-related solutions and software
- 10+ years of experience working with relational databases and applying it in various applications, including within the Microsoft Azure platform
- 4+ years of experience with the following:
- Multiple cloud technologies in the Microsoft Stack (Azure IaaS and PaaS) along with familiarity with alternative cloud technologies
- Design and development of on-premises and cloud-based (Azure) infrastructure and platform components
- 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 and Extract/Load/Transform tools, including both batch and real-time data transmission applications such as SSIS, Informatica, Kafka, Spark, or MuleSoft
- Advanced knowledge of database technologies such as Microsoft SQL Server, Oracle, or NoSQL databases
- Advanced knowledge of multiple programming languages, such as Python, SQL, or Scala
- Advanced knowledge of IT infrastructure standards and tools, such as application performance monitoring, IT service management, or DevOps software
- Bachelor's degree in Computer Science, Information Technology, or other relevant field
Nice To Haves
- Experience with Databricks
- Experience with Power BI
- Experience implementing and supporting multi-vendor data lake solutions
Responsibilities
- 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 various platforms to meet 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
- Coach junior data and business intelligence personnel across the company, including developing material and guiding junior personnel on their technical skill growth
Benefits
- 100% paid medical, dental and vision premiums for you and your qualifying dependents
- A 50% 401(k) match, up to the IRS maximum
- 20 days of PTO, plus 10 paid holidays
- Family Support programs including 8 week Paid Primary Caregiver Leave, $10,000 fertility, family forming, and hormonal health assistance, and back-up child, adult, and elder care
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
