Create an etl (receiving/sending data via api) and create the predictive analysis using bigdata and integrating with machine (federated) learning models.

Category: IT & Programming
Subcategory: Data Science
Project size: Medium
Is this a project or a position?: Project
Required availability: As needed

The role calls for an Data and ETL developer. You will responsible for implementing data acquisition, loading, and transformation into the Enterprise Data Lake. You responsibilities includes implementation, enhancement, and maintenance of applications that deliver analytical solutions to the healthcare industry.


This role will be a technical expert collaborating with the Product Team and other local and remote Developers to develop to deliver data storage, transformation, visualization, and analytical applications.

You will be joining a team of professionals working on a suite of products that are being used inside the operating room in the US. You will maintain client-specific data transformation scripts, create new transformation scripts for new customers, and enhance the core ETL system as needed.

This is a full-time position with a 40-hours workload per week.

Your responsibilities

Analyze business requirements and outline solutions.
Design and develop etl and elt solutions using sql, shell scripting, snwoflake, and other tools.
Analyze data requirements, complex source data and the data model to extract, transform and load the data into the data lake, data warehouse, and other systems.



Create or update technical documentation and processes flows.
Develop automated build, test, and deployment processes.
Manage administrative tasks such as system deployment, scheduled jobs, and configuration changes.



Monitor running systems including production; troubleshoot and resolve service issues.
Work independently and collaboratively with a team both in-person and virtually.
Continuously strive for high-performing business solutions.

Category: IT & Programming
Subcategory: Data Science
Project size: Large
Is this a project or a position?: Project
Required availability: Full time

We are looking for a Senior Data Analyst for one of our Clients. This is a long term project/ 40 hours per week. The applicant should be in latin america, and feel comfortable on having calls in english.


These are the skills we are looking for this project:

Ongoing Reporting and Analysis (50%)
•    Prepare monthly reports using BI application Metabase and Excel.
•    Review report results for accuracy and unexpected metric trends.
•    Answer questions from the business.
•    Perform quick ad hoc analysis using Redshift SQL and Excel, and present findings.
•    Perform ongoing data discovery and data mining for new information in various data sets.

Apply discoveries to the reporting solution by updating existing Python ETL and database lookup tables.

Improve Reporting and Analytics Solutions (20%)
•    Maintain and promote consistent metric definitions.
•    Manages and improves existing BI app queries to increase accuracy, performance and readability using Redshift SQL functions.
•    Optimize long running queries on AWS Redshift or Aurora MySQL.
•    Build automated solution for generating the monthly reports.

Expand Reporting and Analytics (30%)
•    Expand existing AWS Redshift data warehouse model to support future insights.
•    Develop AWS serverless data processing solutions using Python.
•    Design and build easy to understand reports and dashboards that surface the performance of the Key Metrics.



Core Skills:
•    Data Warehousing and ETL techniques.
•    Data analysis including discovery, profiling, mining, cleaning and aggregating.
•    5+ years of experience with SQL expertise including analytical and window functions.


•    Knowledge of KPIs, measures, dimensions, parameters, filters, and aggregations.
•    Report development using BI data visualization tools similar to Metabase, Looker or Tableau.
•    Advanced in Microsoft Excel.


•    2+ years of experience in building data solutions and analysis using Python.

Bonus points for:
•    Prior experience with AWS.
•    AWS certification.
•    Development in GoLang.

Category: IT & Programming
Subcategory: Data Science
Is this a project or a position?: Project
Required availability: Full time

Audit and Monitoring
Configuration
Licensing
Security
Workspace
Power BI Premium
Power BI Embedded
Visual
Mix
Deployment Pipelines

Category: IT & Programming
Subcategory: Other
Project size: Large
Is this a project or a position?: Project
I currently have: Not applicable
Required availability: As needed
API Integrations: Other (Other APIs)
Roles needed: Developer, Other
Other roles needed: Administrador

The ETL Developer will be designing, building, and supporting data processing pipelines to transform data using Microsoft technologies.  You will be implementing our Data Integration platform for the Microsoft SQL Server Integration Services

(SSIS) environments. You will be implementing data flow transformation scripts using T-sql and vb or c# scripting.


You will be developing and executing quality assurance and test scripts. You will be work with product owners and business analysts to understand

business requirements and use cases to design reporting solutions using Power BI.  You will lead investigation and resolution efforts for critical/high impact problems, defects, and incidents.


Provides technical guidance to team members.

Skills required
Bachelor's degree in Computer Science or related discipline
Experience with a structured application development methodology, using any industry standard Software Development Lifecycle, Agile Methodologies is required
6+ years of overall experience in I.T. With strong understanding of best practices for building and designing ETL code, Strong sql experience with the ability to develop, tune and debug complex sql applications is required
5+ years of experience in etl tools. Specific expertise in implementing SSIS in an Enterprise environment is a plus.
Hands-on experience in scripting object-oriented programming in VB or C# (At least 2 years)
Hands-on experience with SQL Server in the Azure cloud either with iaas or saas models.



Strong SQL experience with the ability to develop, tune and debug complex SQL applications is required
Experience in real time data ingestion into Hadoop is required
Experience with Test Driven Code Development, SCM tools such as GIT
Experience with DB2 is preferred
Strong with SQL Server, DB2, Cosmos database and Managed SQL Server instances (Azure) preferred
Excellent analysis, debugging and trouble-shooting skills, and problem-solving skills
Good verbal and written communication skills
Ability to thrive in a flexible and fast-paced environment across multiple time zones and locations
Experience in the Healthcare industry is a plus but NOT required

Category: IT & Programming
Subcategory: Other
Project size: Medium
Is this a project or a position?: Project
I currently have: Not applicable
Required availability: As needed
API Integrations: Other (Other APIs)

We are looking for a freelance to give us 40 hours of support and training of B2B Data Exchange Informática product to start ASAP: https://www.informatica.com/es/products/data-integration/b2b-data-exchange.html

We are currently using:
• Informatica Powercenter
• Informatica Data Quality
• Informatica B2B Data Exchange
• Informatica Managed File Transfer


Buscamos una persona que nos de soporte/formación de 40 horas del módulo B2B Data Exchange del producto Informática para empezar inmediatamente: https://www.informatica.com/es/products/data-integration/b2b-data-exchange.html

Actualmente usamos:
• Informatica Powercenter
• Informatica Data Quality
• Informatica B2B Data Exchange
• Informatica Managed File Transfer

Category: IT & Programming
Subcategory: Other
Project size: Small
Is this a project or a position?: Project
I currently have: Not applicable
Required availability: As needed
Experience in this type of projects: No (I haven’t managed this kind of project before)