Data Migration Analyst

Sorry, this job was removed at 6:25 a.m. (CST) on Thursday, October 21, 2021
Find out who's hiring remotely in Chicago.
See all Remote Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Who we are
Smokeball helps law firms bill more without their clients paying more. Intriguing, right? We were founded by technology leaders with more than 20 years of experience in delivering impactful legal technology products. Our leadership continually strives to develop a company, culture, and team that share a profound love for the law and are compelled to help small law firms find success. Our mission isn't simple, but it is straightforward: help small law firms be successful businesses so that they can better serve our communities.
What makes us special?

  1. Culture is sacred. As a 'Best Places to Work' winner four years in a row, we believe company culture is the single most important ingredient to our success. At the end of the day, it is all about our people.
  2. The best product in Legal Tech. We think deeply about the challenges small law firms face. We do not bother with simply delivering a "faster horse," we drive innovations that truly enhance the lives and businesses of our clients. Check out our ratings on G2, Capterra, and Google.


Growth. The Legal Tech industry is estimated to be worth around $15bn and is growing every year. Smokeball is growing right along with it, and we like to take our people with us.
What we need
We are looking for an experienced data analyst to join our new Client Migrations team at Smokeball. This position will be responsible for the extraction and mining of large volumes of data, including data profiling, data cleansing, data transformation, and the loading of data into our software. Our ideal candidate is an independent worker with experience meeting and exceeding customer requirements.
A day in the life:

  • Write programs, SQL scripts and stored procedures for the data conversions
  • Work with business to identify, define, collate, document, and communicate data migration requirements
  • Manage assigned risks and monitor potential impacts as part of the data migration plan
  • Perform quality assurance and database validation on all test and live conversions
  • Develop and test all technical solutions per functional specifications
  • Participate in team problem solving efforts and offer ideas to solve client issues
  • Maintain responsibility for completion and accuracy of work products with meticulous attention to detail
  • Works under moderate supervision and initiates routine tasks with no instructions
  • Ensures data integrity, data security and performance of production databases
  • Assist in designing, planning, and managing the data migration process
  • Prepare data migration plans including migration risk, milestones, quality, and business sign-off details
  • Develop best practice, processes, and standards for effectively carrying out data migration activities.


What you bring

  • Experience in Computer Science, Information Systems or related analytical or technical disciplines
  • Expert in SQL Server
  • Proficient in C#
  • Advanced Excel Skills
  • Experience with data quality analysis and statistical analysis
  • Experience analyzing transactional electronic data
  • Superior communication skills
  • Demonstrated experience working directly with customers
  • Ability to explain complex concepts to non-technical audiences
  • Ability to adapt to changing environments and pick up new skills quickly
  • Self-starter with the ability to self-motivate in fast paced environments
  • Strong drive for achieving results under pressure
  • *Must be a US citizen


Your future team
Manager
Mary Ellen: Hi, I'm Mary Ellen! I've been working in Chicago tech for 10 years, starting out as a support specialist and working my way into Product Management. As the US Head of Product, I am passionate about building features which are intuitive and truly understand the client's needs. Our Product Team is autonomous day to day, but collaborate heavily with each other and other teams to figure out sticky issues or to come up with the best UX for a new feature. Aside from work, I am an enthusiast for national parks, my garden, and all levels of quality of tacos.
Teammates
Daniel: Hi, I'm Daniel! I have worked at Smokeball for just over 5 years. I started out on the Sales team, then worked on the Support Team for 4 years, and recently transitioned over to the Migration Team when we built out this team. Throughout my entire time at Smokeball, my favorite thing (regardless of the team) has been the people working at Smokeball; the pervasive culture of collaboration and comradery really make Smokeball an amazing place to work. When I'm not working, I love exploring Chicago. Whether it be new restaurants or neighborhoods, I love that there is always something new to discover in the city.
Robert: Hi, I'm Robert! Although I started my career working in law firms, I've been working in tech for the past 6 years and have been at Smokeball for 2.5 years. As a Data Migrations Specialist, I work to ensure a smooth data migration for new Smokeball clients. My favorite thing about working at Smokeball is the ability to help clients streamline their practice by switching to our user-friendly but robust software. I also really enjoy spending time with my coworkers. Outside of work, I am passionate about my adopted home city of New Orleans, my dog, light jogs, and my never-ending quest to learn Spanish.
Life at Smokeball

  • Great Culture: Named Crain's 2021, 2020, & 2019 Best Workplaces, Inc. Magazine's 2018 Best Workplaces
  • Work-Life Balance: 20 vacation days, 6 sick days, 10 paid holidays, birthday off, volunteer time, and more!
  • Career Growth: Smokeball believes in investing in our own people and promoting from within. Our own President started at Smokeball as an Account Manager!
  • Flexible Working: We trust our people to get their jobs done. Work remotely full-time? In the office full-time? A hybrid of both? Your choice!
  • Benefits: Excellent medical coverage, 401(k) match, monthly wellness stipend, generous parental leave
  • Transparency: We keep employees in the loop through monthly global huddles and local standups where we discuss company goals, updates, new hire introductions, etc.
  • The Office: The kitchen is stocked with breakfast items, snacks, and beverages, and we have plenty of games to help you relax (ping-pong, billiards, pinball, board games, video games). We also offer free monthly massages provided by a licensed massage therapist!
  • Fun Events: In-person happy hours, virtual game nights, family-friendly events, and so much more
  • Convenient Transit: We're located in the heart of downtown Chicago, in walking distance from all major modes of transportation


The values we live by
Creating and fostering a great culture is just as important as providing a great product. At Smokeball, we don't have Core Values for show, we live and breathe them every day.

  • Caring is not optional
  • Make it happen
  • Deliver legendary service
  • Innovate for the client, not the press release
  • Be frank
  • Keep listening, keep learning


These values inform every strategic decision we make and guide our behavior with every person we meet. When we are bringing new team members into the Smokeball Family, we look for compassion, drive, keen judgement, varied perspectives, and no egos.
What DEI means to us
At Smokeball, we believe that "caring is not optional." We respect everyone, no matter who they are, what they look like, who they love, where they come from, how they identify, what they believe in, what abilities they have, or what they are trying to overcome. Smokeball is committed to utilizing community partnerships, education, events, and hiring to create a diverse, equitable, and inclusive environment for everyone we interact with.
Learn more about our DEI program here.
More, more, more!
Why do we do what we do? Where did the name 'Smokeball' come from? How do we give back? Learn more here.
* Frequently cited statistics show that women and underrepresented groups apply to jobs only if they meet 100% of the qualifications. No one ever meets 100% of the qualifications! We encourage anyone who is interested to apply based on the responsibilities and requirements outlined. You may be the culture add that we are seeking! We look forward to your application.
* Smokeball is an equal opportunity employer and committed to providing an open, welcoming environment for everyone.

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Location

We're in the heart of downtown Chicago right at Adams & Wells. Whether you're commuting on the Metra or CTA, we're easy to find!

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about SmokeballFind similar jobs