Data Warehouse Developer

CGS Newport Beach , CA 92661

Posted 2 months ago

Data Warehouse Developer
CGS Business Solutions is currently accepting resumes for a Data Warehouse Developer. This position is responsible for designing, developing, implementing and supporting of enterprise databases. Candidate must have a solid understanding of Business Systems Development using SQL Server (2008 - 2017), Integration Services, Data Quality and Database Design.
Responsibilities

Complete projects and enhancement work, while ensuring requirements are documented and delivered as specified within the agreed upon timelines
Maintain and provide production support for all scheduled SQL jobs and processes
Design and develop new systems for various departments, including: Finance, Planning & Analysis, Accounting, Funds, and other teams supported by Corporate Business Systems
Gather requirements for database modifications from end-users; design, test, and implement modifications to the agreed upon specifications
Design and implementation of automated validations from various source systems based on record counts and sum totals
Maintain and provide production support for existing financial databases, including: Financial Data Warehouse, Client Data Warehouse & Assets under Management systems

Qualifications

Minimum five years of SQL database development experience.
Experience in Business Systems Development or Financial Systems Administration
Experience using SSIS importing text files, MS Excel, MS Access and XML files. Using objects like Loop containers and package configurations
BS/BA in related discipline or combination of education and experience
Experience developing and supporting Financial Systems and Databases
Experience troubleshooting performance issues and offer immediate solutions and efficiencies

About CGS Business Solutions:CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering.

CGS is honored to be selected as one of the Best IT Recruitment Firms in California. After four consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments.

Skills:
Data Warehouse/SSIS/SQL/Database
Permanent



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
lc_ad

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
Technical Lead Developer

Green Street Advisors, Inc.

Posted 1 week ago

VIEW JOBS 11/7/2018 12:00:00 AM 2019-02-05T00:00 <p>Founded in 1985, Green Street Advisors is the preeminent independent research, trading, and consulting firm concentrating on Real Estate Investment Trusts (REITs), other publicly traded real estate securities, and the private commercial real estate markets in North America and Europe.</p> <p>Green Street’s technology team is a small group of passionate technologists who are actively looking for developers who are interested in solving a wide variety of technical challenges. From data modeling and warehousing to full stack application development, we are looking for people who are comfortable diving into code, as well as collaborating with teammates, to create the next client facing app.</p> <p>The Technical Lead Developer’s primary responsibilities will include designing, architecting, and building a full stack, client facing application for our Credit Analytics team. The application will integrate Green Street’s market views with loan level and portfolio analytics. The ideal candidate will have at least six years of web development, deep Python experience in a financial setting, strong skills in MySQL, excellent communication skills, a track-record of launching successful applications, and an interest in finance or mathematics. </p><p><br></p> <p>Responsibilities</p> <ul> <li>Direct all aspects of Credit Analytics web platform from design, development, release, and maintenance</li> <li>Project manager for Credit Analytics platform working with business stakeholders, web designers, QA team, and on-site / off-shore developers</li> <li>Build and manage existing data pipelines from third party vendors</li> <li>Collaborate with quantitative team to model and productionize complex, multi-dimensional, credit analytics models and tools</li> <li>Hiring manager for future Credit Analytics developer positions</li> </ul><p><strong>Requirements</strong></p><ul> <li>6+ years of experience</li> <li>Full-stack web development<ul> <li>Python – Flask, Django, Pyramid or similar frameworks. NumPy and Pandas experience a must</li> <li>PHP – Laravel or similar MVC frameworks</li> <li>SQL – MySQL / Redshift with data engineering / modeling skills – complex queries, stored procs, views, functions, db architecture knowledge, query optimization</li> <li>CSS – Foundation/Bootstrap experience, responsive design + experience with successful responsive implementations, experience with SASS</li> <li>JavaScript – Vue.js, React, Angular or similar framework experience. </li> </ul> </li> <li>Management<ul> <li>Experience with project tracking and documentation tools – Jira, Confluence or similar</li> <li>Full SDLC experience including business requirements gathering with successful track record for implementations</li> <li>Experience working with onsite and offshore developers</li> <li>Experience working with 3rd party vendors</li> </ul> </li> <li>DevOps<ul> <li>Expertise with Source Control – Git, SVN or similar</li> <li>Experience with web application deployment, support and maintenance – CI (continuous integration) and experience with build systems (gulp, grunt, bower, composer, npm, etc.) a plus</li> <li>Experience with managing and deploying cloud-based infrastructure – Rackspace, AWS or similar</li> <li>Experience with launching and managing public cloud and private cloud containerized applications</li> <li>Expertise in Linux – e.g. able to setup and deploy web/db servers from scratch, compile and install custom packages, bash scripting, etc.</li> </ul> </li> <li>Other<ul> <li>Experience building and launching SaaS based products a plus</li> <li>Statistical or quantitative-driven programming knowledge a plus</li> <li>Commercial real estate knowledge a plus</li> <li>Commercial banking knowledge a plus</li> <li>Finance knowledge a plus</li> </ul> <ul><li>Excel expertise a plus</li></ul> </li> </ul><p><strong>Benefits</strong></p><p>Additional information on beginning your career at Green Street Advisors is available online at <a href="https://workable.com/nr?l=http%3A%2F%2Fwww.greenstreetadvisors.com%2Fcareers" rel="nofollow noreferrer noopener" class="external">www.greenstreetadvisors.com/careers</a></p><p><br></p><p><strong>Green Street Advisors, Inc. is an Equal Opportunity Employer</strong><br></p> Green Street Advisors, Inc. Newport Beach CA

Data Warehouse Developer

CGS