Position: Data Engineer Location: Remote (USA) Duration: 7 Months Job ID: 168551 Job Overview: We are seeking a skilled and driven Data Engineer to join our dynamic team. In this role, you will play a pivotal part in acquiring, cleaning, and structuring data from diverse sources, enabling the organization to derive actionable insights and make informed decisions. You will collaborate closely with analysts, engineering teams, and stakeholders to design and deliver BI solutions, reports, dashboards, KPIs, and alerts. Your expertise in data visualization, analysis, and integration will be critical in uncovering trends, patterns, and opportunities for product enhancements. Additionally, you will lead data discovery efforts, assess data samples, and prepare data for hypothesis testing and statistical analysis. This role will also involve championing and establishing BI and data visualization services to empower analysts and data scientists. Responsibilities: • Build and maintain complex data pipelines that integrate data from various sources, including APIs, Salesforce, AWS, Data Cloud, and databases. • Design and develop optimized data models and scalable data structures in Salesforce Data Cloud and Snowflake to support reliable analytics and reporting. • Perform comprehensive data profiling to identify data gaps and improve data quality across ingestion and transformation layers. • Implement robust data transformation logic to convert raw data into golden records and trustworthy analytical datasets. • Build automated data quality checks and validation rules within pipelines to ensure accuracy, completeness, and consistency of critical datasets. • Partner with product analysts, product engineering, and other stakeholders to understand instrumentation needs for insights and analytics. • Collaborate with data architects to define and maintain data governance, naming standards, and data lineage documentation. Qualifications: • BS/MS degree in Computer Science, Engineering, or a related field. • 4+ years of experience in data engineering or ELT/ETL development using SQL, Shell Scripting, Python, and Java. • Strong proficiency in Apache Spark, Python, and advanced SQL for large-scale data transformation and analytics. • Hands-on experience with Apache Airflow or equivalent orchestration tools for managing data workflows. • Experience with dbt for building and managing modular, version-controlled, and tested data transformations. • Proven ability to build, deploy, and optimize data pipelines on AWS infrastructure. • Experience with data lakehouse architectures and familiarity with modern data mesh principles. • Strong analytical skills with the ability to work with complex data models, derive insights, and recommend actionable strategies. • Familiarity with Salesforce data models and processes is a plus. • Proficient in Tableau for developing interactive dashboards and visual storytelling. • Exposure to data governance, metadata management, and data cataloging tools. • Ability to work effectively in an agile, distributed, and fast-paced environment with a high degree of self-management and clear communication. About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to: • Pay any fee to be considered for, submitted to, or selected for any opportunity. • Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process. • Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup. Pay Range: $70- $74/hr W2 The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work. If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 214-740-2424. To report any concerns, please email us at legal@pinnacle1.com \`\`\`