Title: Financial Data Analyst (Only on W2)
Work Location: Long Island City, NY, 11101 (onsite)
Duration: 12+ months

Spruce Technology is a mid-size and rapidly-growing Information Technology services firm headquartered in New Jersey. An award-winning firm (Inc 5000, Smart CEO) with a steadily growing portfolio of commercial and government clients, Spruce Technology provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide.

Spruce Technology, Inc. is an Equal Opportunity Employer that does not discriminate on the basis of actual or perceived age, sex, pregnancy, race, creed, color, national origin, disability, marital status, sexual orientation, citizenship status, genetic information, religion, or any other characteristic protected by applicable federal, state or local laws.

Statement of the Job

Financial Data Analyst will be responsible for designing, developing and collaborating on reports/analyses within the Finance Division which will include: Job-Costing Analysis, Soft-Cost Analysis, Completion Cost analysis, and other legally-mandated reports.

Responsibilities to include:

• Prepares presentation quality financial analyses/reports using SQL and Microsoft Excel
• Develops complex queries/scripts and automates periodic reports
• Cleans, manipulates and analyzes large sets of raw data
• Understands data relationships among various tables in Data warehouse
• Conducts business analysis and research to identify key metrics and opportunities for improvement
• Works to ensure integration of accurate and complete data sources
• Performs effective presentations on complex ideas that can be communicated in a simple straightforward manner
• Writes policies/procedures and documents methodologies used to create analyses
• Knowledge of data visualization software such as Microsoft Power BI is a