Acuity Analytics · 1 day ago
Consultant - Python & SQL Developer
Buffalo-Niagara Area
Full-time
Onsite
Senior Level
6+ years expAcuity Analytics is seeking a Consultant - Python & SQL Developer to join their DTS team. The role focuses on designing, building, and maintaining data workflows that support internal analytics and reporting systems, requiring close collaboration with APIs and data models.
AnalyticsAsset ManagementBankingBusiness IntelligenceConsultingFinanceFinancial ServicesHedge FundsMarket ResearchVenture Capital
Responsibilities
Develop and maintain Python-based workflows to:
Interact with internal GraphQL APIs (via Python wrappers) to retrieve and process data
Manipulate and transform data using DataFrames (Polars preferred; Pandas acceptable)
Prepare data for analytics and reporting purposes
Generate output and reports for consumption by end users
Support data ingestion from AWS S3 and Snowflake staging environments into a Postgres-based ORM
Integrate Python logic within BPMN workflow tools to facilitate seamless transitions between workflow steps
Understand and work with the internal ORM data model to ensure data consistency and integrity
Write clean, well-documented, and maintainable Python code that adheres to internal coding standards and best practices
Qualification
Required
A bachelor's degree in computer science, engineering, mathematics, or statistics
6+ years of experience in a Data Engineering role, with a proven track record of delivering insightful and value add dashboards
Strong proficiency in Python, with experience in data manipulation libraries such as Polars or Pandas
Familiarity with GraphQL APIs and Python-based API wrappers
Experience with data ingestion from cloud storage (e.g., AWS S3) and data warehouses (e.g., Snowflake)
Hands-on experience with PostgreSQL and ORM frameworks
Exposure to BPMN workflow tools and integrating custom Python logic
Ability to write maintainable, well-documented code and follow established coding standards
Experience with workflow automation and orchestration tools
Familiarity with CI/CD pipelines and version control systems (e.g., Git)
Understanding data modeling and ETL processes
Good communication (verbal and written)
Experience in managing client stakeholders
Company
Acuity Analytics
Acuity Analytics is the trading name of Acuity Knowledge Partners, a global leader in delivering bespoke research, data management, analytics and AI-enabled solutions to financial institutions and corporates.
5001-10000 employees
H1B Sponsorship
Acuity Analytics has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2022 (5)
2020 (2)
Funding
Current Stage
Late StageTotal Funding
$600MKey Investors
Blackstone GroupHelion Venture Partners
2024-10-09Debt Financing· $600M
2023-01-27Acquired
2007-06-15Series Unknown
Leadership Team
Ian Mullen
Chief Financial Officer
Shailendra Gupta
Group Chief Financial Officer
Recent News
Acuity Knowledge Partners (UK) Limited
2025-12-02
BusinessCloud
2025-10-11
Company data provided by crunchbase