Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Engineer

Expired Job

Jobspring Partners Aliso Viejo , CA 92656

Posted 3 months ago

A Finance company in Southern Orange County is looking add a Jr/Mid-level data science developer to join their team. They will be working closely with the data science team as well as the portfolio analytics team developing and maintaining of key production models. This candidate will need to be able to make changes to models, optimize algorithms to work on specific platforms as well as add connectors to relational databases. You will lead all phases of programming conceptualization, design, development, and testing.
Required Skills & Experience

Design, implement and test the conversion of existing Excel, VBA & SQL models to a Python backend
Understand the business needs and designs programs and systems that match the complex business requirements and records all the specifications that are involved in the development and coding process
Expert in Unix Shell scripting. UNIX, Python scripting have added advantage
Expert in writing efficient SQL's Oracle queries and performance tuning
Expert in Informatica ETL tool, Mapping design, Implementation, Performance Tuning and Debugging. Develop complex data extracts, applications and ad-hoc queries using Informatica Power Center
Experience in Tableau Dashboard Design and Development (quick/context/global filters, parameters, interactive views, trends and drill downs and calculated fields on Tableau (7.x))
Background with file transfer protocols like SFTP, FTP
Exposure in Data warehouse or Exposure Finance/Banking Data are added advantage
Optimize models to make models more efficient, accurate and comprehensive
Support the data science team in acquiring, cleansing and engineering data for longevity risk modeling
Other ad-hoc programming needs as needed to support other departments
Desired Skills & Experience

Bachelors degree in Computer Science, Information Technology, Engineering or related technical field required
5+ years of experience developing production level software/modeling solutions
Expert knowledge in Microsoft Excel (model building/optimization)

Problem solver, Results/Task oriented, Proactive, Independent self-starter
Presentation skills: Clear and fluent communicator. Able to discuss project issues/topics with users, present status orally and written, present demos
What You Will Be Doing

Tech Breakdown
50% Python
50% ETLs/Conversion Projects
Daily Responsibilities
100% Hands On
The Offer

Competitive Salary: Up to 110,000/year, DOE
You will receive the following benefits:
Medical Insurance & Health Savings Account (HSA)
Paid Sick Time Leave
Pre-tax Commuter Benefit

Applicants must be currently authorized to work in the United States on a full-time basis now and in the future.

Job type: Direct Hire

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Integration Engineer

Avanir Pharmaceuticals, Inc

Posted 3 weeks ago

VIEW JOBS 10/24/2018 12:00:00 AM 2019-01-22T00:00 The Data Integration Engineer will bring a broad range of analytical, technical skills and abilities to Avanir's evolving data landscape, serving as a key partner in the access, processing, integration and definition of our data assets. Primary focus will be on maintaining, scaling, monitoring and securing a variety of data warehouse products, integrating those data products across our business application ecosystem and supporting a growing need for business insights and analytics. Responsible for delivering on our data roadmap through process, development and lifecycle management; working directly with stakeholders and IT team members to define, design and deliver sustainable data systems. Essential Job Functions: As a member of the IT team, you will work closely with the data warehouse manager to ensure completion of our data priorities, innovating solutions and pushing the boundaries of our current data capabilities. * Collaborate and work with data analysts in various departments to ensure that data meets their reporting and analysis needs * Monitor data quality, identify data quality issues, oversee remediation plans, implementation of data controls, and manage data quality remediation strategies * Establish interfaces between the data warehouse, key business applications and reporting tools (e.g., Tableau, Qlik, etc.) * Participate in building the foundation for future capabilities and automation requirements in the cloud or on-premises, identify opportunities for automation and implementation of innovative, scalable solutions * Writing and tuning complex SQL, joins, and stored procedures, including T-SQL programming development (e.g. stored procedures, views, triggers, functions) and SQL Server table design (e.g. appropriate indexing) * Developing ETL integration solutions based on business needs and requirements * Data pipeline, import/export of data through various support integrations and cloud data systems * Other duties as assigned Education/Qualifications: * Bachelor's Degree in Computer Science, Engineering or similar and 4+ years of experience working with data warehouse and data integration technologies * Experience with Microsoft SQL Server (SSMS, SSIS, SSRS, SSAS) and other database technologies (Big Data & Conventional RDBMS, Microsoft Azure SQL Data Warehouse, Redshift, BigQuery, Snowflake etc.); experience implementing data engineering solutions for the same * Data warehouse infrastructure automation technologies, such as: Continuous Integration/ Delivery (CI/CD, Jenkins, Octopus Deploy, VSTS, TFS, etc.) and source control tools (SVN, Git) * Experience with Master Data Services (MDS) or Master Data Management * Data and business application integration (experience integrating with SalesForce, Veeva and/or Axtria preferred) * Coding experience in C#, Python, R and/or PowerShell are preferred * Understanding of cloud architecture, cloud data warehousing, MPP data warehousing, data lakes, and data virtualization * Proficiency with MS Office applications and common web applications * Ability to multitask effectively with critical assignments and prioritize competing demands effectively * Ability to translate complex technical ideas to a business audience through effective communication skills (verbal and non-verbal) * Core competencies for this role include: * Adapt to Change – demonstrate Organizational Awareness, Self-Awareness, Proactivity and Learning Agility * Work Collaboratively – embody Teamwork, influence without authority, and demonstrate Technical Expertise * Apply Judgment – effectively leverage Prioritization, Problem Solving and Decision-Making skills to achieve superior results Physical Requirements: This position primarily works in an office environment. It requires the ability to sit or stand for long periods of time and frequent walking. Daily use of a computer, phone, office equipment and other computing and digital devices is required. May be required to stand for extended periods when facilitating meetings or walking in the facilities. Some local travel may be necessary, so the ability to travel by plane, operate a motor vehicle and maintain a valid Driver's license and/or effectively navigate public transportation is required. While performing the responsibilities of the job, the employee must be able to read and respond to interoffice communications as well as effectively participate in meetings. The employee is often required to sit and use their hands and fingers, to lift up to 20 lbs., pull, push, carry, handle or feel. The employee is required to carry, handle items, reach with arms and hands, to stoop, kneel, or crouch; talk or hear. Mental demands may require prolonged concentration, reading comprehension, understanding and interpretation of concepts, ideas and philosophies. The physical demands of the position described herein are essential functions of the job and employees must be able to successfully perform these tasks for extended periods. Reasonable accommodations may be made for those individuals with real or perceived disabilities to perform the essential functions of the job described unless such accommodations would cause Avanir an undue burden. Work Environment: While performing the responsibilities of the job, these work environment characteristics are representative of the environment the job holder will encounter. Reasonable accommodations may be made to enable people with disabilities to perform the essential functions of the job unless such accommodations would cause Avanir an undue burden. While performing the duties of this job, the employee is occasionally exposed to moving carts, mechanical equipment (copiers, computers, coffee machines) and vehicles. May be subject to smells and odors. The noise level in the work environment is usually quiet to moderate. The passage of employees through the work area is average and normal. EEO Statement: As an equal opportunity employer, Avanir Pharmaceuticals is committed to providing all applicants and employees with equal access to employment opportunities, regardless of sex, race, age, color, national origin, ancestry, disability, pregnancy, religion, genetic information, sexual orientation transgender status, gender identity, marital status, military or veteran status, or any other characteristic protected by federal, state, or local law. All Avanir Pharmaceuticals employees, officers, principles, agents, and representatives are expressly prohibited from engaging in unlawful discrimination. Consistent with federal, state, and local requirements, Avanir Pharmaceuticals will reasonably accommodate any qualified individual with a disability if such accommodation would allow the individual to perform the essential functions or the job, unless doing so would create an undue hardship. Avanir Pharmaceuticals shall abide by the requirements of 41 CFR-60-300.5(a) and 60-741.5(a). These regulations prohibit discrimination against qualified individuals on the basis of protected veteran status or disability, and require affirmative action by covered prime contractors and subcontractors to employ and advance in employment qualified protected veterans and individuals with disabilities. Avanir Pharmaceuticals, Inc Aliso Viejo CA

Data Engineer

Expired Job

Jobspring Partners