Data Analyst

Boston, MA (hybrid) or virtual (US)

Craftsman Technology Group is an employee-owned firm that supports mission-driven organizations. Our work spans community and economic development, community health, arts and historical institutions, and organizations fostering inclusive communities. We believe technology can be an effective vehicle for change.

  • Our mission: to help nonprofit organizations grow and thrive.

  • Our values: be transparent and honest; be fair and accountable; be independent and objective; and be good to our staff, our communities, and the world.

We are seeking a Data Analyst to join our Technical Services team who will bring these same values and passion to help nonprofit organizations. A Data Analyst is a client-facing full-time salaried intermediate-level position.

Job Summary:

In this role, you will be responsible for working with our clients to create data warehouse solutions, perform data migrations, and create analytics dashboards using Business Intelligence tools such as PowerBI and Tableau. You will leverage SQL, Azure Data Factory and other data warehousing tools to create custom solutions and perform data migrations between SQL-based systems and Salesforce.

Your role is key in the data migration process, leveraging SQL and other technologies to map, transform and load data into Salesforce from a wide range of source systems. You will work with the Technical and Professional Services teams to create scalable systems to perform data migrations and develop analytics dashboards and data-driven solutions for our clients.

You will be expected to cross-train in areas of technology, knowledge management, project management and perform traditional development tasks. You will participate in client-facing requirements gathering and scoping activities, product demonstration, internal and end-user testing, front-end configuration, and other project work necessary to implement technology with nonprofits and social sector organizations.

Job Responsibilities:

  • Work with clients on the full data migration lifecycle, including scoping, mapping, transformations and technical data migration.
  • Support the mapping and migration of complex data structures from 3rd party systems into Data Warehousing and Salesforce solutions.
  • Design, develop and maintain multiple aspects of the data warehousing solutions – including setup, configuration and deployment of data warehousing solutions.
  • Customize and configure business intelligence tools such as PowerBI or Tableau.
  • Participate in the full application lifecycle – architect, design, development, testing and deployment – additionally support new and existing client data warehousing solutions.
  • Utilize Azure Data Factory and SQL to perform operational support, deliver enhancements and bug fixes for clients.
  • Work with CTG staff and clients to develop industry-specific analytics solutions (e.g. Community Development Financial Institutions).
  • Proactively engage in continuous improvements efforts for application design support and Technical Services team development efforts.
  • Serve as a data escalation point for Technical Analysts and Business Analysts.

Required Qualifications:

  • 2+ years of relevant technology and/or data experience
  • Working knowledge of relational databases and basic Salesforce functionality
  • Technical experience configuring, deploying and monitoring data warehousing solutions using SQL, Python, R or similar technologies to transform data
  • Strong problem-solving, creative thinking skills and a commitment to life-long learning
  • Experience with integrations using common API protocols such as REST and SOAP
  • Commitment to working in the nonprofit sector
  • Flexibility to travel on occasion

Preferred Qualifications:

  • Salesforce Administrator, Salesforce Advanced Administrator or Nonprofit Cloud Consultant credential
  • Prior experience with data warehousing solutions such as Azure Data Factory or Snowflake
  • Advanced Salesforce Certifications, such as Platform Developer 2, Solutions Architect, etc.
  • Experience in the full lifecycle application development – from requirements gathering to deployment and support of an application
  • Nonprofit experience

Salary:

$72,500 – $87,500

Benefits:

  • Company-supported medical, dental, vision
  • Company-provided short- and long-term disability
  • 401k & Roth IRA retirement options with a company match (available 90 days after hire date)
  • Employee ownership (engaged 6 months or 1,000 hours after hire date)
  • 4 weeks accrued paid-time-off (PTO) per year
  • 10 paid company holidays and 2 paid floating holidays (individual’s choice) per year
  • CTG’s commitment to professional development and advancement
  • Work culture aiming toward work/life balance

Submit an Application

Important Note

  • Applicants must be eligible to work in the US. H1-B sponsorship is not available.
  • Our headquarters is in Boston, MA and we have a strong virtual culture with staff located throughout the contiguous United States. We are unable to hire candidates living outside the United States.
  • Direct applicants only; no recruiters.

Return to Careers Page