Jr. Data Analyst

Full-Time • 

Royal Oak, MI

Experience

1+ years

Seniority Level

Associate

Employment Type

Full-Time

We create opportunity for those seeking opportunity

We are looking for a Jr. Data Analyst who will work closely with subject matter experts, peers, and clients to develop reporting and data structures using a variety of tools and data sources including but not limited to: Snowflake, Tableau, R, Google Analytics, and Facebook.

Candidates will be expected to consult with users to define and document requirements, maintain reference data, and execute analysis and/or dashboard creation using Tableau and supporting data tools while adhering to information design best practices. Successful candidates will become the subject matter expert of the enterprise data warehouse and grow their data and analysis skills.

Career Now Brands is a data and metrics driven company and as such, strong candidates will excel at developing, executing, and leveraging business intelligence and analytical tasks. The work product from these tasks can take multiple forms including ad-hoc analysis packages, dashboards, documentation, and enterprise reporting suites.

What you will do:

  • Serve a multitude of functions including but not limited to: marketing insights, business analysis, data stewardship, data analysis, data engineering, report/dashboard design, development, and maintenance
  • Consult with other team members on data analysis and data management questions
  • Gather requirements and produce documentation
  • Maintain critical reference data
  • Work with the development team to enhance/create new data models for data warehouse consumption
  • Develop SQL queries in Snowflake for reports, dashboards, and analyses
  • Create light-weight code in Tableau to drive metrics/functions
  • Run a combination of semi-automated and automated reports and identify outliers, reconciling as necessary
  • Develop methodologies for aggregating results from various programs and campaigns
  • Confirm data integrity and perform analysis to identify trends
  • Reconcile disjointed data sources as needed

What you will need:

  • 1 year of developing SQL queries for analysis purposes (Oracle, MySQL, SQL Server, Snowflake, etc.)
  • 1 year of designing and developing dashboards, reports, and analyses (Tableau, Qlik, Power BI, etc.)
  • BA/BS degree in a math, computer science or related analytical degree is preferred but not required. Relevant experience in lieu of a degree will be considered
  • Highly accountable self-starter with the ability to work well within a group and independently
  • Must have excellent communication skills, both verbal and written
  • Must demonstrate strong analytical skills with the ability to perform deep QA and reconciliation activities
  • Solid information design skills based on best practices
  • Demonstrated ability to learn new technologies and business requirements; programming experience
  • Must show a strong understanding of data, data relationships, and database structures
  • Must be able to handle multiple clients and projects simultaneously with a strong attention to detail
  • Proficiency in MS Office (Word, Excel and PowerPoint)
  • Priority will be given to candidates with experience in one or more of the following BI/analysis/ETL/Warehousing software packages: Tableau, Snowflake, & Matillion.

Career Now Brands brings creative marketing solutions to recruitment and enrollment practices in the trucking, education and job distribution industries. Our flagship products - CDL Job Now, Career School Now and RocketPost - help build our clients' businesses while impacting millions of lives by boosting employment and enrollments across the U.S.

This position will be in our new downtown Royal Oak headquarters. We recently renovated a large industrial warehouse into a modern, new office that embodies the culture and character of Detroit’s most innovative tech startup.

Interested? Apply at: https://airtable.com/shrrgkIC8eDNea4Bp

To learn more about our company, please visit www.careernowbrands.com

Career Now Brands is an equal opportunity employer and does not discriminate on the basis of race, color, gender, religion, age, sexual orientation, national or ethnic origin, disability, marital status, veteran status, or any other occupationally irrelevant criteria.