Business Intelligence Analyst - Newtek One
NY, NY
About the Job
NewtekOne®, Your Business Solutions Company®, is a financial holding company, which along with its bank and non-bank consolidated subsidiaries, provides a wide range of business and financial solutions under the Newtek® brand to the small- and medium-sized business ("SMB") market. Since 1999, Newtek has provided state-of-the-art, cost-efficient products and services and efficient business strategies to SMB relationships across all 50 states to help them grow their sales, control their expenses, and reduce their risk.
Newtek's and its subsidiaries' business and financial solutions include: Banking (Newtek Bank, N.A.), Business Lending, Electronic Payment Processing, Technology Solutions (Cloud Computing, Data Backup, Storage and Retrieval, IT Consulting), eCommerce, Accounts Receivable Financing & Inventory Financing, Insurance Solutions, Web Services, and Payroll and Benefits Solutions.
Newtek Bank, N.A. is looking for a Business Intelligence Analyst.
The Business Intelligence Analyst will be responsible for designing, developing, and managing data systems, with expertise in Power BI, financial analysis, Azure Data Factory, SQL, ERP systems, and various systems integration. This individual will be responsible for crafting robust data architecture solutions, ensuring smooth integration across systems, and enabling powerful data analytics for business insights and financial decision-making.
Essential Functions & Responsibilities:
• Data Architecture Design: Develop, implement, and manage scalable data architecture solutions across cloud and on-premise environments, ensuring data integrity, performance, and security.
• Power BI Expertise: Design and build interactive dashboards and reports in Power BI to provide actionable insights, primarily for financial analysis and business decision support.
• Azure Data Factory Management: Create and manage data pipelines using Azure Data Factory, ensuring seamless ETL processes and integration across various systems and databases.
• SQL Development: Write complex SQL queries for data retrieval, manipulation, and reporting. Ensure efficient database performance and troubleshooting where necessary.
• ERP Implementation: Lead or support the implementation and integration of ERP systems, ensuring proper data migration, alignment with business processes, and continuous optimization.
• Systems Integration: Work with cross-functional teams to integrate multiple systems (financial, operational, CRM, etc.), ensuring smooth data flow between applications.
• Data Governance: Establish and enforce data governance policies, ensuring compliance, security, and data quality across the enterprise.
• Collaboration: Collaborate with business stakeholders, analysts, and developers to understand data requirements and provide tailored solutions.
• Financial Analysis Support: Support the finance department by architecting and maintaining data models that drive financial reporting, forecasting, and analysis.
Knowledge, Skills & Abilities:
• Expertise in Power BI, including DAX, Power Query, and data modeling.
• Proficiency in SQL, including stored procedures, query optimization, and performance tuning.
• Hands-on experience with Azure Data Factory and cloud data integration platforms.
• Proven experience in ERP integration, especially within financial systems.
• Strong understanding of ETL processes, data warehousing, and data governance best practices.
• Excellent communication skills and the ability to work with both technical and non-technical teams.
Preferred Qualifications:
• Experience with Microsoft Azure ecosystem (Azure SQL Database, Azure Data Lake, etc.).
• Familiarity with popular ERP systems.
• Financial modeling and reporting experience.
• Knowledge of other business intelligence tools (Tableau, QlikView, etc.).
Education Requirements:
• Bachelor's degree in Computer Science, Information Systems, Data Science, or equivalent experience or 5+ years of experience in data architecture, database management, and systems integration.
Salary Range: $75,000 to $110,000 per year
NewtekOne is an Equal Opportunity Employer; M/F/D/V. We require all of our employees to perform work in an ethical manner and uphold our Code of Business Conduct and Ethics at all times.