About Us
Dealer Owned Warranty Company LLC is a leading provider of F&I (Finance and Insurance) partnership services in the automotive industry, offering a full suite of obligor and administrator services, top-of-the-line products, technology, and training. We understand the importance of leveraging process and technology in the F&I industry to drive revenue and ensure success. Our goal is to provide visibility, transparency, and the tools needed for our partners to build their wealth and achieve their goals. DOWC prides itself on taking care of its employees (We were voted one of the “Best Places to Work” four years in a row!), and we also offer award-winning products. All of our positions are fully on-site in Parsippany, NJ.
Job Summary
The Senior Data Analyst plays a key role in configuring the storage, migration, and accessibility of data for business use and clients. This includes transforming data into insights to streamline and improve the Company's vision, value, and client satisfaction. The Senior Data Analyst develops standardized reports using Power BI and SQL while leveraging Python or similar tools to automate processes and manage large datasets. The Senior Data Analyst must understand business and functional requirements and translate them into technical solutions. The Senior Data Analyst serves as the subject matter expert for enterprise reporting and analytics, partnering with business and technical teams to define reporting standards, semantic models, and business metrics. This role develops a deep understanding of the Company's industry, legacy data structures, and the new system's data model.
Duties / Responsibilities
Business Intelligence and Reporting
· Develop and maintain business intelligence dashboards and reports.
· Develop Gold Layer reports and datasets based on business requirements.
· Design executive, operational, and paginated reports using Power BI Report Builder.
· Build semantic models, DAX measures, KPIs, aggregations, and calculated fields.
· Implement Row-Level Security (RLS).
· Administer Power BI Service workspaces and report publishing.
· Define enterprise reporting standards and KPI definitions.
Business Analysis and Data Validation
· Develop a deep understanding of the Company's industry and business processes.
· Understand legacy data structures and the new system's data model.
· Validate migrated data between legacy and new systems.
· Lead requirements gathering sessions with business stakeholders.
Analytics and Collaboration
· Collaborate with Data Engineers on reporting-ready Gold Layer datasets.
· Document reports, semantic models, KPIs, and business definitions.
· Perform ad hoc analysis and process improvement initiatives.
Required Skills / Abilities
- Bachelor's Degree in Computer Science, Data Analytics, Information Systems, or related field.
- 5+ years of experience in Data Analytics, Business Intelligence, or related field.
- Advanced Microsoft Power BI (Power BI Service, Semantic Models, DAX, Report Builder) is required.
- Experience building dashboard and paginated reports.
- Experience implementing Row-Level Security (RLS).
- SQL, PostgreSQL, Python, and data modeling.
- Understanding of Medallion Architecture (Bronze, Silver, Gold).
- Advanced Microsoft Excel skills.
- Experience working with business leaders to define KPIs.
- Basic understanding of machine learning concepts preferred.
- Accounting, finance, or insurance data experience preferred.
- Excellent and clear communication skills both written and verbal in English.
- Must live local to Parsippany, NJ (this is a not a remote role)
Come join our growing team here in Parsippany! As NJ's Best Places to Work Honoree for four years in a row, we offer:
- Competitive compensation
- Medical, Dental, Vision, 401k matching, ancillary benefits
- PTO and Sick Time
- Corporate events, team and culture building activities, employee awards and recognition, company trips and more!
DOWC is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected Veteran status, sexual orientation, gender identity, gender expression, genetic information, or any other characteristic protected by law. Applicants who require accommodation to participate in the job application process may contact us for assistance
Pay: $90,000.00 - $100,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Vision insurance
Application Question(s):
- Will you now or in the future require visa sponsorship (ex. H1B) ?
Ability to Commute:
- Parsippany-Troy Hills, NJ 07054 (Required)
Work Location: In person
