search > Brooklyn jobs > Brooklyn computer/technical

Posted: Friday, July 7, 2017 11:14 PM

RESPONSIBILITIES:Kforce has a client seeking an ETL Programmer in Brooklyn, NY. Performing as a member of an Agile development team, this position will ensure the successful design, testing, and deployment of integration deliverables for highly complex business operations. Responsibilities include:* Translating high-level technical specifications, designing and developing the data models and data migration plans, and ensuring a smooth systems implementation, heavily focused on data analysis* Programs data queries, data transformations, load jobs, and data extracts using SQL and stored procedures in MS SQL Server* Participate in database programming and data extraction, transformation and loading of data into consolidated data marts that will be used for MIS reporting, operational dashboards, analytical modeling, and custom reporting applications* Actively participate in working sessions to help define system requirements pertaining to the design and building phases for all data related systems* Responsible for documenting business requirements associated with all data integration projects/processes* Lead activities around the functional design, architectural design, test case design, and system testing to ensure all client requirements are met* Perform complex analysis of data emanating from multiple source systems used to support special education reporting* Defines strategies and standards for Business Data IntegrationREQUIREMENTS:* A baccalaureate degree from an accredited college and four (4) years of full-time paid experience in the fields of operations management, computer science, mathematics, statistics or a related field; or A satisfactory combination of education and experience* Advanced SQL development skills: SSIS, SSRS, SSAS* 3+ years in a hands-on integration development role* 2+ years and high proficiency with SQL scripting skills* 3+ years of experience in a large scale, full life cycle ODS and Data Mart program* Extensive experience in data modeling* Ability to work with database administrators, application designers and developers, business analysts and end-users to define the informational needs of the organization* Demonstrated experience in data mapping and data conversion* High level of expertise required for complex SQL commands (apply, cross joins, and dynamic SQL), SAS and Microsoft Excel (pivot tables) for auditing and report creation* Comfortable navigating large quantities of data* Strong analytical, conceptual, problem solving and trouble shooting skillsDESIRABLE SKILLS/EXPERIENCE: * Experience in performing data analytics, data modeling and testing activities in a large data project* Demonstrated experience in building service-oriented relationships and providing successful consultative support* Technical writing skills* Requirements management* Business intelligence analysisKforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. - provided by DiceAnalysis, Analytical, Application, Applications, Business Intelligence, Business Requirements, CASE, Computer, Data Analysis, Database, Data Mart, Data Modeling, Development, Excel, Management, Microsoft Excel, Modeling, Programmer, Programming, Project, SAS, SQL, SQL Server, System, Systems, Technical Writing, Test, Testing


• Location: Brooklyn

• Post ID: 117497863 brooklyn is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017