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

Apply for Technical Consultant - Data Developer

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