Business Intelligence / Data Warehouse Developer (Manlius, NY)

Business Intelligence / Data Warehouse Developer

General Description/Purpose:

The BI/DW Developer is responsible for meeting with Business Unit Leaders to integrate new quantitative metrics and/or processes into the overall data warehouse platform to expand capabilities and functionality. The BI/DW Developer is responsible for ensuring data integrity and report consistency across all data warehouse reporting. Additionally, the position ensures frequency specific reporting is completed and distributed to our internal decision makers as well as external customers. Responsible for gathering business requirements, analyzing business needs, defining the BI/DW architecture to meet & support and participate in the delivery of technical solutions to complex business and technical requirements.

Job Responsibilities:

• Ability to build, test, and maintain SSIS/ETL architecture and processes using strong modular system design skills
• Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse and operational system; Validate that the operational system and data warehouse meets specified requirements
• Implement and maintain complex queries, stored procedures and databases.
• Builds, deploys, schedules and monitors SQL Server Integration Services (SSIS) packages.
• Lead and participate in design review sessions, testing and poste-deployment activities including data accuracy validations.
• Manage successful delivery of BI projects and mentor and coach staff on DW/BI best practices.
• Work with other members of the team and make sure that routine data loads are completed properly without any issues and report weekly load status to supervisor.
• Ability to work independently on routine data loads with a minimal amount of supervision.
• Analyze and QA data from different sources and ensure that it is properly loaded into our systems
• Investigate data quality issues and implement appropriate solutions
• Responsible for performance tuning of database functions, SQL queries, stored procedures and SSIS packages to ensure scalability demands are satisfied and will be responsible for monitoring the production jobs, and other database activities (Backups, recovery, etc).,
• Ability to manage individual priorities and tasks and coordinates with other team members and supervisor to meet such timelines and actively contributes to project status reporting processes to identify and mitigate risks.
• Requirement gathering business requirements, analyzing business needs, defining the BI/DW architecture to meet & support and participate in the delivery of technical solutions to complex business and technical requirements all belonging to different departments and divisions to ensure smooth implementation and running of the applications

Required experience/Education:

• Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server 2012 or later.
• Proven experience driving integration between source system and the data warehouse.
• Strong experience in extraction, transformation, and load processes from multiple source format files and systems into operational systems into the data warehouse.
• Experience in multi-server data management and database administration functions.
• Excellent work ethic, organizational, analytical, planning, problem solving, and communication skills are a must.
• Bachelor’s degree in computer science engineering, mathematics, statistics, information technology, Business Administration required.
• Minimum 6 + years of extensive experience in Data Migration, Data Load, Data Analysis, Parsing, Cleanup, Validation & Management, SQL Server Integration Services (SSIS) and ETL design and development & T-SQL programming using SQL Server 2016/2014/2012.
• OLAP development (cube design, fact, dimension structure, Data Mart development, etc) experience will be a big plus.

Benefits:

We offer a competitive compensation and a comprehensive benefit package that includes:

• Paid vacation
• Group health, prescription drug, dental insurance coverage
• Company paid life insurance
• 401(k) retirement plan
• Flexible spending account
• Generous employee discount

Stickley is an equal opportunity employer committed to diversity and inclusion