Data Scientist- T-SQL, ETL, Financial

Job Title: ( Data Scientist- T-SQL, ETL, Financial)

About Kyyba:

Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively respond to organizational changes and technological advances.

At Kyyba, the overall well-being of our employees and their families is important to us. We are proud of our work culture which embodies our core values; incorporating value, passion, excellence, empowerment, and happiness, creates a vibrant and productive atmosphere. We empower our employees with the resources, incentives, and flexibility that they need to support a healthy, balanced, and fulfilling career by providing many valuable benefits and a balanced compensation structure combined with career development.

Job Description:

Qualifications:

The Sr. Software Engineer is responsible for system analysis, design, development and testing for their assigned technical product(s) or application(s), within the context of an agile/DevOps delivery model. In addition, they will extend their DevOps responsibilities to take on Operations topics and may also fill the Agile delivery roles of Business Analyst and Scrum Master.

Project Details & Day to Day:

Candidate will be focused on the delivery of data migration topics to ensure that high quality data is migrated from the legacy systems to the new systems. This may involve data mapping, SQL development and other technical activities to support Data Migration objectives.

Experience:

• • Bachelor’s degree (Major in statistics, computer science, economics, engineering or similar quantitative field preferred) or equivalent experience.
• • 5+ years of professional experience as a data scientist or similar in a corporate environment.
• • Experience using AI Tools; preferably Jupyter with Python, Data Robot, and SAS.
• • Experience using BI Tools; preferably Tableau
• • Experience using SQL; preferably Postgres SQL and T-SQL
• • 3 years leading agile project delivery for analytical topics
• • 3 years in the Financial Services or Automotive Industry (Preferred)

MUST HAVE:

• · Strong T-SQL design and development skills.
• · ETL design and development; data mapping skills and experience; experience executing/driving technical design and implementation topics
• · Strong technical analysis skills
• · Strong collaboration skills to work effectively with cross-functional teams
• · Exceptional ability to structure, illustrate, and communicate complex concepts clearly and effectively to diverse audiences, ensuring understanding and actionable insights.
• · Demonstrated adaptability and problem-solving skills to navigate challenges and uncertainties in a fast-paced environment.
• · Strong prioritization and time management skills to balance multiple projects and deadlines in a dynamic environment.

Additional skills: special skills / technical ability etc.

• · Strong knowledge of common concepts, architectures and processes in software development.
• · Well-versed in dealing with common IT technologies (e.g. Java, .Net, C#, Web, databases, Siebel, or SAP)
• · Familiarity with financial services lease and loan applications.
• · Experience in a multi-location, international environment.
• · Strong written and verbal communication skills, including the ability to sell complex topics with members of management at all levels.

Financial Services Required Learning Courses:

1. UDAAP.
2. The Gramm-Leach-Bliley Act

Key accountabilities of the function:

Analysis and Design:

• · Analyze business requirements
• · Perform technical analysis of new and existing systems
• · Triage and analyze tickets
• · Develop design documentation and other relevant collateral
• · Estimate work effort
• · Support, guide and lead other associates in the understanding of legacy systems

Development and Testing: Utilize Client FS standard practices for development and delivery of projects and maintenance tickets including the following key tasks:

• · Coding and configuration
• · Code reviews and peer consultations
• · Unit testing and unit test development
• · System, integration and user acceptance test planning, execution and testing support
• · Defect management and resolution

Operations and Support: Fulfill the breadth of DevOps tasks, including:

• · Steering providers in the execution of tier 2 support tasks
• · Resolving escalated support topics
• · Leveraging and enhancing operations and development tools
• · Planning and executing upgrades and replacements to ensure that hardware and software components remain supported
• · Executing ITSM/ITIL processes to ensure ongoing stable operations and alignment with SLAs

Business Analysis: Execute the Business Analyst Agile Role by:

• · Building a strong understanding of the assigned business processes, functions, roles and rules
• · Owning the functional solution– the big picture story – of the initiative being delivered
• · Collaborating with the Business to elicit requirements, define acceptance criteria, and maintain a prioritized product backlog
• · Creating user stories to the level of granularity required by the team
• · Clarifying inconsistencies and resolving issues to bridge the gap between user expectations and the delivered product
• · Testing deliverables against a user story’s acceptance criteria to validate that the delivered product meets the business goals

Scrum Master: Execute the Scrum Master Agile Role by:

• · Leading the Agile team in the adoption and execution of Agile processes
• · Planning and facilitating key Agile events including daily scrum, sprint planning, sprint demo and retrospective meetings
• · Collaborating with the Product Owner to manage the Product backlog
• · Clearing obstacles and enabling the efforts of the scrum team

Coordination and Administration: Support efficient work processes by:

• · Coordinating day to day activities with team members
• · Leading and mentoring other team members as appropriate
• · Coordinating release planning and off-cycle efforts
• · Resolving or escalating risks and issues
• · Executing resource planning and time tracking processes

Impact on innovations and changes:

• · Balancing speed to market, product quality and cost in the design and implementation of technical solutions.
• · Developing technical solutions that appropriately account for both evolving technology and future business requirements.
• · Executing in an evolving agile environment

Purpose and subject of the interaction/communication with internal/external interfaces, negotiating mandate

• · Close collaboration with IT colleagues and the Business in the design and implementation of technical solutions.
• · Performance of activities and interactions with our internal and external customers through verbal or written communication should reflect adherence to the company’s core values.

Education:

Bachelor’s Degree

Requirements:

• 5 - 10 years IT experience
• 3 - 5 years application development in a Microsoft environment

Preferences:

• 1 - 2 years Financial Services industry

Location:

HYBRID Position and Columbus OH

Disclaimer:

Kyyba is an Equal Opportunity Employer.

Kyyba does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. Minorities / Females / Protected Veterans / Individuals with Disabilities are encouraged to apply. All employment is decided on the basis of qualifications, merit, and business need.”

It is the policy of Kyyba to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process. If reasonable accommodation is needed, please contact Kyyba at

Rewards:

• 401k
• Term life
• Voluntary life and disability insurance
• Optional Pre-paid legal plan
• Optional Identity theft plan
• Optional Medical and dependent FSA
• Opportunity for advancement
• Long-term assignment with opportunity for hire by client

SELECT AWARDS

• An INC 5000 company for 10 years
• Corp! Michigan Economic Bright Spots
• Crain’s Detroit Business Top Staffing Service Companies in Detroit
• TechServe Alliance Excellence Award- IT and Engineering Staffing & Solutions
• Best of MichBusiness winner in HR Wizards & Partnerships
• Metro Detroit Elite Category: Recruitment, Selection & Orientation for 101 Best & Brightest
• 101 Best & Brightest Companies to Work for in Michigan