Sidekick Solutions LLC Technical Consultant - Data Developer Remote · Full time

Sidekick Solutions is a software consulting and development firm, specializing in social services case management and donor/grants management software solutions. We support clients through a journey of technology adoption and digital transformation, specifically SaaS applications, data management solutions, back-office integration, and reporting. This position is not eligible for immigration or work visa sponsorship.

Description

Job Description / Responsibilities

We are seeking candidates with data migration and data development experience using SQL.  The Technical Consultant/Data Developer is responsible for delivering projects on a predefined scope of work and also developing tooling that increases the accuracy of our services and decreases costs.  This role reports to the Team Lead, Data Services as part of a technical Pod in our Client Services unit.


  • Gather stakeholder requirements and draft data mapping documents for data migration, reporting, or integration projects
  • Maintain data mapping documents, project change logs, and issue backlogs for both internal projects and client projects
  • Coordinate with client stakeholders to receive source data or authenticate with the source data and extract it
  • Analyze data, make recommendations to stakeholders to improve quality, and clean data using template scripts or write custom scripts
  • Prepare, stage, develop, test, and load data between multiple Relational Database Management Systems into a common database platform
  • Analyze, design, implement, and test ETL infrastructure¬†
  • Develop within Microsoft SQL Server, MySQL, and our proprietary JavaScript microservices, all hosted on AWS
  • Support the Product and IT/Engineering teams in the development of Data Warehouse and data pipelining solutions
  • Provide client-facing work like engaging with clients via email, phone, and virtual meetings; and project management tasks like gathering and organizing client materials, scheduling meetings, summarizing meeting follow-up, managing budgets and timelines, and drafting weekly status updates
  • Learn Sidekick Solutions methodology to deliver end-to-end solution design that exceeds client expectations and be responsible for monthly production-based goals, achieving a 50% billable utilization rate within 90 days


Skills / Qualifications

  • Prior data migration experience involving data staging, preparation, testing, and final production loading is required; examples of prior projects will be requested during interview
  • Experience developing blueprints and mapping documentation as part of a source to target extract, transform, and load sequence is required; examples of mapping documentation may be requested during interview
  • Prior experience developing within a data warehouse, lake, or mart is preferred, including data pipeline and ETL/ELT automation development
  • High proficiency in MySQL and Microsoft SQL Server is required; will be asked to demonstrate data and query understanding during a technical interview
  • Prior experience working in teams to develop, maintain, and improve databases which relied on disciplined change management procedures (e.g., ticketing systems and work coordination) is required
  • Prior experience transferring and loading data securely using SFTP or API and an understanding of data permissions and security frameworks is required
  • Prior experience and knowledge of REST-based, JSON API integrations, Node.js and Javascript languages, or Pandas library is preferred
  • Prior experience in healthcare, social services, or government and ability to demonstrate understanding of data and IT needs in those markets is preferred
  • Excellent analytical, project management, and organizational skills; we use Asana and Harvest/Forecast software to manage projects and track time
  • Outstanding written and verbal communication skills with aptitude for exceptional customer service
  • Able to manage performance targets for billable time worked and organize a weekly workload to achieve targets along with deliverables for both internal Company initiatives and client-specific projects
  • Comfortable working from a home office while using conferencing tools to connect with colleagues and clients across time zones
  • Flexibility to occasionally work outside of standard U.S. business hours to accommodate clients in different time zones or cutover timelines that require off-schedule work


Compensation / Benefits

  • Compensation dependent on experience, range $80,000 - $100,000 per year
  • Performance-based bonuses and raises
  • Assistance with technology and office costs
  • Company-sponsored professional development, training, and certifications
  • Health insurance, 401(K) match, 15 Days PTO, Holidays, and Sick Time
  • Remote work with flexible schedule
  • Autonomy and agency over your work on a small, high growth team


Salary

$80,000 - $100,000 per year