Job Specifications
Business Data Analyst
Location Address: 40 Temperance Street 15th Floor – hybrid – 4 days onsite/week
Contract Duration: ASAP – 10/30/2026
Possibility of extension and conversion to FTE
Schedule Hours: 8:30am-5pm Monday-Friday; standard 37.5 hrs/week (Possible OT)
Typical Day in Role:
• Analyze, document, and translate data requirements into detailed specifications, including source to target mappings, transformation rules, and data quality checks.
• Perform detailed data analysis to troubleshoot issues and support data pipeline processes.
• Support data migration activities, including documentation of cleansing rules and validation of end to end test results.
• Build and maintain Power BI dashboards and data models to support business reporting needs.
• Gather, analyze, and document business requirements; translate them into functional and technical specifications.
• Develop BRDs, user stories, process flows, and functional specifications for data and technology initiatives.
• Conduct gap analysis, identify risks, and propose solutions for complex data and business problems.
• Lead or support User Acceptance Testing (UAT), including test case design, execution, and defect resolution.
• Act as a liaison between business stakeholders, IT, and data engineering to ensure alignment and clarity.
• Provide functional support for Salesforce Financial Services Cloud (FSC), including data structures, objects, and workflows.
• Build and optimize Salesforce reports and dashboards. Investigate and resolve Salesforce data and process issues with business and technical teams.
Candidate Requirements/Must Have Skills:
1. 10+ years of experience in data analysis, data modeling or business analysis (Strong documentation skills for both business and technical requirements)
2. 5+ years of experience with SQL
3. Hands-on experience with Power BI (data modeling, DAX, dashboards, reporting)
4. 3+ years of experience with Salesforce FSC, especially reporting and data model understanding.
5. Knowledge of data warehousing, ETL, data pipelines, and metadata management
6. Bilingual in Spanish
Nice-To-Have Skills:
1. Experience in Wealth Management, Capital Markets, or Financial Services
2. Coding experience
Soft Skills Required:
-communication skills
-attention to detail
-strong collaboration skills with cross-functional/regional stakeholders
-problem solving skills
Education: Bachelor’s degree in Computer Science, Information Systems, Business, Engineering, or equivalent.
About the Company
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele. As a Certified MBE and Woman-Owned organization, we pride ourselves on fostering global cross-cultural connections that advance both the careers of our employees and the success of our clients' businesses.
At LanceSoft, our mission is clear: to leverage our global network to seamlessly connect businesses with the right talent and individuals with the right opportunities, all without bias. We...
Know more