Data Engineer 1 : 20-03368
Employment Type : Full-Time
Primary Skills: EDW architecture, Business Intelligence / Data Warehouse, SSIS, SSAS, SSRS, SAP Data Services, CRM, Salesforce, SLT, Python, C#, JSON, T-SQL, PLSQL, SQL scripts, Tableau and Hana
Duration: 6 Months
Contract Type: W2 Only
Job Description:- Design and build data models to conform to our existing EDW architecture.
- Strong understanding and prior experience with data related security concepts such as row level security and data masking.
- Design and build data pipelines using tools - SAP SLT, SAP Data Services, Python and Microsoft SSIS.
- Proficiency in Python to extract data from source systems and perform data transformations programmatically.
- Design and development of data warehouse using T-SQL, SQL, and python
- Work with teams to deliver effective, high-value reporting solutions by leveraging an established delivery methodology.
- Implement data structures using best practices in data modelling, processes, and technologies.
- Design and development of data warehouse using Microsoft SQL Server.
- Writing analytics programs (transformations/calculations) in T-SQL, R, Python or comparable
- Knowledge and understanding of Enterprise HR Applications like HCM.
Knowledge and functional understanding of HR Functional area and related business processes - Perform data mining and analysis to uncover trends and correlations to develop insights that can materially improve our decisions.
- Development with one or more data visualization/reporting tools (Tableau, Business Objects, Hana Analytics and Microsoft PowerBI)
- Work with various product owners to ensure applications are instrumented with proper tracking mechanisms to enable analytics.
- Continually recommend, develop, and implement process improvements and tools to collect and analyse data, and visualize/present insights.
Skill/Job Requirements:- Bachelor’s degree in Business, MIS or related area. Master’s degree a plus.
- 8+ years Business Intelligence / Data Warehouse development experience
- 3+ years of experience in ETL development tools, preferably with knowledge of Microsoft
- Integration Services 2005 or greater (SSIS), SAP Data Services, SAP SLT and Python.
- 5+ years of experience in design and development using Microsoft SQL Server.
- Strong experience in full life cycle development, implementation, management and performance tuning of the Enterprise Data Warehouse
- Experience in database development (T-SQL, PLSQL, and/or SQL scripts)
- Experience in building data pipelines using python, C# and JSON
- Experience in Microsoft BI development in Integration Services (SSIS), Analysis Services (SSAS) or Reporting Services (SSRS)
- Experience building and managing data flows to and from cloud applications
- Demonstrated experience in utilizing R, Python, SPSS or comparable to develop analyses
- Experience visualizing data in business intelligence tools such as Tableau, Business Objects or Hana Analytics
- Experience and functional understanding with Enterprise applications like SAP ECC and SAP CRM, Salesforce etc.
- Strong experience with performance and scalability design and testing
- Experience creating test plans, testing and resolving data discrepancies
- Must be a self-motivated, energetic, detail oriented team player passionate about producing high quality BI & Analytics deliverables
- Strong sense of customer service for internal customers
- Medical robotics has unique characteristics that will require immersion in clinical and technical training and he or she must come up to speed quickly– an interest and desire to learn are critical
To follow up with any questions, please contact Sanket Yede at 408-907-2249
Akraya is an award-winning IT staffing firm and the staffing partner of choice for many leading companies across the US. We offer comprehensive benefits including Health Insurance (medical, dental, and vision), Cafeteria Plan (HSA, FSA, and dependent care), 401(k) (enrollment subject to eligibility), and Sick Pay (varies based on city and state laws).
If this position is not quite what you're looking for, visit akraya.com and submit a copy of your resume. We will get to work finding you a job that is a better fit at one of our many amazing clients.
Akraya is committed to equal treatment and opportunity in all aspects of recruitment, selection, and employment without regard to gender, race, religion, national origin, ethnicity, disability, gender identity/expression, sexual orientation, veteran or military status, or any other category protected under the law. Akraya is an equal opportunity employer; committed to a community of inclusion, and an environment free from discrimination, harassment, and retaliation.