Apply Now
ETL Business Analyst
Concord, MA US
Full Time
Apply Now

The SmashFly ETL Business Analyst will have responsibility for mapping out data flows end-to-end for various business processes, gathering and analyzing requirements, writing technical and data specifications, and working closely with senior business users and operations leads to validate mapping prior to Customer implementation. This role will require involvement in an iterative software development model, requiring agility and flexibility on the part of the analyst to handle requirements changes.  

      The job you’ll be doing at SmashFly

  • Develop detailed, Customer specific, source-to-target data mappings, data models, standards, and data flows to enable customer integration with SmashFly systems
  • Validate Customer data integrations
  • Work with SmashFly Services Consultants and its Customers to address issues/special requirements identified through integration validation
  • Define, document, and manage the file integration process
  • Analyze how incoming files will impact the SmashFly technology stack and generate requirements for system changes to accommodate them
  • Serve as the interface between SmashFly Services Consultants and DBAs/Engineering to map Customer data to our systems
  • Establish and manage all Customer data integrations. Verify that the correct data is being passed
  • Work with the SmashFly Services Consultants to establish a workplan for each integration project
  • Work with Customers and Services Consultants to resolve any data issues on the Customer side
  • Establish data quality norms to guide Customers’ output files
  • Define, implement, and oversee monitoring mechanisms and address alerts and issues identified as integrations become operational 
  • Work with SmashFly Product Support and Customer IT Operations to define Customer process for resolving Customer data issues

 The skills you should have

  • Bachelors Degree in Computer Science, Information Systems, or related field
  • Minimum 3 years of experience as a data and/or business analyst working with Data Warehouse ETL applications
  • Understanding of data profiling, data comparison and data validation techniques. 
  • Strong written and verbal communication skills, with ability to demonstrate analytical thinking and problem solving skills. 
  • Ability to forge productive working relationships with senior business users, business managers, and Customers
  • Ability to organize multiple projects, and track tasks across each project
  • Experience with SQL, XML, and BizTalk
  • Ability to analyze complex cross functional business processes and define integration requirements. 
  • Ability to facilitate the design of integrated solutions (process, technical & organizational). 
  • Excellent verbal and written communication are essential for this role.
  • Experience using SDLC methodologies and standards - Agile preferred. 
  • Prior software development experience is a plus

      Our track record so far

  • We are a growth-mode software startup backed by well-respected venture capital
  • We’ve delivered significant year-on-year growth since our founding
  • We’ve been named a Best Place to Work by the Boston Business Journal
  • We’re the top ranked company in Boston by Glassdoor
  • We offer great benefits including an open vacation policy, stock options, weekly happy hours – you get the idea.

Oh, and our application process is easy, pretty transparent and painless.

We need talent like you to join us. Ready to apply? Get started.



Apply Now

SmashFly's Total Recruitment Marketing Platform helps corporate recruiting organizations and Recruitment Process Outsourcing (RPO) companies centralize their recruiting operations while providing real-time analytics across all of their initiatives to improve overall recruitment results.

The Total Recruitment Marketing Platform connects what are often disparate technologies into a single all-in-one software solution that includes Global Job Distribution, Social Recruiting, CRM, Web Sourcing, Marketing Automation, Mobile, Career Sites, Landing Pages, Search Engine Optimization (SEO), Employee Referrals and Talent Network Building. All with the actionable Analytics necessary to tell what's working and not working across the entire recruitment strategy.

SmashFly is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, sexual orientation, gender identity or expression, religion, national origin, marital status, age, disability, veteran status, genetic information, or any other protected status.