Job Location: United States
About Sidekick Solutions
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.
Job Description / Responsibilities
We are seeking candidates with data migration and data development experience using SQL. The 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. The Data Developer reports to the Director, Data Services as part of a five (5) person 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 $81,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
To Apply
A cover letter and resume must be emailed to jason@sidekicksolutionsllc.com. Submissions without a cover letter will not be considered.
Submit CV To All Data Science Job Consultants Across United States For Free