Data Analyst

full time employee

Royal Oak, MI

Employment Type

full time employee


Data Analyst
 
We are looking for an exceptional Data Analyst to join our Data Services team. The individual in this role will work closely with the subject matter experts, peers, and clients to develop customer and campaign insights using a variety of analytical tools including but not limited to SQL, Tableau, Google Analytics, and a variety of CNB’s channel specific marketing tools.
Candidates will be expected to consult with users to define metrics, use cases and visualization needs, then execute the analysis request, and create visually appealing dashboards in Tableau that provide a compelling story. Successful candidates will become the analytic subject matter experts over their business unit by consistently providing insights to drive business decisions and proactively identifying opportunities for deeper analysis that could ultimately deliver substantial process improvements.

Responsibilities:
        Serve a multitude of functions including but not limited to marketing, operations, call center, and sales
        Consult with business and product stakeholders on data analysis and data management questions, and proactively identify opportunities for process improvement
        Participate in requirements gathering for reports/dashboards, and conduct proof-of-concepts
        Work with data engineering team to enhance/create new data models for dashboard consumption
        Write custom SQL queries for reports and dashboards
        Create Tableau calculations to drive metrics/functions
        Perform data validation, identify data outliers, and reconcile as necessary
        Join disjointed data sources as needed to produce analytical datasets
        Develop and evangelize ‘bleeding edge’ visualization techniques
        Perform analysis to identify trends, and communicate insights to various stakeholders utilizing statistical techniques
        Define, track and forecast KPIs
 
Minimum Qualifications:
        Bachelor’s degree in statistics, information technology or a related field
        2+ years experience working directly with internal or external clients developing data derived insights through BI tools (Tableau, QlikView)
        1+ years experience in creating SQL queries and managing large datasets
        Understanding of databases (Snowflake, Redshift, MySQL) and ETL tools (Matillion, Informatica, AWS Glue)
        Highly accountable self-starter and a team player
        Strong analytical skills, and communication skills, both verbal and written
        Proven ability to gather business requirements, and manage multiple projects at a time while paying strict attention to detail
        Hunger to learn new tools and technologies
        Advanced spreadsheet skills (Excel, Google Sheets)
        Familiarity with work management and collaboration tools like Jira, and Confluence
 
Preferred Qualifications:
        Master’s degree in statistics, information technology, or a related field
        Knowledge of Google Analytics, CRM (Salesforce, HubSpot), and marketing automation tools (MailChimp)
        Domain knowledge in marketing, operations, call center, and sales
 
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.
 
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.