Principal BI Developer
San Diego, CA

Job Description

The BI Principal Developer will provide design and implementation expertise for a SQL Server based data warehouse environment. This will involve work with data marts, OLAP cubes, dashboards and business intelligence reports. The role will include hands on development work (50%), coordination with and guidance of other team members (25%) and requirements gathering and validation (25%). The role resides within Epsilon's Enterprise Reporting (ER) team.

The BI Principal Developer will assist in implementing new reporting and analytics capability for users of the data warehouse. This is the world's largest warehouse in the automotive marketing / loyalty space and is developed, supported and deployed in a unique onsite - offshore, associate-vendor model.

Responsibilities

* Perform analysis, design, development, implementation and maintenance of Enterprise Reporting solutions.
* Develop end-to-end Business Intelligence Solutions comprising data warehouses, data marts, ETL streams, OLAP cubes, reports, and dashboards from requirements gathering to production deployment and support.
* Provide hands-on implementation and subject-matter expertise around data warehouse, data marts, reporting data and ETL sub systems for the Enterprise Data warehousing team.
* Develop, maintain, monitor, and tune the performance of the OLAP cubes and data marts.
* Create process to identify failed report subscriptions, to provide better support for critical report failures.
* Design and automate robust processes to launch, support and enhance the product suite.
* Plan, run, and manage meetings with internal and external clients (onsite and offshore) as well as run with and complete important project initiatives.
* Prepare and dispense work assignments, provide mentorship and guidance.
* Review the work of local and offshore development team members.

Skills - Must Have:

* Experience designing and developing Enterprise Data Warehouse(s) and large-scale Enterprise Reporting systems, with 100s of users.
* 6 years of experience and excellent knowledge with the Microsoft SQL Server BI stack (SSRS, SSAS, SSIS) and related.
* 2 years in the Microsoft development platform including ASP.NET,C#/VB.NET strongly preferred.
* Prior experience developing multi-dimensional data models, including Star and Snowflake schemas.
* Solid ETL development experience, SSIS framework design, with a focus on ETL development and performance.
* Development & performance tuning of OLAP Cube, MDX queries and data marts.
* Experience in multiple reporting tools and technologies including SSRS (as mentioned above)
* Excellent Communication skills including:
* The ability to thrive in a fast paced dynamic environment
* Demonstrated record of completing large projects initiatives especially with internal and external clients.
* Experience working with a geographically dispersed development team, including local and offshore resources.
* Experience in SQL Server troubleshooting, performance monitoring and tuning.
* Experience dealing with a large BI User Community (3,000 users) in a high volume, high visibility environment.
* 8 years of overall IT/software development experience

Skills - Nice To Have

* Previous Knowledge of or experience with: Pentaho (Reporting, Mondrian, Kettle).
* Kimball methodology for design of data marts.
* Hands-on Angular JS, Elastic Search, Big data, Kafka, Kudu experience.
* Other BI tools such as Tableau, Business Objects, OBIEE, Power Pivot, Power View.
* Oracle and/or Informatica in the ETL/Warehousing domain.
* Master's degree in Computer Science, Engineering, Electronics or a related discipline.
* 2 years of experience in Project Estimation, Planning & Tracking, status reporting using Microsoft Project.
* 4 years of experience in creating and maintaining strategic & tactical architecture plans.

Education

Bachelor's degree in Computer Science, Engineering, Electronics or a related discipline preferred.

Conditions of Employment

All job offers are contingent upon successful completion of certain background checks which unless prohibited by applicable law may include criminal history checks, employment verification, education verification, drug screens, credit checks, DMV checks (for driving positions only) and fingerprinting.

Great People, Deserve Great Benefits

We know that we have some of the brightest and most talented associates in the world, and we believe in rewarding them accordingly. If you work here, expect competitive pay, comprehensive health coverage, and endless opportunities to advance your career. From tuition reimbursement to scholarship programs to employee stock purchase plans and 401(k)s, we offer associates a variety of benefits that work as hard for them as they work for us.

About Epsilon

Epsilon® is an all-encompassing global marketing innovator. We provide unrivaled data intelligence and customer insights, world-class technology including loyalty, email and CRM platforms and data-driven creative, activation and execution. Epsilon's digital media arm, Conversant, is a leader in personalized digital advertising and insights through its proprietary technology and trove of consumer marketing data, delivering digital marketing with unprecedented scale, accuracy and reach through personalized media programs and through CJ Affiliate, one of the world's largest affiliate marketing networks. Together, we bring personalized marketing to consumers across offline and online channels, at moments of interest, that help drive business growth for brands. An Alliance Data* company, Epsilon employs over 8,000 associates in 70 offices worldwide. For more information, visit www.epsilon.com and follow us on Twitter @EpsilonMktg.

Alliance Data provides equal employment opportunities without regard to race, color, religion, gender, age, national origin, disability, sexual orientation, gender identity, veteran status or any other characteristic protected by law.

For San Francisco Bay Area:

Alliance Data will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of San Francisco Police Code Sections 4901 - 4919, commonly referred to as the San Francisco Fair Chance Ordinance

Alliance Data is an Equal Opportunity Employer.

Alliance Data will provide accommodations to applicants needing accommodations to complete the application process.

Any applicant offered employment will be required to establish that they are legally authorized to work in the United States for Alliance Data.

Alliance Data participates in E-Verify.

Alliance Data will consider for employment qualified applicants with criminal and credit histories in a manner consistent with the requirements of all applicable laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

#LI-JM1