Principal Developer (Business Intelligence And Analytics)

Epsilon San Diego , CA 92140

Posted 6 months ago


The BI Principal Developer primary responsibility is to provide hands-on design and implementation expertise around data warehouses, data marts, OLAP cubes, dashboards and business intelligence reports for the Enterprise Reporting (ER) team.

Specifically, the BI Principal Developer will assist the ER Engineering and Product teams in implementing product and feature roadmaps including assisting in the expansion of the product into new verticals and markets. This is, quite literally, 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.


  • Perform analysis, design, development, implementation and maintenance of Enterprise Reporting solutions under the direction of the Director of Technology and in coordination with Project/Program Manager.

  • Develop end-to-end Business Intelligence Solutions comprising data warehouses, data marts, ETLs, 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.

  • Develops, maintains, monitors, 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, Experience and Education


  • Must Have:
  • Excellent knowledge of the Microsoft SQL Server BI stack (SSRS, SSAS, SSIS), Visual Studio BIDS.

  • Developing multi-dimensional data models, including Star schemas and Snowflake schemas.

  • Solid ETL development, SSIS framework design speed ETL development time, performance.

  • Development & performance tuning of OLAP Cube, MDX queries and data marts.

  • Experience in multiple reporting tools and technologies including SSRS, Pentaho (Reporting, Mondrian, Kettle).

  • Extensive experience coordinating with and between onsite and offshore teams. Review the work of local and offshore development team members.

  • Plan, run, and manage meetings with internal and external clients (onsite and offshore) as well as run with and complete important project initiatives.


  • Nice to have:
  • Previous Knowledge of or experience with

  • 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.


Must Have:

  • Experience of designing and developing Enterprise Data Warehouse and large scale Enterprise Reporting systems, with 1000s of users.

  • 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.

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

  • 8 years of overall IT/software development experience

  • 6 years of pure, hands on Business Intelligence Solutions comprising data warehouses, data marts development experience, including Star schemas and Snowflake schemas.

  • 6 years of experience in BI application in the Microsoft BI stack (SSRS, SSAS, SSIS), Visual Studio BIDS.

  • 4 years of experience working with offshore teams.

  • 4 years of experience in creating and maintaining strategic & tactical architecture plans.

  • 3 years of experience with Pentaho (Reporting, Mondrian, Kettle).

  • 2 years in the Microsoft development platform including ASP.NET, C#/VB.NET strongly preferred.

Nice to have:

  • 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.
  • 1 years of experience with Pentaho PDI

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 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.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Director Business Intelligence Delivery

Marsh & Mclennan Companies, Inc.

Posted 2 days ago

VIEW JOBS 10/21/2019 12:00:00 AM 2020-01-19T00:00 Company: Marsh & McLennan Agency Description: Summary The Director of Business Intelligence Delivery is responsible to manage all aspects of reporting within Marsh & McLennan Agency to ensure performance contributes to the success of the organization. Builds and champions the application of reporting, analysis tools, dashboards and business knowledge to develop and implement replicable reports, datasets, and databases to achieve performance and financial metrics. Key Responsibilities: * Provides leadership, process development and supports the successful execution of the Reporting function which maintains accurate datasets/warehouses, supplies ad-hoc and scheduled reports and is responsible for the publishing of performance reports * Leads the design, build out and maintenance of datasets, reports, and dashboards in accordance with established business requirements * Establishes and maintains data governance efforts as they relate to reporting * Partners with key stakeholders within IT and the various operational groups to ensure all data sources needed for performance reporting are defined and incorporated into the appropriate data-mart/data-set * Oversees and manages internal and vendor/virtual resources * Responsible and accountable for leading the defining, building, testing and maintenance of performance reporting infrastructure and data analysis, including the extraction, publication, and communication of reports and dashboards. * Drive collaboration in the development, documentation, distribution, and testing of new and existing reports, debugging and troubleshooting reports and code, and providing support and assisting users to ensure quality. * Identify information needed, sources, and tools to deliver analysis and reports on performance at the individual, department, and national level. * Develop monitoring, adherence and escalation processes and reporting on execution through operational use. * Defines roles, responsibilities and establishes direct accountabilities for reporting staff to ensure consistency of operations through the use of visual analytic and reporting tools and practices. * Executes Performance Management cycle responsibilities (reviews, salaries and incentives). Formulates development plans and roadmaps for new and incumbent staff to help them succeed at their job responsibilities. * Assists with the development and/or monitoring of workflow, procedures, and metrics to track employee and department productivity, gathers and analyses statistics and makes recommendation for performance improvements. * Collaborate with Leadership – provide meaningful and credible feedback on reporting capabilities, data availability and customer trend information. * Acts as liaison and partner with IT and the business process area to identify, implement and support systems and processes. * Works with and directs all resources on requirements and reviewing quality of work prior to move to production. Qualifications * Proven ability to lead a technical reporting team to success * Proven ability to manage multiple competing priorities against capacity constraints * Confidence and skill to influence individuals at all levels of the organization, with the ability to tailor messages appropriately based on audience * Must work well under pressure, managing multiple priorities and meeting tight deadlines * Excellent interpersonal skills required to deal effectively with a wide range of individuals and cultures, at all levels * Attention to detail and a passion for precision and accuracy * Strong analytical, organizational & time management skills * Utilizes creative strategies to analyze and produce effective documents * Excellent time management * A change leader with extensive knowledge on modernizing data and information * Ability to work independently, as well as collaborate with others * Some travel will be required Experience: * Education: Bachelor's degree or equivalent work experience * 5+ years insurance broker industry experience * Preferred candidate will have a background in reporting from the Sagitta agency management system or similar platform * Well versed in a technology stack including Tableau, SSRS, OLAP and Informer * Conversant in multidimensional data modeling and self-service BI * Data visualization and dashboarding * Extensive knowledge of database administration and creation * Knowledge of ETL processes, data mining techniques, database architecture, and SQL We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. Marsh & McLennan Agency offers competitive salaries and comprehensive benefits and programs including: health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers. Marsh & Mclennan Companies, Inc. San Diego CA

Principal Developer (Business Intelligence And Analytics)