Responsible for analyzing the business requirements, designing and developing IT solutions to satisfy those requirements. Actively work on multiple projects and deliver solution to meet quality and time expectations. Experience in Senior Microsoft SQL Server BI Developer with strong SSIS ETL /SSAS modeling skills. Should have very good experience extracting and loading data from multiple source systems and loading into SQL Server data warehouse and developing analytics of the SQL Server data feeds. Employee must write technical requirements to support design of C#/asp.net and relative database objects needed to implement the requirements. Must be a self-starter and proactively seek solutions to assigned and organizational initiatives.
Design highly scalable and stable applications.
Understand the current relational and dimensional database schemas.
Participate in designing the changes to meet needs of new data loading and integration requirements.
Determine how to combine varied agile business needs fit into existing and new BI models.
Develop strategies for integrating data from multiple internal/external sources.
T-SQL development of stored procedures.
Develop ETL interfaces using SSIS.
Develop Cubes, Dimensions, Measures and Partitions using SSAS.
Comfortable working remotely and maintaining a high level or productivity.
Work within SDLC Processes that support IT General Controls.
Work closely with Business Analysts and Project Managers to help define a solution.
Maintain existing code base for multiple systems.
Proactively test and debug new and existing applications.
Provide advanced technical support to End-Users.
Write and maintain Technical Program Design and Specification Documentation.
Explain and discuss complex analysis and programming issues in a manner that can be understood by non-technical persons.
Develop test cases, conduct testing and document test results.
Prepare status reports, log time, and attend meetings/conference calls.
Other duties as required.
*In addition to regularly scheduled hours and responsibilities, IT staff and management are frequently required to assist on special projects and emergencies. This includes, but is not limited to, regularly scheduled evening or early morning maintenance and emergency response at any time (24x7x365). These additional responsibilities are an essential function of the job and are required to ensure continuous operations and minimize disruption to end-users.
Bachelor's Degree in Computer Science, MIS or related field desirable.
Strong knowledge of SQL Server 2008/2012 BI tools (SSIS and SSAS required).
5 + Years of ETL Development experience using SSIS.
3 + Years of modeling experience including developing Cubes, Dimensions using SSAS and MDX.
Solid relational database knowledge and experience with MS SQL Server Versions.
Strong understanding of methodologies used to implement BI solutions and Data Warehousing.
Experience data integration with enterprise applications like JDE, PeopleSoft is a plus.
Excellent communication skills and self-motivated (especially when learning new technologies). Must be able to proactively communicate issues, status updates and road blocks.
Experience with DAX/Data Analysis Expressions.
Familiarity with Data Mining Techniques and Methods.
Experience with JD Edwards structures and SQL syntax.
SQL Server Agent/Jobs, background in Microsoft .NET programming, and understanding of the full SDLC.
Strong background and adherence to structured SDLC, change management processes and Relational Databases (SQL based).
Must be able to interact with all levels of management and work well as a member of the team.
Ability to work independently and under pressure to meet deadlines.
Additional Desirable Skills:
Understanding of Infrastructure (Servers, Windows OS, Networking).
SQL Server DBA Skillset.
Redgate SQL Data Suite of Tools.
Visual Studio 2008/2010/2012 with Source Control.
JQuery Technology understanding.
ABM (NYSE:ABM) is a leading provider of facility solutions with revenues of approximately $5.0 billion and 118,000 employees in over 300...