Lead Business Intelligence Developer in North Hills, New York | DiversityInc Careers
This job has expired and you can't apply for it anymore. Start a new search.

Lead Business Intelligence Developer


The Lead Data Engineer is responsible for processing structured and unstructured data, validating data quality, and developing and supporting data products. The Data Engineer also plays a role in Agile planning, providing advice and guidance, and monitoring emerging technologies.  
  • Gathers and processes raw, structured, semi-structured, and unstructured data using batch and real-time data processing frameworks.
  • Understands and enforces appropriate data master management techniques.
  • Ensures data quality and implements tools and frameworks for automating the identification of data quality issues.
  • Work with internal and external data providers on data validation providing feedback and making customized changes to data feeds and data mappings.
  • Understands the challenges that the analytics organization faces in their day-to-day work and partner with them to design viable data solutions.
  • Recommends improvements to processes, technology, and interfaces that improve the effectiveness of the team and reduce technical debt.
  • Implements and optimizes data solutions in enterprise data warehouses and big data repositories.
  • Installs, maintains, monitors, and supports business intelligence, distributed computation, and big data analytics tools.
  • Provides ongoing support, monitoring, and maintenance of deployed products.
  • Actively works with less experienced data engineers providing technical guidance and oversight.

Technology We Use: Microsoft SQL Server - Database, Integration Services, Reporting Services, Analysis Services, Tabular, Python, Tableau, AWS Services.


  • Experience in design, development, and implementation of highly scalable, high-volume Analytics Systems
  • Data modelling methodologies (e.g. Star, Snowflake, Relational), data modelling tools (e.g. Erwin), data access, and data storage techniques 
  • Experience in performing data profiling, analysing data flows, and setting up best practices / processes for the Development and QA teams
  • Working as a liaison between Product Management and Data Engineers to translate business rules to technical transformations
  • Setting up batch & real-time data processing frameworks for high volume heterogeneous data using MS SSIS
  • Development and tuning of MS SQL Server Database (e.g. Tables, Indexes, Views, Stored Procedures, Functions) 
  • Experience working with Relational databases (e.g. Oracle, DB2) and NoSQL databases (e.g. MongoDB)
  • Knowledge of Business intelligence tools and platforms (e.g. MS SSRS, Tableau)
  • Working experience with application lifecycle methodologies (e.g. waterfall, agile, iterative)
  • Bachelor’s degree in Computer Science or related field or equivalent combination of industry related professional experience and education. Masters may be preferred in some areas.
  • 8 – 10 years of working experience
  • Working experience with Python and Amazon Web Services (e.g. S3, EC2, RDS, Lambda, EMR, Data Pipeline, DynamoDB)

About Cox Automotive

Cox Automotive Inc. makes buying, selling and owning cars easier for everyone. The global company’s 34,000-plus team members and family of brands, including Autotrader®, Dealer.com®, Dealertrack®, Kelley Blue Book®, Manheim®, NextGear Capital®, VinSolutions®, vAuto® and Xtime®, are passionate about helping millions of car shoppers, tens of thousands of auto dealer clients across five continents and many others throughout the automotive industry thrive for generations to come. Cox Automotive is a subsidiary of Cox Enterprises Inc., a privately-owned, Atlanta-based company with revenues exceeding $20 billion.  For more information about Cox Automotive, visit www.coxautoinc.com.  

Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual’s age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law.

Statement to ALL Third-Party Agencies and Similar Organizations:  Cox accepts resumes only from agencies with which we formally engage their services.   Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.

Organization: Cox Automotive

Primary Location: US-NY-North Hills-3400 New Hyde Park Rd

Employee Status: Regular

Job Level: Individual Contributor

Shift: Day Job

Travel: No

Schedule: Full-time

Unposting Date: OngoingAdvertisement