Wednesday, September 18, 2013

Sr. BI Developer (SSRS / SSAS / SSIS) Job

Job Title: Sr. BI Developer (SSRS / SSAS / SSIS)

Job ID: 18569

Location: San Diego, CA, US

Full/Part Time:

Regular/Temporary: Regular

Line of Business:Epsilon

About the Opportunity

The BI architect’s primary responsibility is to provide hands-on design and implementation expertise around data warehouse, data marts and business intelligence reporting data and the ETL sub systems for the Enterprise Reporting (ER) team.

The BI architect will evaluate user requirements from both a strategic and tactical point of view, propose alternate solutions, gauging the impact of each, and once finalized, create technical specifications, and design the solutions to meet business needs.

The BI Architect will also lay out the roadmap for modifying the existing ETLs to make them more robust and scalable. 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. The members of the ER team are spread across continents and time-zones.

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

* Design and oversee the development of complete data warehouse reporting and business intelligence solutions for Fortune 500 clients.

* Develop data warehouses, data marts, OLAP cubes, reports, and dashboards for BI and Mobile BI Solutions

* Design, maintain, monitor, and ETL solutions including, Informatica and SSIS, to incrementally load Enterprise Data Warehouse and Enterprise Reporting systems.

* Provide a creative source of ideas/solutions to address problems – strategic and tactical.

* Design the necessary automated and robust processes to launch, support and enhance the ER suite.

* Assist with supporting, migrating and refactoring reports, dashboards, and mobile BI solutions.

* Contribute to the improvement of the efficiency of data warehouse team, through scripts, tool code, component development or methodology enhancement.

* Develops, maintains, monitors, and tune the performance of the SSAS OLAP cubes and data marts

* Cooperate with the Quality Assurance team to define test cases, metrics, and resolve questions about test results; assist Quality Assurance team with the maintenance and integrity of the QA environment.

* Demonstrate the ability to plan, run, and manage meetings with internal and external clients (onsite and offshore) as well as run with and complete important project initiatives.

* Help build positive relationships between business users and IT staff and between various teams in the IT function.

* Proactively mentor team members on project related issues, while leading and motivating by example.

* Work in a team environment. Clearly communicate problem/resolution process to management.

* Document and share knowledge with the team. Help produce "run books" and SOPs to ensure operators can monitor and address any issues that arise in production.

* Assist in defining software development project plans, including scoping, scheduling, providing time estimates for programming tasks and implementation plans and schedules.

* Prepare and dispense work assignments, provide guidance, and/or review the work of local and offshore development team members.

* Maintain a current awareness of technological developments and trends as it relates to databases, development methodologies and tools, especially in the BI, Data Warehousing and ETL space

* Develop technical documentation to define the system components, development environment and implementation planning/strategies.

* Deliver high-quality solutions to business owners to ensure alignment of technical solution with business objectives

The above outlines the principal work and responsibilities in the job and does not specify each and every task that might be performed.

* Excellent knowledge of SQL Server 2008 stack (SSRS, SSAS, SSIS). Visual Studio BIDS, TFS.

* Previous Knowledge of or experience with Oracle and/or Informatica helpful.

* Knowledge of other BI tools very useful, including Change Data Capture tools

* Experience developing multi-dimensional data models and awareness of the advantages and limitations of Star Schema and Snowflake schema designs.

* Solid ETL development, SSAS development, SSRS reporting experience all based off of intricate understanding of business process and measures.

* Creation & tuning of Stored Procedure and MDX queries, Report development, SSIS package development, ad-hoc reporting in response to business reporting initiatives.

* OLTP data modeling, process flow, stored procedure creation/tuning, ETL, strong application team interaction including understanding of the underlying data structures.

* Ability to quickly discern the most relevant facts and recommend the quickest, most practical and safest approach to resolving an issue with a program or database.

* Excellent impact-analysis skills and discipline. Carefully analyzes the existing code base as part of each design effort, to avoid redundancy and inconsistency and maximize code reuse. Proven analytical and problem-solving abilities.

* Able to decompose and solve problems at the appropriate level within the system, keeping in mind the higher-level structures and their requirements and dependencies with adjoining subsystems.

* Strong logical/analytical skills with a keen ability to anticipate and avoid problems.

* Ability to define and implement migration strategies from legacy systems to new architecture and technologies.

* Work well within a team environment, and have the will and the ability to succeed in an environment that includes offshore development. Frequent night and weekend work is required for offshore development management and assistance with scheduled code releases.

* Ability to work within tight deadlines and effectively prioritize and execute tasks in a high-pressure environment.

* Outstanding communication skills (verbal and written) and an ability to communicate with internal and external customers and all levels of management, including communicating technical information to nontechnical audiences.

* Attention to detail and the ability to manage several tasks at once.

* Clear understanding of Systems Development Life Cycle (SDLC) methodology and respective experience with its application in design and development phases

* Excellent understanding of coding methods and best practices. The software engineer's code must be worthy of being held up as an example for others to follow, in terms of readability, consistency, adherence to standards, and performance

* Recognizes good opportunities for code and module reuse, and ensures that the code is designed and implemented accordingly.

* Ability to review the designs, code and test plans of other engineers and developers.

* Strong listening skills; ability to capture requirements expressed in design meetings.

* Flexible and adaptable in regard to learning and understanding new technologies.

* Highly self motivated and directed.

* Experience with source control systems (VSS, TFS, etc.) preferred

* Previous experience of designing, developing and enhancing large scale SQL Server 2008 R2 data warehouses, preferably in a multi-terabyte environment.

* Experience dealing with a large BI User Community ( 3,000+ users ) in a high volume, high visibility environment.

* Experience in performance tuning, application monitoring and support of production applications.

* Experience working with offshore teams preferred.

* 5+ (Sr. Dev) or 8+ (BI Architect) years of overall IT/software development experience

* At least 4+ years of pure, hands on BI development experience strongly preferred.

* At least 3+ years in the Microsoft development platform including Visual Studio 2010, Transact SQL, C#,, ASP.NET 2.0 or later strongly preferred.

* Development experience in MS SQL Server with good software methodology/practices. Working knowledge of Oracle PL/SQL preferred.

* Experience in automotive marketing and/or CRM applications preferred.

Compensation and Benefits

Alliance Data offers a competitive salary, a comprehensive selection of benefit options including 401(k).

About Us

Epsilon is the industry's leading marketing services firm, with a broad array of data-driven, multichannel marketing solutions that leverage consumer insight to help brands deepen their relationships with customers. Services include strategic consulting, acquisition and customer database technologies, loyalty management, proprietary data, predictive modeling and a full range of direct and digital agency services, including creative, interactive web design, email deployment, search engine optimization and direct mail production. In addition, Epsilon is the world's largest permission-based email marketer. Epsilon is an Alliance Data company. For more information, visit call 1.800.309.0505.

News Source


Post a Comment

Copyright © . Search job listings to find a job online in USA - Posts · Comments
Theme Template by BTDesigner · Powered by Blogger