Senior Consultant Data Analyst
Role details
Job location
Tech stack
Job description
-
Develop a thorough understanding of the business context and objectives by eliciting and analyzing requirements from relevant stakeholders (business users, data engineers, data scientists, etc.).
-
Operationalize business questions using data.
-
Demonstrate understanding of relational databases, data architecture, and data modeling.
-
Build complex SQL statements to answer business questions.
-
Design conceptual data models, entity relationship diagrams, and business process models.
-
Transform and cleanse data using tools such as R, SQL, or Python.
-
Interpret, understand, and explain data insights to clients.
-
Manage and create dashboards (drag and drop) for storytelling of regular information reports and ad-hoc requests.
-
Build trust and respect, establish relationships, and develop rapport with technical and non-technical team members.
-
Document Data Analysis processes and outcomes.
-
Utilize industry or subject matter expertise (e.g., finance, employment, hospitality, web analytics).
Requirements
-
3+ years of experience in IT or a related industry.
-
Intermediate to advanced SQL skills.
-
Experience working with Data Visualization tools such as Tableau or Power BI.
-
Preferred experience with cloud analytics products such as Google Cloud, AWS, or Microsoft Azure.
-
Preferred knowledge of statistics and experience using statistical packages for analyzing datasets.
-
Strong analytical aptitude and ability to structure complex or undefined business problems.
-
Strong verbal and written communication skills; ability to report and present findings to varying stakeholders.
-
Hands-on experience using tools to help clients make data-driven decisions.
-
Knowledge and practice of core Agile values and principles is a plus.
-
Initiative to learn new strategies and trends to continue to educate self analytically, technically, and technologically.
-
Intermediate experience with Microsoft Excel and PowerPoint.
Benefits & conditions
- Workplace locations look different for everyone. Excellians are a distributed workforce and whether you're working from your home office or a client site, we support a flexible work/life integration regardless of your location.
- We offer top of industry medical, dental, and vision benefits with multiple options to choose from such as an employer-contributed health savings account, infertility coverage, and orthodontia so you can select the plan that works best for you.
- Regardless of what stage of life you're in, Excella wants to support you. We provide 8 weeks of Parental Leave, discounted pet insurance, and a Care.com membership with 3 back-up emergency child or elder care days annually - all available to you on your first day.
- Starting day one, every employee is bonus eligible and receives 15 days of paid vacation, 6 federal holidays, and 4 floating holidays.
- Doing your best work means having the best tools! Excella's TechEleX program provides you with multiple options to suit your technology needs. Choose between a variety of Mac or PC devices, and to ensure your hardware remains current, at the end of a 3-year period Excella will replace your existing computer with a new model from the program. Plus, we'll even give you the original device to keep for your personal use!
- With Excella's Annual Internet Reimbursement benefit, all employees receive an additional $25 per month to help offset the cost of internet access. This initiative reflects our commitment to supporting you in staying connected and productive, no matter where you work.
- We'll invest in your career by providing 3 days of paid professional development every year, including an allowance for registration fees to attend classes, conferences, or obtain professional certifications.
- We encourage mindfulness and overall well-being through employee wellness events, a HeadSpace membership, as well as access to TalkSpace and mental health coverage through our medical plans.