Data Engineer

Does this sound like you? Are you a SQL scripting savant? Do you love building pipelines to manage data flows? Does the prospect of designing smooth data systems excite you? Are you the type of person who enjoys working with a team to make sure everyone has the tools they need to unlock the secrets in data? Look no further – we have the perfect job for you! Our team offers digital and business transformation to law firms and legal organizations. We are looking for a consultant to help us with the technical aspects of migrating our client’s data. What we do. At Affinity Consulting Group, we offer digital and business transformations to law firms and legal departments. We are their trusted advisers and work with them to build business strategies, create better teams and processes, and implement technology to run a healthy business. What you would do, (unofficially). You would provide technical solutions to organize, classify, and restructure documents and emails based on the assessment and requirements you receive from our Consultant team members. What you would do, (officially). As a Data Engineer on the Document Solutions Team, your ultimate responsibility is to engage with our project teams and sometimes directly with client stakeholders to understand their needs and requirements and then provide the best possible solution to modify or migrate data into Document Management Systems. Your responsibilities. Engaging with clients and serving as a trusted advisor. Analyzing client requirements and designing the best solutions that align with their goals and objectives. Use, improve, and document our library of PowerShell and SQL scripts and procedures used for content migration and manipulation.Support our implementation teams during critical project “Go-Live” phases with nimble and reactive batch scripting to keep our projects on track. Review data mapping logic prior to any migration services to ensure the transformation of data is clear, concise, and within the scope of the project SOW. Possessing knowledge and expertise in content management services in a relevant industry or domain. Collaborating with cross-functional teams, such as sales, marketing, data and development, and client service, to ensure smooth project execution and customer satisfaction. Provide data export and lateral migration services through ad-hoc service support requests. Preparing and delivering documentation, reports, and presentations to clients and internal stakeholders. This may include project status updates, technical documentation, and remediation logs. Providing technical workshops and support to other members of our DMS Technical Services team related to changes and enhancements in our data manipulation and migration services. Your first 90 days. In your initial 90 days, you’ll be fully onboarded and trained in our supported Document Management System migration utility, which will include both formal product training certifications, internal workshops, and observational participation in data migration projects. You will learn from the rest of our extremely talented team and begin to engage with clients on your own. What we’re looking for. We hire talented people based on a track record of accomplishments, intellectual curiosity, and alignment with our Core Values. We’re seeking someone who is a SQL scripting and PowerShell expert (at least three years of SQL Scripting experience is required). We also need you to have a history of improving processes to gain efficiency and accuracy in our deliverables. You will possess that unique ability to be able to think and communicate at a highly technical level, but also adapt your style to work directly with clients to explain solutions in less than technical terms that they can understand. You will have the strong task and time management skills necessary to provide your services autonomously. Experience working with DMS, SharePoint Online document libraries, or Enterprise Content Management systems is highly desirable. More about us and details you’ll want to know. We’re Affinity and Lawyerist (one team; two brands), and we’re changing the legal industry by working with legal professionals to create healthy businesses and better lives. In addition to strategic consulting and coaching, implementing tech, and training, we have two podcasts (Powerful Leaders, No Apologies, and The Lawyerist), a best-selling book, do a ton of speaking, and remain active in our industry. We take pride in our work. We’re proud of the amazing people on our team who bring their whole selves to work each day. We genuinely love to hear each other’s best personal news each week, but we also make space if someone needs support. We laugh a lot and know a good deal about each other’s lives despite being a distributed team thousands of miles apart. We also share a commitment to these Core Values: Be Inclusive. Act with Integrity. Grab the Marker. Stay Curious. The salary range for this position is a base salary of around $85,000 annually. The final salary offered will be dependent on the candidate's experience and location. This comprehensive package is designed to reward expertise and incentivize performance, aligning with our commitment to recognize and support our team's growth and success. We’re 100% remote, so we expect you to have reliable internet, a dedicated professional workspace, and the ability to travel to meetings/conferences, typically 5-7 times a year. We work 8:30-5 ET, M-F (w/ flexibility). This is a full-time position. Benefits include health & dental, LTD/STD and life, 401(k) matching, Employee Assistance Program, fitness budget, flexible vacation, and a great team of people you’ll be proud to work with. We embrace diversity and invite applications from people from all walks of life. We’re honest and recognize that our team isn’t as diverse as it should be. We’re trying to change that. We see imposter syndrome as a sign of conscientiousness. If you aren’t sure whether you qualify, please apply anyway. Let’s talk! We’d prefer to have an extra application to consider rather than having you screen yourself out. We don’t discriminate based on gender identity or expression, sexual orientation, race, religion, age, national origin, citizenship, disability, pregnancy status, veteran status, or other differences. Also, if you have a disability and there’s a way we can make the interview process better, let us know (jobs@affinityconsulting.com w/ the subject line “Data Engineer Accommodations"). We’re happy to accommodate. Ready to join us? We'd love to hear from you! Click the link, and you'll be prompted to click another link to apply. Simply answer a few questions and upload your resume. Please note that candidates must reside and be eligible to work in the United States or Canada.