Senior Data Analyst

full time employee

Royal Oak, MI

Employment Type

full time employee

We are looking for an exceptional Senior Data Analyst to join our Data Services team. The individual in this role will work closely with business teams and CNB clients for data & analytics requirements. You will become an analytical subject matter expert in your assigned area of responsibility, utilize modern tools for data gathering, create informative reports & dashboards, and share insights with business teams and clients to enable data driven decision making. You will proactively identify improvement opportunities using data; opportunities that will deliver substantial value for CNB and our clients.

Responsibilities:
Build and support data & analytics products / solutions within data platform
○ Serve the assigned area of responsibility including but not limited to analytics for marketing, operations, call center, and sales
○ Write SQLs for pulling data from data warehouse, and usage in reports and dashboards, or analysis using spreadsheets
○ Work with data engineers to ingest new data sources into the data platform
○ Create reports and dashboards in Tableau using rapid prototyping, and iterative development
○ Define and maintain business metrics, KPIs, and calculations, as well as documentation regarding the same
○ Build, test and deploy transformation logic within data warehouse using DBT
○ Provide inputs for best practices and standards for data modeling, DBT and Tableau
○ Review code of peers, and highlight deviations from best practices and standards
○ Conduct demos to showcase the created solution for problem at hand
○ Provide day to day production support, and on call as needed
● Conduct BI Reviews with clients on a regular cadence
○ Prepare monthly and/or quarterly reporting package(s) for clients
○ Review the reports with clients, highlight performance of the campaigns, share not-so-obvious insights, and recommend actions to bring improvements
○ Address any follow up reporting needs from the clients
Analyze data and identify opportunities
○ Utilize statistical techniques to analyze key datasets, identify patterns, and share any recommendations with stakeholders
○ Identify metrics that currently are not looked at but seem important based on analysis
○ Review client’s budget performance and proactively identify trends that could indicate potential churn, then recommend actions to take
○ Shadow business teams to understand process, and identify opportunities to streamline utilizing data & analytics Minimum

Qualifications:
● 5 years of experience in a data analyst role
● 3 year of experience creating SQLs and managing large datasets inside cloud based databases (examples: Snowflake, or Redshift)
● 3 year of experience building reports and dashboards in Tableau
● Strong analytical, and communication skills (both verbal and written)
● Highly accountable self-starter and a team player
● Able to manage multiple workstreams with minimal guidance while paying strict attention to detail and producing quality code

Preferred Qualifications:
● Experience with DBT
● Knowledge of Python, Segment, Google Analytics, Salesforce and other MarTech platforms
● Knowledge of ETL and ELT
● Experience with marketing, advertisement, and lead data

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 is open to hybrid, which will be in our new downtown Royal Oak headquarters, fully remote or relocation. 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.