SQL Jobs

2 jobs found

summ-it

About the Role Join summ-it as a Data Quality Analyst and become part of a dynamic team that creates innovative solutions for world-renowned brands. If you're passionate about mastering cutting-edge technologies while working in a collaborative, non-corporate environment, this opportunity is perfect for you. At summ-it, we prioritize your professional growth and provide space for your ideas to flourish. Our team members actively participate in industry conferences and IT events, continuously developing their expertise through comprehensive training sessions and workshops. You'll work with massive databases totaling petabytes and optimize systems where every millisecond matters, currently managing over 10,000 database systems for our diverse client portfolio. Key Responsibilities Data Quality Monitoring: Continuously monitor and ensure data quality across multiple systems, reports, and data pipelines to maintain the highest standards of data integrity Test Design and Execution: Design, develop, and execute comprehensive data quality tests focusing on completeness, consistency, accuracy, and validity metrics Cross-System Verification: Perform detailed data verification and reconciliation between different systems, ensuring seamless data flow from source to target environments Data Analysis and Anomaly Detection: Analyze complex datasets to identify data errors, anomalies, and inconsistencies, implementing corrective measures and preventive solutions Cross-Functional Collaboration: Work closely with Data Engineering, Business Intelligence, and business stakeholder teams to investigate and resolve data quality issues efficiently Pipeline Validation: Participate in comprehensive data validation processes within ETL/ELT pipelines, ensuring data accuracy throughout transformation workflows SQL Development: Create, optimize, and maintain complex SQL queries specifically designed for data quality control and validation processes Test Automation: Develop and implement automated data quality testing frameworks using Python and specialized testing tools to improve efficiency and coverage Documentation and Standards: Create detailed documentation of processes, test procedures, and identified issues while supporting the implementation of enterprise data quality standards and best practices Continuous Improvement: Proactively identify opportunities to enhance data quality processes and contribute to the evolution of our data governance framework Requirements Experience: Minimum 3 years of hands-on experience in data testing, data quality assurance, or related analytical roles Azure Databricks Expertise: Strong proficiency in Azure Databricks including notebooks, job scheduling, Spark cluster management, and distributed data processing Azure Data Factory Knowledge: Comprehensive understanding of Azure Data Factory components including pipeline development, dataset configuration, linked services setup, and monitoring capabilities Azure Synapse Proficiency: Working knowledge of Azure Synapse Analytics, particularly Dedicated SQL pools and their optimization Business Intelligence Tools: Experience with tabular models in Analysis Services and Power BI, including data lineage analysis, semantic model development, and connectivity troubleshooting SQL Mastery: Advanced SQL skills for complex data quality verification, test query preparation, and performance optimization ETL Understanding: Solid grasp of Extract, Transform, Load processes, data warehousing concepts, and modern data integration patterns Automation and CI/CD: Hands-on experience with test automation frameworks and CI/CD practices, specifically using Azure DevOps and TestPlans for deployment and testing workflows Communication Skills: English proficiency at minimum B2 level for effective collaboration with international teams and stakeholders Analytical Mindset: Strong problem-solving abilities with attention to detail and capacity to work with large, complex datasets What We Offer Contract Flexibility: B2B contract employment structure providing professional autonomy Exceptional Culture: Join a workplace built on friendship and trust, with over 92% employee satisfaction and 100% team support ratings Technology Access: Work with the latest IT technologies and cutting-edge data platforms in a rapidly evolving field Growth Opportunities: Career advancement within an established international company with diverse project exposure Comprehensive Training: Regular skill development through "Secure Thursdays," "Science Fridays," and external conference participation Vibrant Community: Engaging company events including seasonal parties, AllHands meetings, "Talk to Your Boss" sessions, Local Wednesdays, and team breakfasts Recognition Programs: "summ-it heroes" recognition system and Kudos rewards celebrating outstanding contributions Referral Benefits: Employee referral program encouraging team growth Health and Wellness: Comprehensive benefits package including medical care, MultiSport card access, and group insurance coverage Join our innovative team where your expertise

$45k - $70k
Poznań, wielkopolskie, Poland
Full-time

Bechtel

About the Role Join Bechtel's extraordinary team as a Power BI Specialist for the groundbreaking Expo 2030 Riyadh project. This critical role supports one of the world's most ambitious infrastructure initiatives, transforming a 6 km² site into a global showcase for innovation and sustainable development. Under the theme "Foresight for Tomorrow," this project will welcome over 40 million visits and create a lasting legacy for the community. As our Power BI Specialist, you'll be at the forefront of data-driven decision making, designing and developing sophisticated analytics solutions that support project success across Master Planning, Engineering, and Construction phases. Working collaboratively with Expo 2030 Riyadh Company (ERC), you'll help manage the infrastructure program comprising early works, utilities, and publicly accessible spaces that will later transition into a mixed-use legacy development. Key Responsibilities Dashboard Development & Analytics Design, develop, and maintain interactive Power BI dashboards and reports supporting project performance monitoring across all project phases Transform complex cost, schedule, and performance data into clear, accurate, and insightful visual analytics Translate business and project controls requirements into effective data models and compelling visualizations Create standardized reporting templates and visual standards aligned with project, client, and corporate requirements Data Integration & Management Integrate data from multiple project management information systems including EcoSys, Unifier, Primavera P6, ACC Build, Morta, Power Apps, and ACONEX Define and maintain comprehensive metadata standards including WBS/CBS/OBS mappings, coding structures, status definitions, and reporting hierarchies Support data synchronization across various PMIS platforms through sophisticated mapping and interface specifications Manage automated refresh, reconciliation, and validation routines to ensure data consistency and reliability Quality Assurance & Validation Perform rigorous data validation, quality checks, and reconciliation to ensure integrity of Power BI outputs Develop and implement data governance protocols and security requirements Support variance analysis and trend identification to highlight key risks, constraints, and opportunities Ensure accurate visualization and interpretation of project KPIs and performance metrics Stakeholder Collaboration Work closely with Project Controls, Cost Engineering, Planning & Scheduling, Engineering, Procurement, Construction, and Commissioning teams Interface regularly with client counterparts and central reporting teams to align dashboard content and requirements Provide technical guidance and mentoring to team members on Power BI standards and data interpretation Prepare supporting narratives and explanatory materials for management and client reporting Process Optimization Automate reporting processes to improve efficiency and reduce manual data handling Support ad hoc analysis and respond to management and client requests Continuously enhance reporting capabilities and identify opportunities for process improvements Requirements Education & Experience Bachelor's degree in Engineering, Information Systems, Data Analytics, Computer Science, Business, or related discipline 7-12 years of relevant experience in reporting, analytics, or project controls environments Demonstrated hands-on Power BI development experience in complex project environments Experience supporting large infrastructure or construction projects preferred Experience working in Kingdom of Saudi Arabia or wider Middle East region highly desirable Technical Skills Advanced proficiency in Power BI including data modeling, DAX, Power Query, and dashboard design best practices Strong experience with project controls data including cost, schedule, progress measurement, and performance reporting Solid understanding of Earned Value Management (EVM) principles and their dashboard visualization Proficiency with Microsoft Excel and seamless integration with Power BI platforms Experience with project management systems such as EcoSys, Primavera P6, ACC Build, Morta, and Power Platform solutions Data Management Expertise Demonstrated knowledge of metadata management including definition of coding structures and master data alignment Familiarity with integration approaches including API-based integrations, ETL/ELT pipelines, and automated refresh systems Experience with Power Platform connectors and integration patterns Strong understanding of data validation, governance, and reporting controls Professional Skills Exceptional analytical skills with ability to interpret complex datasets and present actionable insights Outstanding written and verbal communication skills, capable of explaining technical concepts to non-technical stakeholders Strong collaborative approach with ability to work effectively across multidisciplinary teams Cultural awareness and sensitivity to operate successfully within the KSA project environment High degree of autonomy while maintaining alignment with organizational standards **

$80k - $120k
الرياض, Saudi Arabia
Full-time