Technical Architect

Description

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

Contract: 6 Month+ Extension