Principal SQL Server Developer
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.
•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.
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.
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. Together, we bring personalized marketing to consumers across offline and online channels, at moments of interest that help drive business growth for brands. Epsilon employs over 8,000 associates in 70 offices worldwide. For more information, visit www.epsilon.com and follow us on Twitter @EpsilonMktg.
Epsilon 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.
Epsilon is an Equal Opportunity Employer. Epsilon participates in E-Verify.
Epsilon 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 Epsilon.
Epsilon 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.
For San Francisco Bay Area:
Epsilon 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
Back to top