Business Intelligence (BI)/ Data Warehouse Developer
200 Talcott Avenue South Watertown, MA 02472
As a Business Intelligence (BI)/ Data Warehouse Developer you will be primarily responsible for building/updating existing Data Warehouse using SSIS packages and SSRS reports. This position will also create/modify client facing and internal reports/dashboards across Bright Horizons.
Design, develop and implement robust and extensible ETL solutions to support key business data/data warehouse using SQL Server Integration Services (SSIS), Qlik & SSRS
Implementation/integration of business intelligence tools with data warehouse solutions
Bring data from source systems into a ODS environments.
Participate in designing data warehouse/DataMart’ s
Develop code to create Dimensions & Facts for DataMart’ s.
Review test scripts as part of all functional specifications to ensure that testing occurs to meet all business requirements including all process components as well as client, center and program configurations
Performance tuning and optimization
Configure and maintain scheduled ETL jobs
Support exploratory data analysis, statistical analysis and predictive analytics
Develop data integrations between internal and external/third party sources
Provide production support and maintain existing systems by researching and trouble-shooting any issues/problems in a timely manner
Assist in the creation of Ad Hoc/On demand Reports
Requirements analysis related to the creation and troubleshooting of reports and dashboards
User documentation for report usage and also create documentation for technical design and system build
Bachelor’ s Degree or higher in Engineering, Technology or related field experience required
5+ years of experience in Microsoft SQL Server environment with SSIS, SSRS, stored procedure development and BI Reporting tools (Qlik preferred) and visualizations.
5+ years of experience in SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
In depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
5+ years’ experience of data warehouse design (e.g. dimensional modeling)
5+ years’ Experience Design, build, test, and maintain on-premises data structures such as data marts and data warehouses
Demonstrated experience with various BI technologies
Experience managing all phases of the project life cycle, including running project prioritization meetings, post-installation project post-mortem meetings and a proven track record of managing multiple tasks and meeting deadlines
Collaboration with both onshore and off-shore development teams
Exposure to QlikSense, data mining, Dynamics CRM, Salesforce
Experience in Visual Studio
Recruiting Director, Information Technology
Vanda joined the team at The Connors Group in 2001. She believes that clients value the goal of delivering the best results in adding value to their growth strategies… Helping to connect them to a higher level of talent. Candidates value trust that she'll keep their best interests in mind when it comes to finding the right opportunity for their career. Identifying the “Je Ne Sais Quoi” helps in balancing the needs of clients with the needs of candidates!
Vanda embodies value in how she's always willing to go an extra step and be readily accessible. She knows it’s important to trust her gut instinct and has been described by others as intuitive. Vanda enjoys focusing her energy on building relationships with everyone she works with. She loves what she does and proud of the results provided in matching job seekers to opportunities with her clients.
Vanda is always striving to learn new things and improve her craft, despite an established reputation in successfully placing IT professionals for over a decade. Vanda prides herself on an established network of top talent that is unrivaled. Vanda's policy is to always treat people the way she wants to be treated and to always put her best foot forward. She likes to bring a high level of optimism, creativity, and energy to each situation. A charismatic personality and can-do attitude make her a highly sought-after Recruiter.