Epsilon is the leader in outcome-based marketing. We enable marketing that’s built on proof, not promises. Through Epsilon PeopleCloud, the marketing platform for personalizing consumer journeys with performance transparency, Epsilon helps marketers anticipate, activate and prove measurable business outcomes. Powered by CORE ID®, the most accurate and stable identity management platform representing 200+ million people, Epsilon’s award-winning data and technology is rooted in privacy by design and underpinned by powerful AI. With more than 50 years of experience in personalization and performance working with the world’s top brands, agencies and publishers, Epsilon is a trusted partner leading CRM, digital media, loyalty and email programs. Positioned at the core of Publicis Groupe, Epsilon is a global company with over 8,000 employees in over 40 offices around the world. For more information, visit epsilon.com. Follow us on Twitter at @EpsilonMktg.

Summary:

The BI Principal Developer will provide BI design and implementation expertise for a SQL Server and Greenplum based data warehouse environment.  This will involve work with industry leading off the shelf (Tableau, Business Objects, Micro Strategy, etc.) technologies as well as custom built capabilities using Angular and D3.  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 Enterprise Reporting.  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, with a focus on the BI portion.
• 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 plus years of experience with BI tools such as Tableau, Business Objects, and Micro Strategy.
• Excellent knowledge of and 6+ years of experience 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.
  • Bachelor’s degree in Computer Science, Engineering, Electronics or a related discipline
  • 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 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.

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.

Epsilon is an Equal Opportunity Employer.  Epsilon’s policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable federal, state or local law. Epsilon also prohibits harassment of applicants and employees based on any of these protected categories.

Epsilon will provide accommodations to applicants needing accommodations to complete the application process.

#LI-GG1

REF80208L