Technical Architect

Lesser Poland Voivodeship, Krakow  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.


Databases Power BI Stored Procedure Data Analysis Big Data Data Architecture Information Engineering Data Modeling Stakeholder Management Architecture Business Intelligence Business Software Spreadsheets Cloud Computing Data Cleansing Data Migration Data Mining Data Visualization Performance Management Entity Relationship Models Exception Handling Scalability Information Architecture Infrastructure Management Machine Learning Maintenance Microsoft SQL Servers Normalization Processes Performance Tuning Cloud Services Security Requirements Analysis Semantics Software Requirements Analysis SQL Databases SQL and Java (SQLJ) Technical Documentation Scripting Metrics Apache Spark Data Strategy Coaching and Mentoring Apache Kafka Data Management Safety Principles Legacy Systems


Experience: 10+ years
Location: Poland(Remote)


· 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.


· 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.


· 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

Start date
6 months
(extension possible)
N Consulting UG
Published at
Contact person:
Kirubanandam Swayamprakasam
Project ID:
Contract type
To apply to this project you must log in.