SantaClaraRecruiter Since 2001
the smart solution for Santa Clara jobs

Database Engineer 3

Company: Calsoft Labs
Location: Santa Clara
Posted on: August 5, 2022

Job Description:

Job DescriptionKey Responsibilities: Design and build data models to conform to our existing data 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 Airflow, DBT, Python and Microsoft SSIS. Proficiency in Python and DBT to extract data from source systems and perform data transformations programmatically. Design and development of data warehouse using T-SQL, SQL, and python. Experience working with cloud databases such as Snowflake. Ability to fine tune code and customize SQL for performance gains. Work with teams to deliver effective, high-value reporting solutions by leveraging an established delivery methodology. Implement data structures using best practices in data modeling, processes, and technologies. Design and development of data warehouse using Snowflake and Microsoft SQL Server. Writing analytics programs (transformations/calculations) in T-SQL,R, Python or comparable SQL. Knowledge and understanding of data pipelines for streaming data and integrations with C# applications. 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, 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 analyze data, and visualize/present insights.. Skill/Job Requirements: Bachelors degree in Computer Science, Engineering, MIS or related area. Masters 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/ Snowflake. 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.

Keywords: Calsoft Labs, Santa Clara , Database Engineer 3, Engineering , Santa Clara, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Santa Clara RSS job feeds