At Unique IT Solutions, we beleive that our performance as a company can only be measured by the success of our clients and the personal success of our team members.
We look for intelligent, ethical, and high performing individuals who will make our clients succesful. We also look for people who will compliment our current expertise, makeup, and culture, while also expanding our capabilities and performance. When we find this sort of person, we are committed to their future growth, in their career as well as personal asperations.
If you are a person who has developed skills in our consulting arena, and you want the chance to contribute quickly, then this may be the place for you! Check out our current open positions. If you don't see one that matches your skills and asperations, but you think that you match well with what we do, then let us know!
We are looking for a strong Spotfire Data Architect who is passionate about creating meaningful expressions of data that enable business leaders to make critical decisions that position their company for future success. We want someone who is a leader in the area of data visualization and understands the role of data in true digital transformation. If you are creative in solving problems, and can leverage your skill and experience to produce highly useful solutions, then this is the role for you!
Job Description:
Collaborate with client users to understand business processes, gather technical requirements, evaluate proof of concepts, design, develop and support analytical solutions using Spotfire, SQL, Python, R, JS and HTML etc.
Partner with client architecture teams to ensure end-user reporting needs are met by the existing data warehouse platform.
Research, recommend, develop, train functional groups on reporting data discovery, data science solutions.
Responsible for developing and implementing the data models for assigned reports, dashboards and business intelligence applications including, but not limited to, gathering necessary data requirements, understanding presentation layer needs and developing the semantic layer, analytic views, virtualization layers, logical data models, working with the application DBA’ s to implement better physical data models and working with developers on solving challenging and difficult data and data performance issues.
Provides hands-on technical knowledge & leadership working with database developers, DBAs, architects, data quality analysts, and other teams as well as manages relationships within context of the individual role
Required Experience:
Requires Bachelor's Degree (prefer Masters degree) in Computer Science, Information Technology, or related field.
End to end implementation experience in building analytical solutions using data visualization tools like Spotfire, Power BI, Python, R etc.
Strong TIBCO Spotfire experience (4+ Years)
Strong Teradata experience (4+ Years)
Data Warehousing and complex SQL skills in Teradata, SQL server
Oil and Gas experience is preferred, but not required.
As an Associate Data Engineer at Unique IT Solutions, you will be a key player in our mission to provide robust reporting and data solutions. Your responsibilities will encompass developing complex mappings, optimizing SQL queries, and ensuring data quality. If you're a problem solver with a knack for optimizing ETL processes, we want you on our team.
Key Responsibilities:
Technology Documentation: Develop comprehensive technology documentation to support the ongoing maintenance of reporting and data solutions.
Complex Mappings: Develop complex mappings with various transformations and mapplets to load data into dimensions and fact tables.
ETL Analysis: Analyze ETL graphs and translate requirements from the Enterprise Data Warehouse (EDW).
Data Procedures: Design procedures for extracting data from multiple systems and loading it into the Data Warehousing system.
Data Loading: Utilize ETL processes to load data from different databases, flat files, and various sources into Oracle databases. Develop complex mappings with various transformations and mapplets to load data into dimensions and fact tables.
Performance Optimization: Fine-tune and optimize complex SQL queries to enhance system performance.
Error Handling: Implement quick error handling in code development to ensure data accuracy and reliability.
Data Quality: Identify data quality issues in source systems and document them for analysis and resolution.
Unit Testing: Actively participate in unit testing, defect analysis, and fixing to ensure data accuracy.
Qualifications:
Bachelor's degree required (prefer Masters degree) in Computer Science, Information Technology, or related field.
Proficiency in ETL development tools and methodologies.
Strong programming skills, particularly in SQL.
Experience with complex data mapping, transformations, and data loading.
Knowledge of data quality assessment and improvement techniques.
Unique IT Solutions is a Global Information Technology and Management Consulting services Company. We focus on delivering practical and enduring results, and equipping our clients to grow and lead. We deliver outstanding services to our customers in the areas of Business Process Improvement, SAP ERP Implementations, Business Analytics, SAP HANA and QHSE Compliance Management Solutions.
Offices
Unique IT Solutions Inc
800 Town and Country Blvd Suite 500
Houston, TX 77024
281-746-7720
info@unikitsolutions.com
