ETL Developer

ETL Developer – Contract Role Company Overview Every firm has a culture – the values, beliefs, methodology, attitudes and standards that reflect an organization’s DNA. But the truly inspiring firms – the game-changers, the industry leaders and the disruptors – have cultures that propel them to innovate and stand out. At Brown Advisory, we aim to be one of those inspired firms. Over the years, we have purposefully built and nurtured our client-first culture. Brown Advisory is an independent investment management firm that is obsessed with putting clients first – not because it’s good for business – but because we find, and hire, people that truly care about each and every client. We feel privileged to work with such a special group of clients, and find a great deal of satisfaction in not only providing them with the highest level of service, but also first-class performance and strategic advice. Our firm was founded in 1993 as an affiliate of Alex. Brown & Sons, a leading U.S. investment bank, and became independent in 1998. Today, we serve institutional and private clients in 50 states and more than 34 countries and territories from our 8 offices in Austin, Baltimore, Boston, Carolinas, Delaware, London, New York, and Washington, D.C. While every investment firm tries to attract the most qualified professionals, we place a premium on only selecting those individuals who fit our culture and bring sought-after skills to our team. In fact, each of Brown Advisory’s 1000+ colleagues own equity in the firm. Our ownership structure, collaborative investment process and client-first culture aligns our interests with our clients and results, which also reduces colleague turnover. ETL Developer – Contract Role Job Description Brown Advisory is seeking an experienced ETL/ELT Developer for a fixed term engagement in support of our Information Technology team. Alongside a team, the ETL/ELT Developer will be responsible for the development of integrations employing industry standard tools for data extraction, transformation and loading (ETL) to / from core critical enterprise systems. The ETL developer should specialize in designing, building, and maintaining data pipelines that move data to / from various sources and to / from cloud-based data warehouses or data lakes. They will focus on ensuring data is extracted, transformed, and loaded efficiently and reliably for analytics and other downstream systems uses. The ETL/ELT Developer Responsibilities: Data Transformation: Develop and optimize data transformations using cloud-based tools and technologies to cleanse, enrich, aggregate, and reshape data according to business requirements. Load transformed data into cloud data warehouses (like Snowflake, Azure Synapse, or BigQuery) or data lakes for storage and further analysis. Performance Optimization: Ensue efficient data processing and pipeline performance within on-premises and cloud environments by leveraging cloud-native services and optimizing resource utilization. Utilizing cloud-specific tools and services (e.g., FiveTran, Snowpipe, Streams and Tasks, Azure Data Factory) for ETL processes. Orchestration and Automation: Automate ETL workflows using orchestration tools or cloud-based workflow services. Data Integration: Design and implement ETL pipelines that extract data from diverse cloud and on-premises sources (databases, APIs, files, etc.). Collaborate with data analysts, systems analysts, developers and other stakeholders to understand data requirements and ensure the successful delivery of data for analytics and other business needs. Create and/or update knowledge base articles regarding procedures, workflows, user guides, process run books, etc. Participate within the change management process. Job Requirements BS in Information Systems, Information Technology, or a related field is required. Work experience in lieu of degree or concentration is acceptable. Minimum of 5 – 7 years of similar work experience as a ETL Developer in a comparable environment and industry. Snowflake - Intermediate level knowledge required. Proficiency in Python and/or R is a plus Excellent analytical and troubleshooting skills. Excellent organizational, teamwork and time management skills. Excellent oral and written communication skills. Ability to handle multiple parallel tasks.