Sr. Data Engineer w/ some Testing Experience

SDET Position

We are looking for passionate SDETs (software data engineers in test) to join our growing Data and Analytics team. Join this exciting journey in modernizing our Advisor solutions to the next-generation cloud platform. You will be responsible for working in a cross-functional team to expand, optimize, and improve overall data quality and set up next-generation data orchestration using modern cloud tools and technologies. As a cloud SDET, you will be designing, building, and testing secure and resilient architectures, with the goal of providing actionable insights to our Advisors for them to optimize their business.

Essential Duties And Responsibilities:

• Design and develop automated data validation applications/routines to validate data movement from a wide variety of data sources using Azure, Snowflake Cloud, and cloud-native technologies.
• Be able to read and understand a data model to get actionable insights from data, operational efficiency, and other key business performance metrics.
• Be able to evaluate inbound and outbound data processes and monitoring. Work with the data provider to validate the new feed into our data eco-system.
• Enjoy working in Agile as part of a scrum team and be a part of delivering a high-quality product incrementally in an interactive manner.
• Write Test Driven Development based code to meet overall data quality standards as defined by the users.
• Automate the data testing processes and integrate them with monitoring systems.
• You are a team player who enjoys working with and supporting an Application Engineering team, DBA, Infrastructure, and Project Management Office.
• Analyze existing systems (including legacy) and data sets to help Business Analysts define the functional and non-functional requirements.
• Meet with the business users, assist with data-related technical issues, and support their data infrastructure needs.

Knowledge, Skills, And/Or Abilities:

• Experience working in a cloud environment- Azure is the preference but would be open to other cloud technologies like AWS or Google Cloud Platform
• Strong experience with NoSQL database, including Postgres
• Background in working with Azure Cloud Services: Data Factory, SQL databases, Azure Functions, Data Lake, Databricks, Logic Apps, and Azure Automation.
• Fluent in object-oriented and functional script language: Python, Scala, and C#.
• Advanced working knowledge of SQL Server database - writing advanced SQL script, profiling, and optimization.
• Working knowledge of Business Intelligence tools: Microsoft Integration Services, Reporting Services, and Analysis Services, as well as PowerBI.
• Experience with other Big Data tools such as Spark, Snowflake, and Kafka
• Preference for background in Financial Services, ideally in the Wealth Management/Independent Broker Dealer/RIA industry

Education And/Or Experience:

• Bachelors/Masters in Computer Science, MIS/Information Management, Engineering or related field

Certificates, Licenses, Registration:

• None required.

Physical Demand:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions. Position located in Austin, TX office. Ability to sit at a computer for long periods of time in office environment well lit.