lang-uk/recruitment-dataset-candidate-profiles-english huggingface dataset:
Position: BI DWH architect/Head of BI
Category: SQL
Experience: 10 years | English: upper

Lead of team ( near 50 developers), that rebuild ODS,DWH, AGG and reporting layer after migration 90% of sources ( near 700 source tables). Rebuild integration process between different system and DWH. Optimize structure of DWH, reduce sizing twice.
PLSQL/SQL (Teradata,Oracle), PC Informatica - Deep knowledge (more 10 years exp)
SAP Business Object - Deep knowledge (more 8 years exp) 
Hadoop, NoSQL, Python(AirFlow),Nifi, Informatica
Experience in Agile (Scrum)
Experience in HP Service Desc, Jira
Experience of persuasion of business desires and the formation of specific goals
I would like to work in a large interesting project (I mean project that lives more than 2 years), more closely connected with BI DWH, but it can be UI too. It could be SQL or NOSQL background.
Position: BI/DWH Developer
Category: SQL
Experience: 11 years | English: upper


Core skills
Advanced knowledge of BI/ETL/Data Warehouse technologies:
• Corporate reporting using OBIEE 11G, Business Objects 4.2, Tableau 10, Qlikview 11, PowerBI
• Data Warehouse modeling and architecture design / implementation using major RDBMSs
• ETL, data integration design / implementation using Informatica 8
• PL/SQL, T-SQL procedures & functions development
• 10+ years of working experience at a Scrum/Agile Team
• Experience of using collaboration tools and versioning and revision control systems. Jira, Git, SVN.
• Practice knowledge of SDLC including Client Interfacing, Analysis, Design, Development, implementation and support on software applications. 
• Experience with cloud and container technologies such as Docker, GCP, AWS.

Work experience
01.2011 - current , Sr. Business Objects consultant 
Business area: investment banking
• Corporate dashboards/reports development using Business Objects 4.2 (weBI)
• Universe development using Information Design Tool
• Developing Custom SQL queries to support complex logic (MSSQL 2014)
• End-user report development using OBIEE 11G, Qlikview, Tableau 10
• Data architecture design / implementation and modeling 
• participating in DWH development for Strategic MIS project in Investment bank
• Full-circle DWH and data marts development
• Data architecture design / implementation and modeling 
• ETL, data integration design / implementation utilizing Informatica 8.6
• Developing PL/SQL procedures & functions to support dataflow (Oracle 11g)

09.2019 – 05.2020, DWH/BI   consultant 
Business area: gaming
• DWH development using PostgreSQL 12, MongoDB, MSSQL 2016
• Developing advanced SQL queries/procedures to support reporting (MSSQL, PostgreSQL)
• Developing RESTful services for regulator reporting using Node.js

12.2008 - 11.2010, BI senior consultant 
Business area: FMCG
• Full-circle BI application development, 
• Design & perform pre-sale presentation for BI solution.
• Design and implement BI technical and operational architecture / frameworks 
• Data modeling using Framework Manager and data architecture design / implementation 
• model developing using Framework Manager
, reports developing, OLAP cubes utilizing IBM Cognos BI 8.4
• ETL, data integration and data conversion design / implementation 
• Developing PL/SQL procedures & functions. 

06.2006 - 11.2008, Business Intelligence cons
I\m interested in further development in Сloud solutions, so it would be great to take part in projects related that technologies.
Position: Bi Engineer
Category: SQL
Experience: 2 years | English: intermediate


I'm working as SQL/Bi dev. My key responsibilites are: creating and modifying database objects, such as tables, views, procedures, functions; creating Power BI reports, writing dax measures. Also i have experience in database/dwh modeling from previous projects
Position: BI engineer
Category: SQL
Experience: 11 years | English: fluent

Big data analytics, set of production/distribution/financial reports, team management, DWH development and support.
SQL, Tableau, Redshift, Snowflake, Airflow, Vertica, Presto, PM, BA, DWH, ETL, e-commerce, QlikView, Olap, Talend
Position: BI Engineer
Category: SQL
Experience: 3 years | English: upper


03.2021 – present (BI Engineer)
The goal is to develop and support ETL core scripts for dataloading data into clients’s databases on Vertica, create and support OLAP data cubes in custom online software. Developing and customising dimensions, metrics, measures for
showing reports, creating new reports for analysis and data on the website.
Technologies: Vertica 9.x, DBeaver, MDX Studio, Custom online software

06.2021 – 09.2021 (Trainee)
The purpose of learning was:
• What is Big Data and Data Engineering and the corresponding areas of development;
• Available tools and scenarios for its use;
• Some of the most popular technologies in this area are Spark and SQL;
• How an ETL training project can be developed;
During school, I learned how to create ETL projects using Python and Spark / SQL 
technologies. I studied is illustrated with numerous examples and reinforced by the 
implementation of practical tasks, where we created the part of ETL process in several 
technologies:
- Pure Python. 
- Python as thin client and MySQL database as back end. 
- Pure python as Spark map-reduce pattern.
- Spark Core. 
- Spark Dataframe. 
- Spark SQL
Technologies: cluster of 1 NameNode and 4 DataNode on the Google Cloud Platform
(Ubuntu 18.04 LTS, Hadoop 2.10, Spark 2.4, Zeppelin Notebook)

12.2019 – 03.2021 (BI Engineer)
The goal is to develop and support ETL scripts for dataload to clients databases on Vertica, MS SQL Server, create and support OLAP data cubes in custom online
software and Visual Studio SSDT. Develop and edit dimensions, 
metrics, measures, *.xml configurations to view reports, build new reports for analysis and data on the website.
Technologies: Vertica 9.x, MS SQL Server 2016, VS SSDT 2016, DBeaver, MDX 
Studio, Custom online software
Position: BI Engineer
Category: Data Engineer
Experience: 5 years | English: upper


3 years of experience as a Data Scientist in big product company "wp.pl" -  a group of companies operating in the media and e-commerce sector. The company's home page is in the top 100 in the world in terms of traffic and has more than 25 million unique users every month.
Some of my projects:
• Click-through rate prediction based on the article’s image using CNN. This increased article’s CTR on 9%.
• Real-time bidding floor price optimization using Reinforcement Learning. This increased RTB revenue on 5%.
• Feature Storage. Custom LSTM based autoencoder model architecture. This project made a huge impact on developing ML models based on those features: gender prediction (81%
accuracy), age prediction (55% accuracy) and many more.
• Real-time revenue dashboard using Spark, Kafka and Druid.
Position: BI Engineer
Category: Data Analyst
Experience: 6 years | English: upper


6+ years of experience in various Data Roles, including:
- More than 4 years of experience in management reporting.
- More than 2 years of experience in business analysis.
- More than 1 year of experience in BI Engineering.

- Proficiency in data visualization.
- Experience in dashboard development.
- Experience in business processes analysis and modeling.
- Experience in ETL/ELT processes development;
- Experience in data related cost optimization;

- Databricks platform usage and administration;
- Fivetran usage and administration;
- AWS;

- MS Excel, MS Power BI, Metabase.
- Python (Pandas, PySpark)
- SQL (MS SQL, Postgres, Aurora, Hive)

Inspired by complexity.
Position: BI Engineer
Category: Data Engineer
Experience: 2.5 years | English: upper


- Analysed business data, provided recommendations on solving operational issues in 5 markets
- Communicated with business users, extracted, gathered and visualised data to create a report in Power BI, which lead to improvement of business processes and metrics
- Reviewed data, checked dependencies, made changes in calculations and updated metrics which allowed team leaders track efficiency of employees which affects quality of commissions payments and overall team effectiveness
- Extracted customer related data, checked dependencies, fixed bug in call system, updated calling information so that customer loss has decreased by 11%
Position: BI Engineer
Category: Data Analyst
Experience: 3 years | English: upper


Data visualization with Power BI. Automation of legacy reports. Discrepancy investigation. Optimization of the ETL process. Highlighting business value insights. Creation of documentation. Mentoring junior position.
Position: BI Engineer
Category: SQL
Experience: 2.5 years | English: upper


Experienced BI Engineer with a demonstrated history of working in the consumer goods industry and outsource. Skilled in Tableau and Grafana business intelligence tools. Worked with Python analysis and visualisation libraries like Pandas, Matplotlib, Plotly, Dash and etc. With experience in SQL and NoSQL querying and database management
Position: BI Engineer
Category: SQL
Experience: 2 years | English: upper


I have 3 years of experience in Quality Assurance,  I have finished 5 months DWBI program where I studied T-SQL, SSIS, Tableau. I have been working for more than 2 years as BI Engineer with SAP HANA (XS Classic and XS Advanced).
I'd like to work with database but not visualization.
Position: BI Engineer
Category: Business Analyst
Experience: 3 years | English: intermediate


o	12 years of practical experience in data analysis and visualization expertise in Excel 
o	3 years of practical experience in Power BI
o	Models development for project efficiency economic indicators forecasting
o	Performing correlation and regression analysis
o	Proficient in querying data sets using SQL
o	Data models development and implementation in Python
o	Development of different scenarios and selection of the best option for the Project
o	Reports preparation and presentation
o	Intermediate English
Position: BI Engineer
Category: Other
Experience: 1 years | English: upper


Over 3 years of experience working with health care data.
Have experience in creating data pipelines using Python, Airflow, Spark, HDFS and Greenplum.
Understanding of Python architecture and design code principles.
Experience with MS Management Studio, Postgres IDEs.
Managing of team work including planning, resource management, task prioritization and estimation.
Team oriented. Having a critical eye on the results of their work and the likelihood of them being accurate.
Strong logical skills.
Experience with a variety of tools: JIRA, XMind, GitHub, PyCharm, Bash.
Good spoken and written English (intermediate level).
Position: BI Engineer
Category: Data Engineer
Experience: 2.5 years | English: intermediate


Position: BI engineer
Functional responsibilities:
• Consuming data from various sources, transforming and loading it into
databases;
• Design and support ETL processes;
• Developing and implementation stored procedures, function, CTEs, Views,
Table Relationships;
• Enhancing and maintaining existing reports and dashboards;
• Collaborating with Product teams to identify process improvement
opportunities based on in-depth Bl reviews;
• Working with client's requests(adding new fields/dimensions/metrics and
updating existing, changing logics in the stored procedures, working with
layout of files, improving joinrate between datasets);
• Working in Scrum and Kanban methodology;

Professional skills: SQL, Vertica, OLAP, MS Word, MS Excel, Autocad, Inventor, Mathcad, SolidWorks
Basic knowledge: MDX, XML, Hadoop, SVN version control system, Jira
English level: Intermediate
Position: BI Engineer
Category: SQL
Experience: 3 years | English: upper


Project: Healthcare Project (August 2019 – Present)

Developer

Provider of payment processing and information management services to the commercial and government vehicle fleet industry

Tasks and Accomplishments: 
•	Develop, implement and optimize stored procedures and functions using T-SQL
•	Review and interpret ongoing business report requirements
•	Research required data
•	Analyze existing SQL queries for performance improvements
•	Development the reports and dashboards by using SSRS
•	SSIS Packages development for Data Extracts
•	Bugs investigation and tracking.
•	Microsoft BizTalk Server 2010/2020, applications developing and administration
•	Biztalk: Experience creating message schemas and mapping message transformations

Tools, Environment, Languages and Technologies: Biztalk, TFS, SQL Server Management Studio, SSIS, SSRS


Training: BI\ETL (April 2019 – August 2019)

Trainee

Project overview:
The training includes a theoretical and practical parts. The main goals of the training are:
•	Acquaintance with BI\DWH\ETL processes; 
•	Acquisition of theoretical and practical knowledge in the creation of documentation for testing (STTs, Test Plan, Test Cases);
•	Development of test scripts and procedures for different types of ETL Testing;
•	Detailed exploration of the different approaches to the ETL testing;
•	Consideration of bug’s nature and behavior in the ETL process and ways for investigation and tracking it.

Responsibilities:
•	Designing of data model;
•	Designing of test plan / test strategy;
•	Creating Source to Target Mappings documents;
•	Load Data from Source to Target;
•	Development of test cases and test scripts, procedures for automated testing;
•	Development the reports and dashboards by using Power BI;
•	Bugs investigation and tracking.

Tools and environment: MS SQL Server, Visual Studio, Enterprise Architect, Microsoft Power BI
Languages and Technologies: Transact-SQL.

Project: Insurance Project (October 2018 – April 2019)

Software Quality Engineer

Professional insurance company providing specialist insurance services to businesses in all over the world. Worked as  RDBMS specialist on client’s  platform utilizing  SQL Server 2008/2012.
 
Tasks and Accomplishments: 
•	Helping with the validation of changes ensuring that the data remains intact 
•	Supporting development in testing a series of changes to deliver functional and performance improvements.
•	ETL testing
Иностранный гражданин. Проживаю и работаю в Варшаве. Есть украинское ИП. Могу работать удаленно, могу через офис в Польше
Position: BI Engineer (AWS)
Category: Data Engineer
Experience: 11 years | English: upper

Several ERP integrations for Ukrainian and global companies, some of them are already running for more than a decade. A couple of projects on legal and tax compliance. One of them won the ITR Americas Tax Award. But the most valuable lessons were learned from several unsuccessful projects.
The focus has been developing a Cloud-based BI Analytics Platform using Scrum methodology in the past few years. 
 - Captured data structures and business logic from Oracle DB;
 - Performed ETL using AWS Redshift, Step Functions, and Athena;
 - Configured security layer using AWS Lake Formation;
 - Modeled, built, and presented charts using Qlik Sense;
 - Validated and optimized data;
 - Implemented SDLC and CI/CD routines using Ansible, Terraform, and Jenkins;
 - Utilized Git as a version control system.
Clear communication and setting achievable goals.
Position: BI Engineer/ Data Analyst
Category: Data Analyst
Experience: 2 years | English: upper

Achievements:
1. I have successful experience in BI, in searching for insights, using MySQL, Excel, Power BI;
2. Work as BI developer, using MySQL, SQL Server, Power Bl (DAX, Power query) for reports creation.
* BI development, Data Analysis; 
* Knowledge of SQL (MySQL, SQL Server); 
* Power BI development (DAX, Power query);
* MS Excel, basics of Tableau;
* Basics of Python;
* Experience in e-commerce, ride-hailing, FMCG domains.
Position: BI Engineer / Data Analyst / SQL
Category: Data Analyst
Experience: 3 years | English: intermediate

Analytical mindset, eagerness to understand and solve problems, self-organized, proactive, highly reliable, and willing for new challenges and achievements.
3 years of commercial experience in IT, including:
- 3 years with SQL
- 2,5 years with BI tools ( Tableau, MіcrоStrаtеgу, PowerBI, QlikView)
- 2,5 years with reporting tools (MіcrоStrаtеgу, CоntrоllеrVіеw)
- 1 year as a mentor for junior colleagues

• BI Developer
– Development of Dashboards, Ad-Hoc and Detailed Reports, and drilling features for them via YAML or specific drill maps.
– Write complex SQL queries using MS SQL Server DB to investigate issues or calculations in reports and dashboards. 
– Optimization of SQL queries in Cubes for ETL process performance manipulating BI tool features to get the most efficient SQL statement that automatically generates in Cubes.
– Environment configuration in BI tool.
– Configuration of security structure, roles, and user hierarchy for data view for end users.
– Requirements clarifications and management.
– Mentoring junior colleagues.

• Data Analyst
– Reconciliation of the General Ledger and the Balance Sheet with MS Excel.
– Analysis of discrepancy, and elimination of errors after data profiling - data format converting, parsing, and data transformation.
– Development of complex ETL workflow in Alteryx tool.
– Write complex SQL queries using MS SQL Server DB.
– Preparation of control panels for further audit in PowerBI and QlikView BI tools - install financial data dashboards.


• Data Solution Developer
– Design pipelines to automate the creation of regulatory banking reports - processing, grouping, and aggregating data according to proper financial logic in the proprietary software.
– Building proper relational data models (joining client and permanent tables).
– Creation of technical solutions with fundamentals of XBRL.
Interested in opportunities for professional development and learning new technologies.
Position: BI engineer, DBA, Report Analyst
Category: SQL
Experience: 5 years | English: upper

Impala certification on Coursera, multiple Python and SQL courses via IBM, Coursera and Udemy
Half a year as a business Analyst.
3.5 years as BI engineer.
2 years as Report analyst/ DB engineer
Most of the time, I've worked in a companies that provide analytics to US Healthcare institutions (Hospitals, etc.)
Also, worked in a fintech company in a project that helped build loan systems from the scratch.
Position: BI Engineer, DB Engineer, Data Engineer
Category: SQL
Experience: 4 years | English: upper

Supported significant blocks of procedures and ETL, had experience in communicating with the customer and fulfilling non-standard requests for creating metrics and logics on OLAP, worked in the field of medicine. Mentor for New BI Engineers
Expirience with MS SQL Server, T-SQL, VSQL, DBeaver, DAX, MDX, SSIS, SSAS, OLAP, SSRS
Knowledge of Python, PowerBI, Tableau, Snowflake
Query writing and optimization
Creation of views, stored procedures, functions, indexes.
Ready to get acquainted with different offers
Position: BI engineer, Power BI developer
Category: Data Engineer
Experience: 6 years | English: upper

Dynamic RLS
Implement Partitioning
Implement SSAS perfomance analyzing
Senior Power BI Developer - develop and support 25 tabular models (SSAS), develop DWH based on MS SQL, support and create new Power BI reports.
SQL Developer - support and develop SSRS reports and chatbots logic.
Interesting tasks
Position: BI engineer (Power BI, SSIS, SSRS, SSAS)
Category: Data Analyst
Experience: 10 years | English: intermediate


- Creating SSIS packages from different data sources;
- Developing visualization in PowerBI with different level of complexity using DAX, Power Query;
- Creating reports in SSRS;
- Create OLAP and Tabular cubes;
- Create applications in LogicAPP, PowerApps.
Position: BI Engineer, SAP BI, SAP BW, SAP Analytics Cloud, Report Developer
Category: Data Engineer
Experience: 4 years | English: upper

Certificates:
SAP Certified Application Associate - SAP Analytics Cloud
SAP Certified Application Associate - SAP Analytics Cloud: Planning
4 years of experience as a BI/BW consultant:
• development of ETL processes;
• creation and maintaining of data warehouses;
• developing and maitaining of reports / dashboards;
• usage of JavaScript to create applications in SAC;
• business-users training.

Education:
• Computer Engineering - National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute”
Position: BI Engineer (Tableau)
Category: Data Engineer
Experience: 0.5 years | English: intermediate


BI Engineer with motivation to obtain professional expertise in the business intelligence field. Familiar with the basics of data analytics. I have a professional background in IT recruiting for more than 4 years, therefore, I am confident in communication and interviewing. Focused on constant self-improvement. Highly organized and reliable team player with good time management skills.

Have own pet-project where I implemented such tasks:
Wrote SQL queries, views, functions, stored procedure
Creating own DB and altering data there
Connecting to different data sources
Created reports in Tableau and Power BI
Position: BI Engineer, Tableau Developer, Data Analyst
Category: Data Analyst
Experience: 6 years | English: upper

Exploratory data analysis; 
management and operational reports; 
multiple data sources processing; 
data cleaning; 
direct contact with customers and contractors; 
development of KPIs and company performance analysis; profitability control;
•	Senior BI Engineer (from 12.2020), ( (Ukraine top 50 outsource) )
Full specter of Tableau development; support of business users and departments with Tableau related tasks and questions; development and maintenance of SSRS reports; support of some jobs in airflow.

•	Senior BI Engineer (12.2019 – 12.2020) (Ukraine top 50 outsource) 
Data modeling; evaluation of BI tools according to requirements; embedded reports; implementation of BI reports; mentoring of junior BI specialist; consultations for client and side projects.

•	Analyst/Tableau Developer (10.2017-12.2019)(Germany, remote)
Exploratory data analysis; management and operational reports; data base objects creation and optimization; multiple data sources processing; data cleaning; ad-hoc reports preparation; documentation; team members mentoring; direct contact with customers and contractors; on-site work.

•	Analyst (07.2015 – 10.2017) (USA, remote)
Periodical and unscheduled reporting; providing various analytical information to management for decision-making; development of KPIs; company performance analysis; profitability control; optimization of inventory in warehouses and development of measures to reduce overstock; inventory management (safety stock, seasonality, sales forecasting).
I'm looking primarily for remote job, preferably full-time. Possible positions - data analyst, BI specialist, Tableau developer etc.
Position: BI/ETL Developer
Category: Data Analyst
Experience: 3 years | English: upper


2+ years of experience in BI Engineering
7+ years of experience in finance, mainly reporting 
Experience in creating ETL solutions
Microsoft Certified: Power BI Data Analyst 
English: B2-C1
Highly responsible and positive thinking person