AddressData Warehouse/BI Developer
Summary
Title:Data Warehouse/BI Developer
ID: 2467
Department: Information Technology
Location: Buffalo, NY
Description
Job Summary
Responsible for providing advanced technical skills and leadership in the design, development, control, and use of business data. Accountable for the full cycle of consulting, design, data modeling, coding, testing and documentation of the company's data warehouse. Proactively investigates opportunities to increase the value of the data to the business and focuses on projects that improve business processes. Responsible for integration of third-party systems, including Oracle Cloud ERP as well as acquired company ERP platforms. The Data Warehouse/ BI Developer will coordinate with various teams, including IT Infrastructure, to ensure data stability and reliability.
Essential Job Functions
Serve as technical expert responsible for the architecture, design and implementation of BI/DW solutions, with accurate and complete information delivery to business users using systematic, maintainable and automated procedures.
Make recommendations about data collection methods, metrics definition, and analytical evaluation methods, in collaboration with internal and external partners.
Assist in defining and validating processes for data cleansing, integration, and transformation.
Support assigned projects and implementations, ensuring timely delivery of tasks and communication of any issues/risks.
Responsible for documentation of technical documentation, such as data dictionaries and data flow diagrams.
Lead and participate in design review sessions, testing and post-deployment activities including data accuracy validations.
Mentor and coach staff on DW/BI best practices
Manage day-to-day production operations; Ensure timely completion of enhancements, support requests and break-fixes.
Monitor and analyze performance, assessing improvements that may be needed to data queries, procedures, and/or databases.
Estimate and plan DW/BI projects, creating a detailed work plan, based on a variety of inputs (details from technical assessment, scope/assumptions in statement of work, consultation from technical team, etc.)
Implement and maintain complex queries, stored procedures, and databases.
Develops and designs database models/enhancements as well as ETL/ELT procedures to integrate needed data into existing dimensional data warehouse.
Builds, deploys, schedules, and monitors SQL Server Integration Services (SSIS) packages.
Build end to end data flows from sources to fully curated and enhanced data sets. This can include the effort to locate and analyze source data, create data flows to extract, profile, and store ingested data, define and build data cleansing and imputation, map to a common data model, transform to satisfy business rules and statistical computations, and validate data content.
Support complex reporting needs, including creation of data models, data analysis, and end user report development.
Adheres to all department and organizational policies and procedures.
Requirements
Minimum 6 years of proven experience in data warehousing and business intelligence.
Hands-on experience on at least 4-5 projects with end-to-end implementation of BI reports, preferably using a Tier-1 solution such as Tableau.
Bachelor's Degree in IT/Computer Science or technology/engineering related field.
Minimum 4 years practical, hands-on experience with two or more of the following areas of DW/BI: Reporting (Tableau, Oracle OTBI), ETL (Informatica), Data Analysis (SQL Knowledge), Data Modeling/Architecture, Development/Architecture, Information Delivery/Architecture, DW/BI Quality Assurance, Master Data Management, DW/BI Solution Architecture, DW/BI Physical Infrastructure
Preferred:
Experience with Python
Prior system development and package implementation experience using a formal methodology (SDLC, Agile, etc.)
Knowledge, Skills, and Abilities
Solid experience in analytics, data visualization, dashboarding, and data analysis/integration.
Experience in multi-platform (mobile/desktop/tablet) implementations of dashboards
Experience in handling challenges in designing mobile dashboards using tableau DSD, tableau integration in web applications using JS API.
Strong SQL skills with experience in designing data models.
Strong business acumen and the ability to translate between business and technology.
Embraces challenges, remains positive
Proactive in nature
Demonstrates high attention to detail and accuracy in work products
Flexibility in assuming additional duties not outlined in the essential job function
Demonstrated success at working across different levels within an organization
Starting salary range of $70-90k annually
Why choose Nissha to build your career?
At Nissha, you can be assured that you will be part of a dynamic, diverse team that is committed to bringing the best versions of ourselves each and every day. We recently received the “General Excellence” manufacturing award from Buffalo Business First, which highlights our dedication to quality, innovation, and sustainability. This recognition celebrates the hard work of our team in producing high-quality medical devices that meet industry standards and enhance patient care. If you are looking for meaningful work that motivates and inspires, you’ve come to the right place!
What we offer that you’ll love…
Company Culture: At Nissha, we pride ourselves on cultivating an atmosphere of teamwork where all associates feel heard and valued. We may not all think the same, and we wouldn’t have it any other way.
Diversity & Inclusion: We are committed to equity, racial justice, and equal opportunity for all.
Training and Development opportunities: Because we foster a culture of continuing education. Let’s learn and grow together!
Team Building, Connection, and Relationships: We support each other, celebrate our achievements and milestones together, and have FUN.
Retirement: We know you want to retire comfortably and we’re here to help! Nissha offers a 401(k) Retirement Plan with an attractive employer contribution.
Time Away from Work: Whether it is vacation or sick leave, we all need time to recharge. Paid time off is an essential associate benefit and a pillar of self-care.
Engagement Activities: Recognition isn’t just a once-a-year occurrence at Nissha. We celebrate our team members year-round with summer picnics, holiday parties, and employee spotlight events, just to name a few.
Commitment to Wellness: We offer various opportunities to learn about your health, be healthier, and get rewarded for your healthy lifestyle by offering reduced medical premiums.
AND SO MUCH MORE!
