Pinnacle Technical Resources, doing business as Pinnacle Group, provides workforce solutions and strategic services to companies in the staffing, project management, and IT consult
Senior Data Engineer
Location
Alabama + 26 moreAll locations: Alabama | Arizona | Florida | Georgia | Idaho | Illinois | Iowa | Indiana | Kansas | Kentucky | Louisiana | Maryland | Michigan | Missouri | Nevada | New Mexico | North Carolina | Ohio | Oklahoma | Pennsylvania | South Carolina | Tennessee | Texas | Utah | Virginia | West Virginia | Wisconsin
Posted
1 day ago
Salary
$60 - $65 / hour
Seniority
Senior
Job Description
Senior Data Engineer
Pinnacle Group
Title:Senior Data Engineer - ETL/SQL/Matillion Location: St. Louis, Missouri Job Description:: Duration: Contract Job ID: 177007 Job Overview: As a Senior Data Engineer, you will play a critical role in designing, building, and maintaining robust data pipelines and integration solutions to ensure seamless data flow across systems. You will work with a modern suite of cloud-based technologies, including Looker, Snowflake, Atlan, and Matillion, hosted in AWS. This position offers the opportunity to work fully remote from your home residence in one of the approved states. Join a team that fosters innovation, collaboration, and growth while driving smarter decision-making and scalable growth across the organization. Responsibilities: - Design, build, and maintain robust data pipelines and integration solutions. - Develop and optimize scalable ETL/ELT processes to drive innovation and business growth. - Create and maintain source-to-target mapping and detailed ELT documentation. - Analyze, map, and troubleshoot data across all stages of the ELT process. - Provide accurate estimates for ELT tasks and recommend process improvements. - Participate in production on-call support rotation for ETL processing. - Collaborate in a team-oriented environment and work independently as needed. - Incorporate security into all decisions and daily job responsibilities. Qualifications: - Must be authorized to work in the U.S. without sponsorship now or in the future. - Must reside in one of the approved states: AL, AZ, FL, GA, ID, IL (excludes Cook County), IA, IN, KS, KY, LA, MD, MI, MO, NV, NM, NC, OH, OK, PA, SC, TN, TX, UT, VA, WV, WI. - Ability to work within U.S. Central Standard Time core business hours. - 3+ years of hands-on experience with ETL for data integration and transformation. - 3+ years of experience writing and tuning complex SQLs, stored procedures, triggers, and functions. - 3+ years of experience in full lifecycle development, end-to-end testing, and data validation. - Experience with the Matillion platform. - Strong experience with AWS services, including Lambda functions and data pipeline orchestration. - Proven experience implementing Change Data Capture (CDC) strategies. Preferred: - Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, Engineering, or a related field. - Experience with unit testing for ETL/ELT pipelines and data quality frameworks. - Strong ability to write complex queries and optimize for large-scale datasets. - Experience with job optimization and integration with CI/CD pipelines. - Ability to mentor junior engineers and lead small projects. - Experience in Agile/Scrum environments and familiarity with DevOps principles. 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: $60-65/Hr 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 #LI-SA4
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Senior Data Analytics Engineer - Data Insights
AppfireAppfire is a computer software company that has been recognized as a “global authority” on Atlassian products and software. As an employer, the company aims to cultivate a cult
Title: Senior Data Analytics Engineer - Data Insights Location: Poland United States Job Description: At Appfire, we believe that great work happens when people get to choose how they work. After 20 years of creating software that empowers teams to break silos and collaborate seamlessly, we've learned that one size does not fit all. That's why at Appfire, you choose. Choose to work where you thrive: Whether from home, in one of our offices, or while exploring the world, you decide where you're most productive. From hardware and software to access to two decades of collective wisdom on working effectively in a remote-first company, we've got you covered. Choose to balance your life without compromise: Plan your workday around your needs and what matters most to you. Enjoy flexible time off without the hassle of complicated approvals. From day one, we trust you to deliver quality work without sacrificing your personal life, hobbies, loved ones, and well-being. Choose to grow on your terms: Take charge of your professional growth with access to online learning platforms, facilitated training, leadership programs, and internal hackathons. Collaborate with a global team to gain fresh perspectives. When you're ready for a new challenge, our internal mobility program is here to support your journey. No one knows you better than you do. So join us and customize your experience. Choose how you want to work. Choose Appfire. Position Overview: Appfire is seeking an experienced full-time Senior Analytics Engineer! In this role you will help build and define our new company-wide data asset (Snowflake) from the ground up. You will work with stakeholders across Appfire to align, test, build and activate brand new data and metrics within our Snowflake metrics layers, achieving a trusted, accessible and well-defined view of information for all at Appfire. Our Analytics Engineers build metric foundations for reporting, analysis and experimentation, pushing the boundaries of decisions across the company under an aligned view of the world. They leverage their expertise in metric development, DBT, data modeling, SQL and Python. Using these skills you will transform data from raw data warehouse into data artifacts powering impactful analytic use cases (e.g. metrics, dashboards, adhoc analysis and self-service solutions) hat enable downstream data consumers across the company. As an Analytics Engineer you will sit at the intersection of data stakeholders and data engineering, working collaboratively to enable and achieve highly impactful outcomes by evolving our ecosystems for scaling impact. We're growing quickly and have a lot to accomplish. What You Will Do: - Understand data needs by interfacing with fellow Analytics Engineers, Data Engineers, Data Analysts and Business Partners - Architect, build, and launch efficient & reliable data models and pipelines in partnership with Data Engineering, leveraging DBT and Snowflake - Design and implement metrics and dimensions enabling self-service analysis and structured views of Appfire's KPI's that scale trust, accountability and decision impact - Define and share best practices on metric, dimension, and data model development and definitions for analytics use cases What We Would Like To See: - 5+ years of relevant industry experience - Passion for high data quality and impactful analytics engineering work - Strong skills in SQL - Expert in schema design and dimensional data modeling semantic and metrics layers - Experience with Python and DBT - Efficient problem-solving and analytical skills - Proven ability to succeed in both collaborative and independent work environments at a remote-work company - Detail-oriented and excited to learn new skills and tools Preferred Qualifications: - Experience informing and influencing early DBT deployments - Proven experience with data wrangling and designing/developing - Experience owning end to end SDLC and implementation, with full ownership of stakeholder management and expectation setting, prioritization, development and delivery. - Experience with source code management tools such as GIT, BitBucket, etc. - Experience working with Cloud Technologies (AWS/GCP/Azure) - Experience working with various semi structured data formats (ex. JSON) - Experience building data solutions for future scale and analytics use-cases - 2+ years of development experience on industry standard BI tools - Knowledge graph/ontology familiarity/experience building/deploying is a plus - ML analytics engineering experience a plus Benefits & Perks Equity Every Appfire team member is eligible for company equity, fostering a true sense of ownership and connection to our growth. Time Off & Wellbeing - 26 paid vacation days annually, regardless of tenure - 12 Wellness Days - one fully paid day off each month to recharge, available on an ad-hoc basis and not carried over month to month - 24 hours of paid volunteer time to support meaningful causes outside of work - 3 fully paid volunteering days each year through Appfire Town, our Corporate Social Responsibility (CSR) program supporting local communities Learning & Development Grow with Appfire University - our custom, on-demand learning platform designed to support continuous learning and professional development. Health & Insurance - Fully covered Luxmed private healthcare plan - Option to extend coverage to your partner or add personalized upgrades - UNUM life insurance, fully paid by Appfire Lifestyle & Benefits - MyBenefit Platform with 150 PLN per month to spend on: - a Multisport card - shopping - restaurants - entertainment experiences - Lunch Card with 300 PLN monthly for groceries or dining out via a virtual prepaid Pluxee card (Google Pay or Apple Wallet supported) Remote Work Support Receive 200 PLN net per month as a home office allowance to help cover electricity and internet costs while working remotely. About Appfire A people-first approach to business Since its inception, Appfire has been a remote-first company. With 850+ employees (who we call fireflies) across 28 countries, we foster an environment where everyone is respected. We invest in team members by ensuring they grow professionally and personally. Making an impact At Appfire, CSR means embedding purpose, responsibility, and impact into everything we do. We use our people, products, and partnerships to make a meaningful difference in the world, we act responsibly as a business, and we empower communities while strengthening our skills and culture and fostering belonging across Appfire. In 2015, Appfire joined the Pledge 1% network of organizations committed to philanthropy. Appfire has since grown our Pledge 1% program to include all four pledge types - product, profit, equity, and employee time. We were among the first to do this, and we're proud that Pledge 1% is part of our evolution. Our business Appfire mission to equip and connect every team so they can plan and deliver their best work. We are committed to building a durable, multi-generational business, and to evolving, innovating, and scaling in a way that ensures stability and opportunity for years to come What's our secret sauce? - We follow teams. We do our research and build software that solves real-life collaboration challenges while being easy to implement and a joy to use. We're proud to support over 20,000 customers and growing, including 55% of the Fortune 500. From the entertainment delivered by Netflix to the devices crafted by Samsung, and Dell Technologies and the financial transactions handled by Visa, Edward Jones, and US Bank, Appfire's technology is indispensable. Our products also play a pivotal role in streamlining operations and fostering innovation at companies like Tesla and significant institutions such as NASA, Boeing, and many more. - We enhance. Our software is designed to give developers, knowledge workers, and teams the ability to extend and get greater value from the platforms they've invested in and enjoy. So far, our solutions extend and enhance the capabilities offered by Atlassian, Microsoft, monday.com, and Salesforce. - We build bridges and invest in our partners. Appfire's success is underscored by its channel program as its primary path to market. Today, Appfire has a dedicated Channel team supporting 800+ channel partners. - We make security and privacy a priority, but we also keep it simple for our customers. We've achieved International Organization for Standardization (ISO) 27001 and ISO 27017 and System and Organization Controls (SOC) SOC 2, Type I and SOC 2, Type II certifications. Our award-winning Appfire Trust Center, offers our customers, partners, and prospects the latest security, privacy, and compliance information, including pre-completed questionnaires (CAIQ, SIG, and VSA) with an accelerated NDA process and just one EULA to cover it all. Market recognition Appfire has been consistently recognized for company growth, culture, corporate social responsibility, and product excellence and has been included among the Deloitte Technology Fast 500, Inc. Best Workplaces, BuiltIn Best Places to Work, and Inc. 5000. Learn more about our accomplishments, which would not be possible without our team members, partners, and customers: https://appfire.com/awards. Equal Employer Opportunity (EEO) Appfire is an equal opportunity employer and does not discriminate based on race, color, religion, sex (including pregnancy), sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, veteran status, or any other protected characteristic as defined by applicable law. Our commitment extends to all employment practices, including recruitment, hiring, training, promotion, compensation, benefits, and termination.
• Translate business requirements into data requests, reports and dashboards. • Strong Database & modeling concepts with exposure to SQL & NoSQL Databases • Strong data architecture patterns & principles, ability to design secure & scalable data lakes, data warehouse, data hubs, and other event-driven architectures • Expertise in designing and writing ETL processes in Python / Java / Scala • Understanding of Hadoop framework - Exposure to PySpark, Spark, Storm, HDFS, Hive • Strong hands-on experience with either Databricks or Snowflake; experience with both is desirable. • Knowledge of Master Data management and related tools • Strong exposure to data security and privacy regulations (GDPR, HIPAA) and best practices • Skilled in ensuring data accuracy, consistency, and quality • Experience with the AWS/Azure/GCP data engineering services • Knowledge of AWS services viz., AWS S3, Redshift, Lambda, DynamoDB, EMR, Glue, Lakeformation, Athena, Quicksight, RDS, Kinesis, Managed Kafka, API Gateway, CloudWatch • And / OR • Knowledge of Azure services viz., ADF, Data Catalog, Databricks, Azure Synapse Analytics, ADLS Gen2, Azure Devops • Ability to implement data validation processes and establish data quality standards. • Experience in Linux • Proficiency in data visualization tools like Tableau, Power BI or similar to create meaningful insights
• Translate business requirements into data requests, reports and dashboards. • Strong Database & modeling concepts with exposure to SQL & NoSQL Databases • Strong data architecture patterns & principles, ability to design secure & scalable data lakes, data warehouse, data hubs, and other event-driven architectures • Expertise in designing and writing ETL processes in Python / Java / Scala • Understanding of Hadoop framework - Exposure to PySpark, Spark, Storm, HDFS, Hive • Strong hands-on experience with either Databricks or Snowflake; experience with both is desirable. • Knowledge of Master Data management and related tools • Strong exposure to data security and privacy regulations (GDPR, HIPAA) and best practices • Skilled in ensuring data accuracy, consistency, and quality • Experience with the AWS/Azure/GCP data engineering services • Knowledge of AWS services viz., AWS S3, Redshift, Lambda, DynamoDB, EMR, Glue, Lakeformation, Athena, Quicksight, RDS, Kinesis, Managed Kafka, API Gateway, CloudWatch • And / OR • Knowledge of Azure services viz., ADF, Data Catalog, Databricks, Azure Synapse Analytics, ADLS Gen2, Azure Devops • Ability to implement data validation processes and establish data quality standards. • Experience in Linux • Proficiency in data visualization tools like Tableau, Power BI or similar to create meaningful insights
Senior Data Engineer
CAMP Systems International, Inc.The world's leading Aircraft Maintenance Tracking Solutions provider.
• Design, develop, and maintain high-performance, scalable, high-volume, and efficient ETL/ELT pipelines to extract, transform, and load data from various sources such as Oracle. • Create and optimize data models and schemas to support various use cases (such as AI/ML solutions, benchmarking, customer data delivery) in Snowflake and Redshift. • Ensure data quality, integrity/completeness, and governance by implementing best practices for monitoring and validation. • Build automated monitoring and alerting mechanisms. • Collaborate with cross-functional teams to understand data requirements to support business objectives. • Stay up to date with emerging trends and technologies in data engineering.


