Database Engineer

Amick Brown is seeking an experienced

• 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

• Bachelor’s degree in Computer Science, Engineering, 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/ 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.

• Health
• Vision
• Dental
• 401k with company match
• Paid time off
• Sick Leave
• Short-Term Disability
• Life Insurance
• Wellness & Discount Programs