**OTSI** (**Object Technology Solutions, Inc**) has an immediate opening for a Business Systems Analyst V
BUSINESS SYSTEMS ANALYST V (HYBRID/COSTA RICA)
MAJOR RESPONSIBILITES:
- Use reports and dashboards to tell a story with data; test assumptions, simplify complexity, and demonstrate business impact; turn complex data into beautiful and simple-to-understand visualizations in Tableau
- Collect, organize, cleanse, aggregate andanalyze significant amounts of information and massive datasets in SQL and DBMS, Excel, Python and/or R. Find and fix issues and debug into anomalies.
- Work with business intelligence/reporting systems such as Tableau, Power BI Business Objects, Microsoft Excel, SharePoint and other Office products.
- Create clean, clear, accurate, and attractive self-service Tableau dashboards to inform VMware IT product owners of the health, adoption, or utilization and relative support workload for their products.
Predict trends to help prioritize product improvements.
- Develop report/models and batch queries for data using scripting languages such as SQL, R, Python.
- Use data-driven insights to recommend opportunities to improve the employee experience of technology.Explore, test, and recommend innovative solutions.
- Data Modeling BI and Data Warehousing solutions
- Performs technical troubleshooting, code debugging, and problem solving for custom built data warehousing solutions
- Assists in implementing effective business analytics practices that drive improved decision making, efficiency and performance
- Communicate with nontechnical business users to determine specific business requirements for reports and business intelligence solutions
- Identifies, communicates, and resolves data quality and data reconciliation issues
- Participates in and supports all planning and problem resolution
- Performs independent audits and reviews and validates databases to ensure data integrity
- Develops and enforces standards and procedures for the storage and retrievalof institutional data
- Maintains an accurate and comprehensive inventory of data, data systems, and data storage
- Processes data extracts using data retrieval and management tools
- Builds effective partnerships with coworkers throughout the University by freely sharing appropriate information and providing assistance when needed
- Ensures optimum service to all internal and external partners in response to all requests for service and information
- Establishes and maintains effective collaborative and cooperative working relationship with all segments of the University and its community
- Protects confidential information
QUALIFICATIONS AND EXPERIENCE:
- Strong knowledge of Tableau, Power BI, Python and Advance Analytics
- Possesses strong analytical and troubleshooting skills
- Knowledge of SQL and data warehousing concepts
- Ability to use presentation, word processing, and database or spreadsheet software
- Demonstrated attention to detail on ensuring the accuracy and efficiency of the data warehouse and the individual work units
- Demonstrated detailed knowledge of BI areas including ETL design, analytics and reporting
- Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences
- Self-motivated; able to work within a project based environment
- Ability to work in a team environment
- A Baccalaureate or a Master's degree in a relevant field is required
- 2-3years in business intelligence, Data Science, Visualization and data warehousing environments
- MS SQL Server, Integration Services and Reporting Services required
- Strong TSQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques
- Demonstrated experience in data extraction and manipulation, ETL techniques required
About us
Founded in 1999 and headquartered in Overland Park, Kansas, OTSI offers global reach and local delivery to companies of all sizes, from start-ups to Fortune 500s.
Through offices across the US and around the world, we provide universal access to exceptional talent and innovative solutions in a variety of delivery models to reduce overall risk while optimizing outcomes; enabling our customers to thrive in a global economy.
Join us today, as we assure you 1500+ friends and a great career; Happiness begins at a great workplace...!
Working with OTSI gives you the assurance of a successful, fast-paced career.
Exposure to infinite opportunities to learn and grow, familiarity with cutting-edge technologies, cross-domain experience and a harmonious environment are some of the prime attractions for a career-driven workforce.
Feel free to refer this opportunity to your friends and associates if you are not available.
We have a referral policy.
**Job Type**: Contract