Data Warehouse Business Analyst

Data Warehouse Business Analyst at a Leading NYC Hedge Fund

Location: NYC, NY (Hybrid - 3 days in office)

Compensation: TBD, This is a contract position. You will sign a consulting agreement and be paid a per diem rate.

COMPANY OVERVIEW:

Mazuma Software is a small technology consulting firm specializing in systems development for the hedge fund industry.

WE NEED YOU:

We are searching for the right candidate to join us at our primary client: a large, technologically progressive hedge fund in midtown Manhattan. We are looking to bring the right candidate on board to help deliver the highest quality software systems. This candidate will be a mid-level business analyst who has the ability to work independently and adapt to the environment as it evolves. This person will be the intermediary and driver between operation analysts and developers for the firm's development team. They will also manage and provide end user remediation of existing software systems. The right candidate takes pride in his or her work and possesses excellent problem solving and communication skills.

RESPONSIBILITIES:

Requirements Gathering:

• Collaborate with business stakeholders to gather and document requirements for data engineering projects.
• Translate business needs into technical specifications for data pipelines, data models, and reporting solutions.

Data Analysis:

• Analyze large datasets to identify trends, patterns, and insights that support business decision-making.
• Write and optimize SQL queries to extract and manipulate data for analysis.

Data Modeling:

• Design and maintain logical data models to support data warehouse architecture and reporting needs.

Collaboration with Data Engineers:

• Work closely with senior and junior data engineers to ensure data pipelines and ETL processes align with business requirements.
• Provide input on database schema design and optimization.

Azure Services Utilization:

• Leverage Azure cloud services to support data integration, storage, and analytics workflows.
• Collaborate on projects involving Azure Data Factory, Azure SQL Server, and Databricks.

Documentation:

• Create and maintain comprehensive documentation for business requirements, data models, and technical workflows.

Financial Industry Insights:

• Apply knowledge of financial data structures and reporting standards to ensure compliance and accuracy in data solutions.

Technology Evaluation:

• Stay updated with emerging technologies and best practices in data analysis and business intelligence.
• Recommend new tools and technologies to improve efficiency and scalability.

MINIMUM QUALIFICATIONS:

• Accounting background
• Operations background
• Strong documentation experience
• Strong analytical skills with the ability to work with complex multi-faceted issues.
• Strong aptitude for undertaking new initiatives for process improvements and workflow simplification.
• Designing workflows and gathering business requirements.
• Needs to be comfortable with Microsoft office: Outlook, Excel, Word, PowerPoint, Visio, Project, Share point.

DESIRABLE SKILLS:

Data Warehouse Expertise:

• In-depth knowledge of data warehouse core concepts, including data architecture, data integration, and data governance.
• Strong understanding of logical data modeling and relational database design.

Query Writing:

• Proficiency in writing SQL queries for data extraction, analysis, and reporting.

Azure Services:

• Experience working with Azure cloud services, including (preferred but not mandatory):
• Azure SQL Server
• Azure Data Factory (ADF)
• Azure Databricks.

Tools & Technologies:

• Familiarity with ETL tools like SSIS.
• Exposure to data visualization tools such as Power BI or Tableau.

Industry Knowledge:

• Prior experience in the financial industry is a strong advantage, with knowledge of financial data structures and reporting requirements.

Job Types: Full-time, Contract

Pay: From $600.00 per day

Application Question(s):

• Will you be able to come into the office 3 days a week
• Are you applying on behalf of someone else
• What state are you currently located in?

Experience:

• Azure Data Lake: 1 year (Preferred)
• Azure Databricks: 1 year (Preferred)
• Microsoft SQL Server: 1 year (Preferred)
• Hedge Fund, Private Equity Shop, or other investment firm: 3 years (Preferred)
• Business Analyst: 6 years (Preferred)

Location:

• New York, NY Preferred)

Ability to Commute:

• New York, NY Preferred)

Work Location: Hybrid remote in New York, NY 10105