Experience: 10+ years
Location: Poland(Remote)
Requirement:
· 10+ years of hands-on experience working with Big Data and Analytics.
· At least 5 years of experience as a Data Architect, Data Engineer, or similar role
· 3+ years of hands-on experience working with PowerBI/ Fabric to design data and sematic model that support reporting and analysis.
· Knowledge of how to use aggregates.
· Understanding of normalization.
· Ability to create stored procedures and views.
· Ability to create technical documentation to explain the solution that was implemented.
· Strong communication skills, able to express code and design decisions to other technical staff and business analysts.
· Good in performance tuning especially tuning complex queries, procedure and indexing strategies.
· Able to create entity relationship diagram.
· Able to write stored procedures for highly transactional systems and data modelling.
· Understanding primary and foreign key relations.
· Knowledge of exception handling.
· Ability to process multiple records in a loop as individual transactions.
· Proficiency at creating optimized SQL statements that are scalable.
· A deep understanding of Power BI's technical aspects.
· An ability to work with data, including data cleansing and transformation.
· Creating compelling visual representations of data.
· Translating data insights into understandable narratives for non-technical stakeholders.
· Identifying and addressing data-related challenges.
Responsibility
· Design, build, and manage the information architecture of the organization
· Analyze structural requirements for new software and applications
· Develop and implement database maintenance procedures and define security requirements
· Work closely with IT team, management, and data users to create database solutions that meet and exceed organizational needs
· Migrate data from legacy systems to new solutions
· Improve system performance by conducting tests, troubleshooting, and integrating new elements
· Optimize new and current database systems
· Define and implement data strategy, policies, controls, and programs to ensure the enterprise database is reliable, secure, and accurately reflects ongoing business changes
· Conduct analysis of business data needs and develop strategies for meeting those needs through effective use of big data and analytics
· Works with users to support business applications and investigate operational problems/system requirements.
· Regularly provides coaching, guidance, and training to less-experienced analysts/programmers.
· Directs, prepares, designs, codes, tests, debugs, and maintains complex computer programs.
· Create complex functions and stored procedures, analyze queries, develop security protocols, and resolve problems.
· Develops business cases, requirements, and performance metrics.
· Design database architecture and create dashboards.
· Prepares detailed specifications from which programs will be written.
· Write complex queries for applications and business intelligence reporting.
· Under general direction, formulates and defines system scope and objectives.
· Design and improve custom data-integration procedures for individual customers.
· Establishing SQL Server Replication throughout cloud servers for scalability and availability.
· Managing migration of existing infrastructure to cloud servers.
· Provide support and streamlining of data consolidation processes.
· Connecting Power BI to various data sources, including databases, spreadsheets, and cloud services.
· Cleaning and shaping data to ensure its suitability for analysis.
· DAX knowledge and Semantic modeling required.
· Designing PowerBI data models that support reporting and analysis.
· Developing interactive and informative reports.
· Building dashboards for a consolidated view of key metrics.
· Ensuring reports and queries run efficiently.
· Working closely with business stakeholders to understand their requirements and provide data-driven insights.
Qualifications:
· Bachelor's or Master's degree in Computer Science or a related field
· At least 5 years of experience as a Data Architect, Data Engineer, or similar role
· Proven experience with data visualization tools, data migration, and scripting
· Knowledge of SQL and Java, among other languages
· In-depth understanding of database structure principles and data mining
· Familiarity with big data tools, such as Farbic, Spark, Kafka, etc.
· Experience with Machine Learning algorithms and tools is a plus
Desired Attributes:
· Strong analytical skills and data-oriented mindset
· Excellent leadership and interpersonal skills, with the ability to work cooperatively and collaboratively with all levels of employees, management, and external users.
· Ability to explain complex concepts in layman's language
· Strong problem-solving abilities, with keen attention to detail
· Excellent communication skills, both verbal and written: