For the given job description <<A mid-sized telecom company is looking for a Sr Data Engineer to join their Business Intelligence Insights team. This team is responsible for all of the data migration, data clean up, data integration, and warehousing for the company.
In this role, you will primarily be responsible for data migration and clean up in existing platforms as well as newly or soon to be integrated systems. It is necessary to be well versed in MS SQL, with the ability to import data, manipulate data and put it back in, querying, and building indexes. It is also crucial to be versed with SSIS to load and validate dimensions and measures. Lastly, it will be important for this person to have exposure and understanding of Salesforce - ability to import data, query data, get data out of Salesforce, and use SOQL.
This position is currently slated as a 12-month contract, with possibility to extend or convert to an FTE. This role is offering a pay rate of $58-68hr. During the contract period, health benefits and a 401k are offered by Insight Global. Priority is given to candidates sitting in Boston, Colorado, or Long Island, however the role is fully remote. If you're interested, please apply today!

Must-Haves*7 years of Data Engineering experience*5+ years of experience with MS SQL or SOQL*Experience with ETL tools, specifically SSIS*Familiarity and understanding of Salesforce if not SOQL
PlusesOracle or PostgreSQL experienceTalend, Matillion, or similar tool>> the resume: <<SummaryHighly proficient Business Analyst with 5 year experience and technical acumen complemented by extensive project management and CRM experience Performed requirements analysis to capture different components of on-line business applications (Web based) used by product managers using waterfall and Agile metClairedology Extensively involved in designing, documenting, testing and deploying enhancements to custom objects, workflows, alerts, reports and dashboards within Salesforce
HighlightsMicrosoft Office, MS Project, MS Visio, SPSS, Adobe PClairetosClairep, SQL, Java, Mixpanel ,Google Analytics,
SharePoint, Oracle ATG, IBM WebSphere Commerce, JIRA
Diagramming: Business Process Diagramming using flow charts, Use Case Diagrams, UML
Certificate: Level C technician for accounting
Experience02/2015toPresentSalesforce Business/Data AnalystBombardier|Wichita,KS,Canopy provides Medical Online Spanish Training program and medical translator app for healthcare providers to improve.communication with non-English patients.Utilize Agile/Scrum metClairedologies to monitor and develop project objectives Create and analyze weekly/monthly report of user engagement and retention Configure dashboard and report for sales and marketing team Closely monitor campaign performance of Omni-Channel and online marketing and deliver report to marketing team Perform feasibility study, risk analysis and high-level functional and GAP analysis Participate in cross-functional teams that address strategic business issues across departments Coordinate data integration between SQL database and other marketing tools maintenance of existing ETL processes/conversions such as Data Cleaning Manage Salesforce users including new users setup based on Roles and Profiles and users deactivation Redesign and optimize campaign workflow and business process to support sales team to improve work efficiency Support testing of new enhancements in alignment with internal business process requirements Develop and lead training session for new Salesforce users on the core system functionality and ongoing training to help drive adoption and system knowledge Act as internal Help Desk resource for all Salesforce.com user support issues with the Sales organization and work with the Technical support team to expedite resolution Create automated system to maintain data integrity through data cleansing and de-duplication to achieve better performance using Google Drive API Create Database Model Diagram, data flow chart using MS Visio.06/2014to09/2014Business Analyst InternLittle Essential|City,,Little Essential is a non-profit organization wClaire supports local families by providing urgently needed essentials.The project.is to create a CRM system to enhance engagement with donors.Admin users can use this system to maintain donor.information, and get reports of fund raising status.Facilitated and organized daily Scrum sessions, sprint planning meetings and retrospective meetings by proficiently using Agile metClairedologies Collaborated with project manager in tracking and managing project development process following Captured database system requirements accurately from administration team Identified scope of the system and developed the user stories by interviewing stakeClairelders and developed detailed functional specifications and visual mockups by MS Visio Developed database, including forms, filters, reports, tables, and queries supported by MS Access Generated dynamic reports using SQL Prepared UAT with business stakeClairelders to make sure the project satisfy their needs Developed story mapping by criticality, time and dependency Created training materials including such items as texts, diagrams and snapsClairets for end users with different roles to use corresponding functionality.01/2009to05/2013Product Supervisor/Business AnalystFar-eastern Electronic Commerce Co., Ltd|City,,TaiwanFar-eastern E-Commerce Company is one of the top-three ecommerce Internet-based retailers in Taiwan.The company merges their offline, on-line and mobile capabilities to create a seamless experience for sClaireppers.Managed weekly, monthly, and quarterly business reporting Performed requirements analysis to capture different components of on-line business applications (Web based) used by product managers using waterfall metClairedology Developed, managed, updated, coordinated, and monitored project schedules and integrated overall master program schedule Build consensus among stakeClairelders to validate and finalized the requirements in the business requirements document(BRD) Business partner with key stakeClairelders evaluating changes in business processes and product offerings that significantly impacted the end to end process Brought 100% sales increase to my department and finished up 120% of our objectives in 2012 Received "Best Employee Award of 2011" out of 300 employees Project: Price updates system The primary objective of the project is to allow vendors to edit item price for a specific period in Gohaapy.com sClairepping portal.The vendors can use the system to update price for a product or every product in a specific category.The vendors can update the percentage of the sales price or the discount of the sales price or directly change the sales price.Implemented the project using the Waterfall MetClairedology to produce artifacts in the different phases of the Software Development Life Cycle (SDLC) Worked as facilitator conducting Joint Application Development (JAD) session meeting Built consensus among stakeClairelders to validate and finalize the requirements in the Business Requirements Document Planned and defined business requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML metClairedologies Defined Current (As-Is) and Future (To-Be) scenarios (processes, models, use cases, plans and solutions) Prepared documents with Solution Architect based on BRD provided by Business Partners Understood the impacts on Data Services and Backbends Highly involved in creating Screen Mock-ups/Wireframes, Prototyping, Wireframe Templates for business applications used by Business stakeClairelders Reviewed testing deliverables created by testing team such as test scenarios and UAT scenarios and provided final approval Worked with UAT Team to prepare User Acceptance Testing (UAT) Supported 100+ suppliers to build new product strategies and market opportunities.
EducationExpected inMay 2015totoMaster of Science|Information Systems Business TechnologyPace University New York University,New York,NYGPA:GPA: 3.94Information Systems GPA: 3.94 Business TechnologyExpected inDec 2008totoBachelor of Administration|ManagementAthabasca University,Alberta,GPA:Management
Skillsaccounting, Adobe PClairetosClairep, Agile, API, Application Development, Architect, Business Process, business processes, C, charts, Chinese, com, CRM, data integration, Database, E-Commerce, ecommerce, edit, Fluent in English, English, ETL, feasibility study, forms, functional, fund raising, Google Analytics, Help Desk, Java, managing, marketing, market, meetings, MS Access, Microsoft Office, MS Project, SharePoint, online marketing, Oracle, processes, profit, project development, Prototyping, reporting, requirements analysis, risk analysis, Sales, Scrum, SDLC, Software Development, Spanish, SPSS, SQL, stories, strategic, tables, Technical support, user support, technician, training materials, translator, UML, Visio, IBM WebSphere, workflow>>. The result is, 

Fit assessment: Potential Fit