About the Role
The Data & AI Engineer is a hands-on builder responsible for developing BGL’s data platform, analytics, and AI integrations. This role combines data platform work with hands-on AI enablement, evolving to build the firm’s AI applications as the roadmap advances.
Responsibilities
- Design, build, and maintain ELT pipelines using Fivetran into Snowflake, ingesting line-of-business and SaaS sources.
- Handle schema evolution, monitoring, and failure recovery for ELT pipelines.
- Develop curated, well-documented data models and transformation layers.
- Implement data-quality checks, testing, and lineage documentation.
- Build semantic layers and datasets to power reporting.
- Own all technical aspects of the firm’s Tableau environment, including site and user administration, permissions, published data sources and connectivity, extract and refresh schedules, and performance tuning.
- Architect and maintain published data sources, connections, and certified datasets.
- Build and support dashboards in partnership with business stakeholders.
- Enable governed self-service analytics with clear definitions, certified datasets, and usage documentation.
- Build the data foundations and technical integrations for the firm’s AI initiatives.
- Prototype and build AI-powered solutions on the data platform.
- Establish testing and evaluation practices for AI outputs.
- Develop within IT-owned security and compliance controls.
- Instrument and monitor AI and data platform consumption, reporting cost trends and optimization opportunities.
Requirements
- 4+ years of hands-on data engineering experience in production environments.
- Strong SQL and Python skills.
- Demonstrated experience building and operating Snowflake-based platforms and managed ELT (Fivetran or comparable).
- Hands-on Tableau experience with an emphasis on published data source architecture, connectivity, and performance.
- Dashboard development proficiency.
- Site administration experience preferred, or the aptitude to take ownership of it quickly.
- Experience integrating cloud AI services (Azure OpenAI / Azure AI services or comparable) into data workflows.
- Working knowledge of data governance, access control, and security practices.
- Comfort operating within compliance guardrails.
- Strong documentation and communication skills.
- Able to serve stakeholders with transparency.
- Experience in financial services or another regulated industry (preferred).
- dbt or comparable transformation framework (preferred).
- CI/CD for data workloads (preferred).
- Infrastructure-as-code exposure (preferred).
- Experience with Power BI and/or Microsoft Fabric semantic models and reporting enablement (preferred).
- Familiarity with Microsoft Purview, sensitivity labels, and DLP (preferred).
- SnowPro Core, DP-600 (Fabric Analytics Engineer), DP-203, or AI-102 certifications (preferred).
Skills
- SQL
- Python
- Snowflake
- Fivetran
- Tableau
- Azure OpenAI
- Azure AI services
- Data Governance
- Access Control
- Security Practices
- dbt
- CI/CD
- Infrastructure-as-code
- Power BI
- Microsoft Fabric
- Microsoft Purview
- Sensitivity Labels
- DLP
Location
- Boston
- Chicago
- Cleveland
- Los Angeles
- New York
Work Type
- Full-Time
Experience Level
- 4+ years of hands-on data engineering experience
Salary/Compensations
- $120,000—$150,000 USD
Benefits
- Medical
- Vision
- Dental
- PTO
- 401k with employer match
- Paid holidays
- Cell phone reimbursement
About the Company
- Brown Gibbons Lang & Company (BGL) is a leading independent investment bank and financial advisory firm focused on the global middle market.
- We advise private and public corporations and debt and equity sponsors on mergers and acquisitions, capital markets, financial restructurings, valuations and opinions, real estate, and other strategic matters.
- BGL has investment banking offices in Boston, Chicago, Cleveland, Los Angeles, and New York, and real estate offices in Chicago and Cleveland.
- The firm is also a founding member of REACH Cross-Border Mergers & Acquisitions, enabling BGL to service clients in 30 countries around the world.
- On every engagement, our clients receive senior-level attention from experienced bankers who bring a wealth of industry knowledge, transaction expertise, and deep relationships with key players in a broad range of industries.
- Our success and growth is due to the expertise, passion, and commitment of our team.
- We value our employees and invest in their development, recognizing that their talent is the foundation of the exceptional service we deliver to BGL clients.
Equal Opportunity
- BGL is an Equal Employment Opportunity (EEO) employer and all qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, gender, age, veteran status, political affiliation, sexual orientation, marital status, or disability (in compliance with the Americans with Disabilities Act), or any other legally protected status, with respect to employment opportunities.
