Data Warehouse/BI Developer

Nissha Medical Technologies, Ltd.; Buffalo (NY); Hybrid; USD 80,000 - 95,000; Full time

Job summary

Nissha Medical Technologies is seeking a Data Warehouse/BI Developer to join their IT team. This role involves leading the design, development, and implementation of business data solutions. Ideal candidates will have over six years of experience in data warehousing and BI, with a strong foundation in SQL, Tableau, and data integration. The position supports various teams, ensuring the reliability of business intelligence data. This role is flexible, offering remote work options as well as opportunities for professional growth and team collaboration.

Benefits

401(k) Retirement Plan with employer contribution

Paid time off for vacation and sick leave

Training and Development opportunities

Team Building events and activities

Commitment to Wellness programs

Qualifications

• Minimum 6 years in data warehousing and BI.
• Hands-on experience with 4-5 BI projects, preferably with Tableau.
• Expertise in DW/BI areas like Reporting, ETL, and Data Modeling.

Responsibilities

• Design and implement BI/DW solutions.
• Collaborate with teams for data stability and reliability.
• Document technical specifications and processes.

Skills

Data Analysis

Data Visualization

Data Integration

SQL

Education

Bachelor's Degree in IT/Computer Science or related field

Tools

Tableau

Oracle OTBI

Informatica

Job description

Nissha Medical Technologies is excited to be hiring for a Data Warehouse/BI Developer to add to our IT team! This position is 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.

This position can be located at any one of our US sites or work fully remote.

Nissha Medical Technologies is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $80,000-95,000 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.

Essential Job Functions

1. 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.
2. Make recommendations about data collection methods, metrics definition, and analytical evaluation methods, in collaboration with internal and external partners.
3. Assist in defining and validating processes for data cleansing, integration, and transformation.
4. Support assigned projects and implementations, ensuring timely delivery of tasks and communication of any issues/risks.
5. Responsible for documentation of technical documentation, such as data dictionaries and data flow diagrams.
6. Lead and participate in design review sessions, testing and post-deployment activities including data accuracy validations.
7. Mentor and coach staff on DW/BI best practices
8. Manage day-to-day production operations; Ensure timely completion of enhancements, support requests and break-fixes.
9. Monitor and analyze performance, assessing improvements that may be needed to data queries, procedures, and/or databases.
10. 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.)
11. Implement and maintain complex queries, stored procedures, and databases.
12. Develops and designs database models/enhancements as well as ETL/ELT procedures to integrate needed data into existing dimensional data warehouse.
13. Builds, deploys, schedules, and monitors SQL Server Integration Services (SSIS) packages.
14. 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.
15. Support complex reporting needs, including creation of data models, data analysis, and end user report development.
16. Adheres to all department and organizational policies and procedures.

Job 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 functions
• Demonstrated success at working across different levels within an organization

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!