Roles & Responsibilities:
Create mapping documents for SQL ETL packages to load the Data into EDW.
Work with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data integration routines and analytics reports.
Create/Maintain Data Architecture model in SEEK_EDW Database.
Creating the reports using tools (Qlikview) and help business to make decision based on the trend’s analytics for the growth of business.
Use various transformations in PLSQL while loading Data into Staging and EDW tables like Merge, Data conversion, Derived columns, lookups and Send email notification task etc.
Collaborate with corporate and region resources to design, create, test and implement analytical tool Qlik View/Qlik Sense to design the dashboard pages. (reports and dashboards, etc.)
Manage configurations using version controls and involved in preparing training material in a way accurate, relevant and completely user friendly.
Participate in team meetings, status meetings, code review and project releases.
BS in Computer Science/Software Engineering. MS in Computer Science preferred.
Knowledge of advanced SQL and relational databases is a major plus.
2 years preferred
Irving TX / Norman OK. Open to relocate to client site
Business Computer System Analyst
Research third party applications and collaborate with developers and designers to devise, design and implement financial technology applications into client’s Wealth Management program Tableau
Research third party application and collaborate with developers and designer to create a system to optimize processing of financial data for client’s home office
Research technology solutions to integrate client’s asset allocation process and the deceased estate process for distribution of estate accounts
Collaborate with developers and designer to design and implement a new red flags system to block certain products/features/Services for deceased accounts
Work with clients’ staff and clients and collaborate with developers and designers to design data models, building dashboards & reports, building ETL processes, and implementing Data Quality & Monitoring Tools, Reporting/Analytics Tools and mapping those to optimal business solutions
Interview underwriters to analyze client’s analytics platforms, to suggest best options for data preparation services, and ultimately perform Predictive Analytics work to support client customers
Interview staff and clients to develop plan for production support of its BI / Analytics applications, root cause analysis of incidents, defect fixing, enhancements, and developing new applications
Provide analysis to clients developers for their agile development efforts, solution architecting new data initiatives.
Conduct cost-benefit assessment of new applications development and design schemes to determine the business necessity and business impact
Present analysis to internal stakeholders on applications improvements’ impact on the overall organization, including fixed and variable costs, production efficiency, sales, client satisfaction, etc.
2 years preferred
Dallas, TX. Should be open to relocate to client site.
Software Test Engineer
Required Technical Skills
2+ years of relevant QA technical experience
Contribute as an individual during test design, test planning and test execution
Experience being part of an agile/scrum methodology team
Experience testing web based applications, using browser developer tools
Able to collaborate across different functions. Work closely with product management and development teams to understand requirements and technical specifications
Develop test plans, test cases and related test artifacts, familiar with the defect management process
Experience working with API's, using browser developer tools to validate API request and response data
Ability to write basic database queries
Strong ability to define problems, collect data, establish facts, and draw valid conclusions
Excels at working in a fast-paced startup environments
Knowledge of Health Insurance Domain is a huge plus
Clear communicator (written and verbal)
Creative troubleshooting of technical problems
Ability to focus on deadlines and deliverables
Ability to think outside the box
Ability to work in a team
BS in Computer Science/Software Engineering. MS in Computer Science preferred
Knowledge of advanced SQL and relational databases is a major plus
Knowledge of performance testing concepts and tools a plus
relevant: 2 years (Preferred)
Irving TX / Norman OK. Open to relocation t client site.