AllianceBernstein

Fixed Income Investment Technology ("FIIT") group builds software that the Fixed Income business of AB uses in performing functions such as Fundamental Research, Quantitative research, Portfolio Management, Order Generation, Trading and Middle office and BackOffice operations.. Familiarity with cloud-based data platforms (e.g., AWS Redshift, Google BigQuery, Azure SQL Data Warehouse) and related services.. Knowledge of data visualization tools such as Tableau, Power BI, or QlikView for creating interactive and meaningful visualizations.. Big Data Technologies: Strong knowledge of big data technologies and frameworks, such as Apache Hadoop, Apache Spark, Apache Kafka, Apache Hive, or Apache Flink.. Data Warehousing: Familiarity with data warehousing concepts and technologies, like Azure Synapse, Amazon Redshift, Google BigQuery, or Snowflake.

senior data engineer

Who You'll Work With: Fixed Income Investment Technology ("FIIT") group builds software that the Fixed Income business of AB uses in performing functions such as Fundamental Research, Quantitative research, Portfolio Management, Order Generation, Trading and Middle office and BackOffice operations. It partners with business to understand their challenges and help them by providing innovative technology solutions. We re-engineer the process where applicable in collaboration with business to help scale their business and be efficient in this dynamic market conditions. Our Data Warehouse ingests and egresses critical reference and transaction data from up-stream and down-stream systems. We are seeking a Nashville based senior professional to join our Fixed Income Investment Technology team. With complex architecture which is core to how we service FI clients (and beyond), this is a critical role where someone with industry experience will be a good fit allowing us to scale our processes. Data is a constantly growing entity and we need to have a clean architecture to align our data with supporting investment team needs. The current data team has a lot of junior - mid level staff and needs someone with strong technical skills and leadership skills to design scalable infrastructure. The ideal candidate would have experience with designing, implementing, maintaining, monitoring and performance tuning ETL and ELT pipelines using technologies like Azure, Airflow, Python, Oracle and SQL server. They would be proficient in various data patterns like Gamma, Kappa, Data mesh / fabric, AKS, Data Lakes and Delta Lake What You'll Do: The primary project that the candidate will contribute to all modules within Fixed Income technology. These modules support Senior Portfolio Managers, Portfolio Managers, Assistant Portfolio Managers, Fundamental and Quantitative research analysts, Traders, Middle-office, and Operations functions. <ul><li> Data Management Tools and Technologies: </li> </ul>Proficiency in data management tools such as SQL-based databases (e.g., SQL Server, MySQL, PostgreSQL, Oracle) and NoSQL databases (e.g., MongoDB, Cassandra). Experience with data integration and ETL tools. Knowledge of data warehousing concepts and technologies, including star schemas, data marts, and data lakes. Familiarity with cloud-based data platforms (e.g., AWS Redshift, Google BigQuery, Azure SQL Data Warehouse) and related services. Understanding of big data technologies such as Hadoop, Spark, and related ecosystem components (e.g., HDFS, Hive, Pig). <ul> <li>Data Modeling and Design: </li> </ul>Proficient with designing an optimal Data warehouse and Operational data store using modern cloud patterns. Proficient in data modeling techniques and tools, such as ER modeling and UML diagrams. Experience in designing and implementing data schemas, including conceptual, logical, and physical models. Knowledge of dimensional modeling and familiarity with industry-standard frameworks such as Kimball or Data Vault. Ability to optimize database performance through indexing, partitioning, and query tuning. <ul> <li>Data Governance and Compliance: </li> </ul>Understanding of data governance frameworks, data stewardship, and data ownership concepts. Knowledge of data privacy regulations (e.g., GDPR, CCPA) and experience implementing data protection measures. Familiarity with data security best practices, encryption methods, access controls, and user authentication mechanisms. <ul> <li>Data Quality Assurance: </li> </ul>Experience in data profiling techniques and tools to assess data quality and identify data anomalies. Proficiency in data cleansing methods, data validation techniques, and data transformation rules. Knowledge of data quality frameworks, metrics, and best practices for measuring and monitoring data quality. <ul> <li>Programming and Scripting: </li> </ul>Proficiency in one or more programming languages such as Python, Java, or Scala for data manipulation and transformation tasks. Experience in writing complex SQL queries and stored procedures for data retrieval and manipulation. Familiarity with scripting languages such as Bash or PowerShell for automation and process improvement. <ul> <li>Data Visualization and Reporting: </li> </ul>Knowledge of data visualization tools such as Tableau, Power BI, or QlikView for creating interactive and meaningful visualizations. Ability to design and develop reports, dashboards, and data-driven presentations to communicate insights to stakeholders. <ul> <li>Cloud and Distributed Computing: </li> </ul>Understanding of cloud computing concepts and experience working with cloud platforms (e.g., AWS, Azure, or GCP). Knowledge of distributed computing frameworks such as Apache Spark for large-scale data processing and analytics. <ul> <li>Software Development and Agile Practices: </li> </ul>Familiarity with software development methodologies, particularly Agile/Scrum, and experience working in Agile development teams. Understanding of software development lifecycle (SDLC) processes and experience collaborating with development teams. What We're Looking For: <ul> <li>Educational Background: A bachelor's or master's degree in Computer Science, Software Engineering, Data Science, or a related field is often required. Advanced degrees can be advantageous. </li> <li>Programming Skills: Proficiency in programming languages commonly used in data engineering, such as Python, Java, Scala, or SQL. </li> <li>Big Data Technologies: Strong knowledge of big data technologies and frameworks, such as Apache Hadoop, Apache Spark, Apache Kafka, Apache Hive, or Apache Flink. </li> <li>Database Management: Experience with various database systems, both traditional relational databases (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB, Cassandra). </li> <li>Data Modeling: Expertise in designing and implementing data models to facilitate efficient data storage, retrieval, and analysis. </li> <li>Data Warehousing: Familiarity with data warehousing concepts and technologies, like Azure Synapse, Amazon Redshift, Google BigQuery, or Snowflake. </li> <li>ETL/ ELT: Experience in designing and implementing ETL / ELT processes to extract, transform, and load data from various sources into the data warehouse. </li> <li>Data Pipeline Management: Ability to create and manage data pipelines for data ingestion, integration, and transformation. </li> <li>Experience with scheduling tools like Airflow, Control-M or Auto-sys </li> <li>Cloud Services: Experience with cloud computing platforms like AWS, Azure, or Google Cloud, and familiarity with their data services. </li> <li>Data Governance and Security: Knowledge of data governance principles and best practices, including data security and privacy measures. </li> <li>Data Quality and Testing: Understanding of data quality assessment methods and proficiency in data testing techniques. </li> <li>Performance Optimization: Skills to optimize data pipelines and queries for better performance and scalability. </li> <li>Problem-Solving and Troubleshooting: Strong problem-solving abilities and the capability to identify and resolve complex data engineering issues. </li> <li>Team Leadership: Leadership and mentoring skills, as senior data engineers often lead and guide other members of the data engineering team. </li> <li>Communication: Effective communication skills to collaborate with cross-functional teams, communicate technical concepts to non-technical stakeholders, and document data engineering processes. </li> </ul>Who We Are: We are a leading global investment management firm offering high-quality research and diversified investment services to institutional clients, retail investors, and private-wealth clients in major markets around the globe. With over 4,000 employees across 57 locations operating in 26 countries and jurisdictions, our ambition is simple: to be the most trusted investment firm in the world. We realize that it's our people who give us a competitive advantage and drive success in the market, and our goal is to create an inclusive culture that rewards hard work. Our culture of intellectual curiosity and collaboration creates an environment where you can thrive and do your best work. Whether you're producing thought-provoking research, identifying compelling investment opportunities, infusing new technologies into our business or providing thoughtful advice to our clients, we are fully invested in you. If you're ready to challenge your limits and empower your career, join us! AB does not discriminate against any employee or applicant for employment on the basis of race, color, religion, creed, ancestry, national origin, sex, age, disability, marital status, citizenship status, sexual orientation, gender identity, military or veteran status or any other basis that is prohibited by applicable law. AB's policies, as well as practices, seek to ensure that employment opportunities are available to all employees and applicants, based solely on job-related criteria. In accordance with applicable law, the minimum and maximum base annual salary for this role is as follows: Base Salary Range: $190,000 to $200,000 Actual base salaries may vary based on factors including but not limited to education, training, experience, past performance, and other job-related factors. Base salary is just one component of total compensation at AB, which may include, depending on eligibility, commissions, year-end incentive compensation, short- and long-term incentives and Department-specific awards. In addition AB provides a variety of benefits to eligible employees, including health insurance coverage, an employee wellness program, life and disability insurance, a retirement savings plan, paid holidays, sick and vacation time off Nashville, TennesseePDN-99fb-4a91-81de-5ab4ff259261

START NEW SEARCH