USM Business Systems Logo

USM Business Systems

FULLTIME : NETEZZA ADMIN/DEVELOPER

Reposted 20 Days Ago
Be an Early Applicant
In-Office
Oak Brook, IL
Mid level
In-Office
Oak Brook, IL
Mid level
The Netezza Developer/Admin maintains and supports the Enterprise Data Warehouse, focusing on database architecture, solutions development, and performance optimization.
The summary above was generated by AI
Company Description

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.

Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.

Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.

USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.

Job Description

Job Title : NETEZZA ADMIN/DEVELOPER

Location : Oak Brook, IL, United States

FULLTIME

Must be US Citizen or Green Card holder



JOB SUMMARY:

The Netezza developer/admin is a member of the IT Business Intelligence and Data Warehouse team and is responsible for maintaining, developing and supporting the Enterprise Data Warehouse platform housed on IBM Pure Data for Analytics

ESSENTIAL JOB FUNCTIONS:

Design, develop and deliver, and implement database architectures/solutions specifically incorporating the Netezza framework.

Perform architecture design, prototyping of concepts to proof concept, development of standards, design and development of code and module design, development of testing, data solution debugging, design and implementation of a data solution.

Convert design and user specification into database solutions. Ensure quality, functionality, reliability and usability of Netezza database solutions.

Develop database architectural strategies.

Analyze business requirements/needs and design more efficient database solutions, tables, code and procedures to improve system performance.

Work closely with Development, QA, Architects, Business Analysts and other IT staff to implement Netezza Database Administration standards, policies, methods and procedures building consensus with all parties.

Review project requests describing database user needs to estimate time and cost required to accomplish project.

Analyze software requirements to determine feasibility of design within time and cost constraints. Provide guidance in best architectural practices in maximizing the database performance.

Develop and deliver solid, scalable, robust solutions.

Participate within the DBA team to troubleshoot any issues on the Netezza appliance. Perform data analysis as required to scope projects, find bugs, and offer inferences into the product for the users.

Perform Data Migration from SQL Server to Netezza.

Plans, coordinates and implements database change migration.

Design Best Practices and efficient techniques to transfer data from various RDBMS databases to Netezza.

Design logical and physical data models written in Netezza SQL and SQL Server Procedures.

Work both data modeler and DBA to implement physical model on an ongoing bases.

Build and support required Netezza database development and test environments.

Troubleshoot difficult database problems, including slow running queries.

Perform necessary maintenance activities for database infrastructure.

Demonstrate database technical functionality, such as performance, security and reliability.

Perform database Security design and implementation.

Other duties as assigned

MINIMUM QUALIFICATIONS:

3 plus years of working with Netezza

Mastery on Linux/shell script skills

Mastery of structured query language

4 years of data modeling skills, especially for parallel databases.

Proficient at optimizing queries and tables in Netezza.

7 years of experience in data analytics and reporting

7 years of experience with Business Intelligence and Data Warehouse products

5 years ETL experience with SSIS or DataStage

Tableau experience highly desired

Business Objects experience highly desired

Goal driven and highly motivated

Proven analytical and problem solving skills

Strong customer service skills and passion to work through obstacles to produce results

Demonstrable technical thought leadership and influencing skills

Strong oral and written communication skills

Able to work in a projects-based, team environment

Proficient in multi-tasking and managing multiple projects, able to meet target completion dates

Strong organization and time management skills

Able to be flexible and adapt to change

Proficient with Microsoft Office applications

OTHER BENEFITS:

Client provides the opportunity to participate in a variety of outstanding benefits. In addition to a business casual office atmosphere, the company offers the following benefit programs:

3 medical plans

dental plan

401(k) plan

long term disability insurance

life/AD&D insurance

vision insurance

additional individual voluntary insurance plan

flexible spending accounts

scholarship award

sick pay /short term disability programs

vacation pay

holiday pay

Additional Information

All your information will be kept confidential according to EEO guidelines.

Top Skills

Business Objects
Datastage
Linux
Netezza
Shell Scripting
SQL
Ssis
Tableau

Similar Jobs

21 Minutes Ago
Hybrid
2 Locations
190K-217K Annually
Senior level
190K-217K Annually
Senior level
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
The Medicare Advantage Manager will leverage expertise in Medicare Advantage to drive client relationships, deliver data-driven solutions, and support provider engagement strategies, fostering team collaboration and ensuring high performance.
Top Skills: Data AnalyticsDigital SolutionsMedicare Advantage
21 Minutes Ago
Hybrid
Chicago, IL, USA
19-22 Hourly
Internship
19-22 Hourly
Internship
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
This internship involves assisting the Corporate Tax team with activities related to tax compliance, reporting, and support for various tax-related projects.
Top Skills: Excel
21 Minutes Ago
Hybrid
Chicago, IL, USA
68K-113K Annually
Senior level
68K-113K Annually
Senior level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Senior Data Analyst will develop credit risk management solutions and perform advanced analytics to enhance business intelligence for clients in financial services, utilizing tools like R, Python, and SQL.
Top Skills: C/C++HiveJavaMS OfficePythonRSQL

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account