Sr. Business Intelligence Developer

US-CT-West Hartford
# Positions
1
Category
Information Technology

Position Description/Company Info

Legrand has an exciting opportunity for a Sr. Business Intelligence Developer to join the Legrand North & Central America Team in West Hartford, CT. The Individual in this role will be responsible for enterprise projects of Master Data Management, Data Warehouse, SharePoint, in-house, and vendor supplied application databases. Work with Enterprise Architect, BI Architect, development teams and business to deliver Business Insight to the enterprise. Responsible for extending and maintaining the information that is collected and utilized in the Data Warehouse including design and construction of the database objects, OLAP Cubes and the ETL utilizing SQL Server 2012, Visual Studio 2010/2012 and TFS 2010.

 

About Legrand

Legrand is a $5.8 billion global company with 30,000 employees world-wide and products sold in 180 countries.  As the leading provider of products and systems for electrical installations and information networks wherever people live and work, Legrand delivers an unequaled depth and breadth of innovative solutions for use in residential, commercial, and industrial buildings. 

 

Employing more than 3,300 employees across the United States and Canada, Legrand in North America has a work environment that promotes personal advancement, pride and achievement. Our success is also based on our recognition that diversity – in people, products, innovation and technology – is an important strength. When you join our team, we provide you with the tools, knowledge and skills necessary to become the very best at your job, and to continue to advance your career.  

 

Visit us at:

http://www.legrand.us

http://www.youtube.com/legrandna

http://www.linkedin.com/company/44580

http://twitter.com/legrandNA

 

Equal Opportunity Employer

 

lnarsr

 

Qualifications

Education:  

  • BS in computer science or related field or equivalent combination of education and experience
  • Microsoft MCSE, MCSM, MCITP, or MCM (desired)

Experience:  

  • 10+ years experience using Windows Server, Microsoft SQL Server, SSAS, SSIS, SSRS and DTS

Must have:

  • Skills and experience designing and constructing Data Warehouses using Microsoft SQL Server and SSAS to deliver business insight to the organization
  • Knowledge and experience of the administration of a Data Warehouse environment, and OLTP environments
  • Knowledge and experience of monitoring and support of the Data Warehouse and OLTP environments.
  • Design and construction of user facing presentation tools leveraging tools like SSRS, SharePoint, Crystal, Cognos and Excel PowerPivot

Skills/Knowledge/Abilities:

  • Experience with Enterprise Master Data management, specifically projects involving Microsoft Master Data Services, and Profisee are desired.
  • Must have a demonstrated history of successfully working with development teams within a corporate hierarchy.  Must be able to work with business users and IT staff in documenting requirements, architecting, and constructing solutions that meet the business needs. 
  • Requires strong organizational and time management skills, close attention to detail and be able to effectively handle multiple priorities.
  • Must possess excellent project management skills, including demonstrated ability to develop and manage to a project plan, establish priorities, work to deadlines and control a number of projects at various stages of work. 
  • Must have excellent verbal and written communications skills and be able to communicate effectively across all levels of the organization. Must be an effective listener, able to maintain focus extract necessary information and validate understanding of the information.
  • Experience with Enterprise Resource Planning systems (JDE, SAP, etc.) beneficial but not required.

Position Attributes

Main Job Duties:

  • Uses experience to bring best practices in Business Intelligence.
  • Manage the physical implementation of the Enterprise Data Warehouse in SQL Server.
  • Manage the partitions, index and query optimization, dimensional modeling design and changes, support with regards to slowly changing dimension attributes.
  • Manages the nightly data integration jobs loading data into the data warehouse and the master data services hub from all sources.
  • Manages the multidimensional databases in SQL Server.
  • Develop and deploy cubes, dimensions and measures, develop calculated measurements as required, manage security authorization.
  • Collaborates with and mentors other members of the Development team on a daily basis.
  • Consults with business customers to ensure alignment of projects and development efforts with business needs and strategic goals
  • Performs other similar and related duties as such as backups, maintenance plans, monitoring, and applying SQL Updates.

------------------------------------------

PHYSICAL AND MENTAL DEMANDS : The physical and mental demands described here are representative of those that must be met by employees to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 

Mental Demands

While performing the duties of this job, employees are regularly required to:

  • Use written and oral communication skills
  • Read and interpret data, information and documents
  • Analyze and solve non-routine and complex office administrative problems
  • Use math and mathematical reasoning
  • Observe and interpret situations
  • Learn and apply new information or skills
  • Perform highly detailed work on multiple, concurrent tasks
  • Work under intensive deadlines with frequent interruptions
  • Interact with managers, staff, customers, the public and others encountered in the course of work

 

Physical Demands

While performing the duties of this job, employees are regularly required to:

  • Sit, walk and stand
  • Talk or hear, both in person and by telephone
  • Use hands repetitively operate standard office equipment
  • Reach with hands and arms; and lift up to 25 pounds
  • Specific vision abilities required by this job include close vision, distance vision and the ability to adjust focus 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed