Job Closed
This listing is no longer active.
Founded in 2006, 3Pillar Global is a modern application strategy, design, and engineering firm that builds breakthrough software products that power digital bus
Senior Data Engineer
Location
Worldwide
Posted
115 days ago
Salary
0
Seniority
Senior
Job Description
Senior Data Engineer
3Pillar
Role Description Accomplished Tech Visionary: Elevate your expertise to new heights at 3Pillar, the premier destination for trailblazing senior software engineers like yourself. Your role extends beyond the realm of code composition; you will architect transformative solutions that reshape entire industries. - Analyze data integrity challenges including investigating, correcting, and monitoring data to help identify and address key data issues. - Facilitate effective communication with client project stakeholders regarding project status and recommendations. - Craft client code that is efficient, performant, testable, scalable, secure, and of the highest quality. - Participate in accurate planning and estimation efforts, utilizing project methods and tools. - Gather requirements and organize/present developed features for clients. - Execute complex activities within the current methodology and quality standards, showcasing success across diverse engagements. - Promote client success by collaborating with engineers, designers, and managers to understand user pain points and iterate on solutions. - Engage in agile software development, including daily stand-ups, sprint planning, and team retrospectives. - Participate in the Engineering Practice community, mentoring others and supporting the growth of technical capabilities. - Independently drive project delivery within defined architecture, demonstrating autonomy and accountability in all stages from conceptualization to deployment. Qualifications - Experience in designing and implementing scalable backend services and APIs using Python. - Collaboration with cross-functional teams to define and execute on technical requirements. - Optimization of system performance and troubleshooting issues. - Staying updated with the latest Python and SQL for continuous improvement. Requirements - Must-Have Skills & Tools: - Languages: SQL, Python - Skills/Responsibilities: MS SQL Server, Snowflake (data warehouse), Hevo / dbt - Tools: Jira, Bitbucket, Slack/Teams - Good to Have Skills: - Languages: Javascript - Skills/Responsibilities: Dynamo DB, AWS Services, Rockset (analytical engine) - Experience in Agile software development methodologies. - Expertise in working with SQL and SQL MS Server. - Experience in creating and implementing well-tested, scalable, and performant enterprise-level systems. - Practice and initiative mentoring other engineers and decision-makers throughout the organization. - Proficiency in the English language. - Additional Experience Desired: - Ability to optimize backend performance and troubleshoot issues. - Familiarity with modern frontend build tools and CI/CD pipelines. - Excellent problem-solving skills and a proactive attitude towards challenges. - Strong verbal and written communication skills. - Professional software engineering experience, working on multi-discipline teams. - Experience in backend development with expertise in node.js. - Proficiency in designing and implementing RESTful APIs and microservices architecture. - Good knowledge of AWS services like Lambda, API Gateway, DynamoDB/RDS, and S3. - Experience with containerization using Docker and orchestration with Kubernetes (optional). - Object-Relational Mappers (ORMs). - Architectural (Microservices, Serverless etc) and Design (Factory, Singleton, Observer etc) Patterns. - Unit Testing. Benefits - Flexible work environment – whether it's the office, your home, or a blend of both. - Be part of a global team, learning from top talent around the world. - Focus on well-being with fitness offerings, mental health plans, and generous time off. - Accelerated career growth and development opportunities across projects, offerings, and industries. - Equal opportunity employer committed to diversity and inclusion.
Related Guides
Related Categories
Related Job Pages
More Analytics Engineer Jobs
Vālenz® Health is the platform to simplify healthcare – the destination for employers, payers, providers and members to reduce costs, improve quality, and elevate the healthcare experience. The Valenz mindset and culture of innovation combine to create a distinctly different approach to an inefficient, uninspired health system. With fully integrated solutions, Valenz engages early and often to execute across the entire patient journey – from care navigation and management to payment integrity, plan performance and provider verification. With a 99% client retention rate, we elevate expectations to a new level of efficiency, effectiveness and transparency where smarter, better, faster healthcare is possible. About This Opportunity: As a Manager, Provider Analytics, you will lead a team responsible for the accuracy, structure, and usability of enterprise provider data. You’ll partner closely with Product, Data Engineering, and Application Development to deliver high-quality analytics that power critical business decisions. This role blends people leadership, hands-on technical expertise, and strategic thinking that drives data integrity, improves processes, and shapes how provider data is leveraged across the organization. Things You’ll Do Here: - Lead, coach, and develop a team of Analysts by providing technical direction, reviewing deliverables, and guiding problem-solving approaches. - Define and execute the provider analytics roadmap in alignment with product and enterprise data strategy. - Set clear performance expectations, support professional development, and manage ongoing performance. - Serve as a subject matter expert in provider data, leading complex analyses to establish accurate provider identity, network status, affiliations, and hierarchy across multiple data sources. - Design and support scalable, production-grade analytics workflows using SQL, Python, and Databricks. - Ensure the accuracy, quality, and integrity of analytical outputs through strong validation and review practices. - Partner cross-functionally with Data Engineering, Product, Application Development, and Client Success to deliver solutions, resolve complex issues, and support strategic initiatives. - Translate complex analytical findings into clear, actionable insights for both technical and non-technical audiences. - Identify and implement process improvements to enhance efficiency, scalability, and data reliability. - Evaluate and introduce emerging technologies and best practices to strengthen provider data capabilities. - Manage and track work through project management tools such as Azure DevOps and Salesforce. Reasonable accommodation may be made to enable individuals with disabilities to perform essential duties. What You’ll Bring to the Team: - 5+ years of analytics experience, including at least 2 years in a leadership or mentorship capacity. - Bachelor’s degree in a quantitative field (Statistics, Mathematics, Computer Science, Finance, or Economics) or equivalent experience. - Strong experience working with provider and medical claims data. - Advanced SQL skills and working knowledge of Python, with experience supporting or reviewing production-level code. - Proven ability to translate complex, ambiguous data into clear, actionable insights. - Strong attention to detail with a focus on data accuracy, validation, and quality. - Experience identifying root causes and driving durable solutions. - Excellent communication skills, with the ability to work across technical and non-technical teams. - Highly organized, with the ability to manage multiple priorities in a fast-paced environment. A plus if you have… - Master’s degree. - Experience with Spark or other distributed processing frameworks. - Familiarity with cloud platforms (AWS, Azure, GCP). - Working knowledge of version control (Git) and CI/CD practices. Where You’ll Work: This is a fully remote position, and we’ll provide all the necessary equipment! - Work Environment: You’ll need a quiet workspace that is free from distractions. - Technology: Reliable internet connection—if you can use streaming services, you’re good to go! - Security: Adherence to company security protocols, including the use of VPNs, secure passwords, and company-approved devices/software. - Location: You must be US based, in a location where you can work effectively and comply with company policies such as HIPAA. Why You'll Love Working Here Valenz is proud to be recognized by Inc. 5000 as one of America’s fastest-growing private companies. Our team is committed to delivering on our promise to engage early and often for smarter, better, faster healthcare. With this commitment, you’ll find an engaged culture – one that stands strong, vigorous, and healthy in all we do. Benefits - Generously subsidized company-sponsored Medical, Dental, and Vision insurance, with access to services through our own products, Healthcare Blue Book and KISx Card. - Spending account options: HSA, FSA, and DCFSA - 401K with company match and immediate vesting - Flexible working environment - Generous Paid Time Off to include vacation, sick leave, and paid holidays - Employee Assistance Program that includes professional counseling, referrals, and additional services - Paid maternity and paternity leave - Pet insurance - Employee discounts on phone plans, car rentals and computers - Community giveback opportunities, including paid time off for philanthropic endeavors At Valenz, we celebrate, support, and thrive on inclusion, for the benefit of our associates, our partners, and our products. Valenz is committed to the principle of equal employment opportunity for all associates and to providing associates with a work environment free of discrimination and harassment. All employment decisions at Valenz are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, national, social, or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. We will not tolerate discrimination or harassment based on any of these characteristics.
Marketing Data Engineer
LHH (Global)LHH empowers professionals and organizations to achieve bold ambitions and secure lasting impact through unique advisory services and talent sources. Our full suite of offerings connects solutions that are traditionally siloed, making LHH your single talent partner. In a rapidly evolving landscape with complex challenges, we create value across the entire professional talent journey. From hiring great people, developing skills, and nurturing leaders, to advancing individuals to the next stage of their careers, LHH makes talent your competitive edge. We believe the future of work lies at the intersection of exceptional human care and innovation. Powered by science, technology, and proprietary data analytics, LHH’s approach is crafted to align with your business strategy and culture, delivering powerful, sustainable, and measurable impact. LHH has a team of over 12,000 professionals, across 60+ countries and more than 50 years of experience. As part of the Adecco Group, we bring together global excellence, local knowledge, and centralized coordination for thousands of companies and millions of people worldwide. LHH is an Equal Opportunity Employer / Veterans / Disabled.
Marketing Data Engineer This role builds the data foundation and reporting infrastructure for Marketing. By combining data engineering and visualization, this position ensures that Marketing leaders have scalable, automated, and real-time insights. You will build and maintain the data infrastructure that powers all marketing analytics, ingesting platform data and designing warehouse models to transform complex marketing performance data into clear, compelling dashboards and stories. This role ensures stakeholders across the Marketing and leadership teams have intuitive, self-serve access to the metrics that drive decision-making and growth. Reporting Relationships: - Reports to Director of Marketing Analytics Direct Reports: - No direct reports Location: - Remote: US or Europe Languages: - Must be proficient in English (speaking, writing, presentation) In this role you can expect to Data Engineering Infrastructure - Design, develop, and implement a robust, scalable data architecture that integrates data from ad platforms (Google Ads, LinkedIn, Meta), multiple CRM instances (Salesforce), marketing automation (Pardot/Marketing Cloud), Website (GA4), and finance systems into a central data warehouse (Fabric/Azure Synapse Workspace), enabling a single source of truth for marketing performance analytics. - Build and optimize data models that connect different data sources and show a more integrated view of the buying journey, supporting reliable channel / campaign multi-touch attribution, ROI analysis, and predictive analytics. - Implement data governance practices, ensuring accuracy, completeness, and compliance with company’s privacy rules. - Partner with Finance analyst to automate marketing spend categorization and revenue reconciliation to power ROI and CAC reporting. - Collaborate with analysts in Marketing and Sales Ops to provide clean, well-structured datasets for dashboards and advanced modeling (e.g. attribution models, churn prediction, funnel optimization). - Monitor data pipelines for performance and proactively address quality issues before they impact stakeholders, interacting with IT partners when necessary. Data Visualization & Analysis - Leverage the built data models to design, develop, and maintain marketing dashboards in BI tools (Salesforce, Looker Studio, Power BI) to track pipeline health, channel performance, and ROI. - Collaborate with CRM, Finance, Web Analytics, and Sales Ops teams to combine data from Salesforce, marketing automation, Finance, and digital platforms into unified dashboards. - Support the creation of standardized visual templates for executive reporting and board presentations. - Apply UX principles to ensure dashboards are intuitive, interactive, and actionable for stakeholders across Marketing, countries, and the Leadership team. - Build documentation that helps to train business users on self-serve dashboard access and interpretation of key B2B metrics (pipeline, funnel conversion, campaign ROI and more). - Continuously improve visualizations by gathering stakeholder feedback and implementing enhancements. All About You - Bachelor’s degree in Business, Information Technology, Data Science, Computer Science, or related field. - 4+ years in data engineering with a focus on marketing or revenue operations and dashboard development for B2B organizations. - Proficiency in SQL and at least one ETL/ELT framework (Azure, dbt, Airflow, Fivetran, Stitch, etc.). - Strong understanding of B2B marketing data structures—CRM objects, campaign hierarchies, opportunity stages, GA4, and ad platform APIs. - Experience with cloud data warehouses and version control. - Collaborative mindset to work with marketers, analysts, and finance partners in a matrix environment. - Advanced skills in one or more BI tools (PowerBI required) - Eye for design and storytelling to help communicate complex funnel metrics clearly. - Passion for enabling teams to make data-driven decisions quickly and confidently. - Excellent analytical skills with the ability to interpret complex data sets. - Strong problem-solving skills and attention to detail. - Effective communication skills with the ability to present technical information to non-technical stakeholders. - Ability to work independently and collaboratively in a fast-paced environment. What we offer - Growth opportunities within a human resources global leader - We prioritize learning to stay agile in an increasingly competitive business environment. - We foster an open-minded environment where people spark new ideas and explore alternatives. - Compensation: $60,000 - $70,000 per year plus bonus opportunity Placement within this range is determined based on geographic location, experience, and other compensatory factors. - Benefits: Employees who opt into benefits as part of full-time employment include medical, dental, vision, term life and AD&D insurance, short-term and long-term disability, additional voluntary benefits, commuter benefits, wellness plans, and a 401k plan or a non-qualified deferred compensation plan. Available paid leave includes Personal Time Off (PTO) on an accrual basis per year, Paid Holidays, and up to 6 weeks of Paid Parental Leave. PTO and holiday hours are prorated based on hire date within the calendar year. About LHH LHH empowers professionals and organizations to achieve bold ambitions and secure lasting impact through unique advisory services and talent sources. Our full suite of offerings connects solutions that are traditionally siloed, making LHH your single talent partner. In a rapidly evolving landscape with complex challenges, we create value across the entire professional talent journey. From hiring great people, developing skills, and nurturing leaders, to advancing individuals to the next stage of their careers, LHH make talent your competitive edge. We believe the future of work lies at the intersection of exceptional human care and innovation. Powered by science, technology, and proprietary data analytics, LHH’s approach is crafted to align with your business strategy and culture, delivering powerful, sustainable, and measurable impact. LHH has a team of over 12,000 professionals, across 60+ countries and more than 50 years of experience. As part of the Adecco Group, we bring together global excellence, local knowledge, and centralized coordination for thousands of companies and millions of people worldwide. Recruitment. Development. Career Transition. LHH. A beautiful working world. www.lhh.com LHH is an Equal Opportunity Employer/Veterans/Disabled.
• The Senior SQL ETL Developer is responsible for designing, developing, and maintaining SQL-based data integration and transformation processes that support reporting and analytics. • This role focuses on building and optimizing ETL pipelines, ensuring data accuracy and integrity, and supporting data models used across the organization. • Essential Job Duties include design, develop, and optimize T-SQL stored procedures, functions, and views for ETL and reporting use cases. • Build and maintain scalable ETL pipelines to ingest and transform data from multiple source systems. • Implement incremental loading strategies, change data capture, and historical tracking (Type 1 and Type 2). • Develop reusable SQL frameworks for data ingestion, transformation, and reconciliation. • Implement and maintain data quality checks including row counts, schema validation, null checks, and duplicate detection. • Perform source-to-target reconciliation and investigate discrepancies in data. • Ensure auditability and compliance through well-documented, traceable SQL logic. • Tune SQL queries and stored procedures for performance, efficiency, and scalability. • Support and enhance dimensional and relational data models used for reporting and analytics. • Collaborate with reporting and analytics teams to ensure data accuracy, consistency, and usability. • Analyze execution plans, indexing strategies, and query patterns to resolve performance bottlenecks. • Ensure ETL processes meet defined SLAs and execution windows. • Troubleshoot ETL failures, production issues, and data inconsistencies. • Implement and maintain logging, error handling, and restart/recovery mechanisms. • Participate in code reviews, release planning, and production deployments.
Overview Job Summary The Senior Data Engineer at Air Methods is responsible for leading and growing our data-driven decision culture by designing, developing, and delivering data engineering and analytical solutions that are customer focused, easy to consume and create business impact. To be successful, this teammate must have a passion for mentoring other data engineers and working with stakeholders to understand their needs and deliver value through the entire data pipeline. You will design and implement complex data models, model metadata, build data pipelines, reports and dashboards, and own data presentation and dashboarding tools for the end users of our data products and systems. You will write scalable, highly tuned SQL queries and will develop learning and training programs to drive adoption of data driven decision making across the organization. Essential Functions and Responsibilities include the following: - Develop and improve the current data architecture, emphasizing data security, data quality and timeliness, scalability, and extensibility - Develop and implement complex and efficient data pipelines/solutions to transform raw data sources into powerful, reliable components of our data platform and business insights - Deploy and use various data and big data technologies and run pilots to design low latency data architectures at scale - Implement and simplify self-service data query and analysis capabilities of the data platform - Establish and maintain standards and guidelines for design and development, tuning, deployment, and maintenance of information and advanced data analytics - Meet with subject matter experts in different areas of the business, be able to quickly learn the concepts and business language relevant to their line of business and develop an understanding of how their data supports their business processes - Actively mentor and lead knowledge sharing sessions, code, and design reviews - Build conceptual and logical data models for stakeholders and management - Actively lead knowledge sharing sessions, code, and design reviews - Support the data platform infrastructure and implement solutions to ensure continuous improvement in platform stability - Collaborate with business analysts, data scientists, product owners, software development engineers, and other teams to develop, implement, and validate KPIs, statistical analyses, data profiling, prediction, forecasting, clustering, and machine learning algorithms - Other duties as assigned Additional Job Requirements - This position is not eligible for sponsorship. - Regular scheduled attendance - Indicate the percentage of time spent traveling - 0% Subject to applicable laws and Air Method’s policies, regular attendance is an essential function of the position. All employees must follow Air Methods’ employment practices and policies. Supervisory Responsibilities This position has no supervisory responsibilities. Qualifications To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. In accordance with applicable laws, Air Methods will provide reasonable accommodations that do not create an undue burden so disabled employees may perform the essential functions of the position. Education & Experience - Bachelor’s degree (BS/BA) from four-year college or university in Information Computer Science or related field, and eight+ years’ related experience and/or training; or equivalent combination of education and experience - 10+ years in Data Engineering or related field - 5+ years working in a cloud computing environment, Azure preferred - Extensive experience in building scalable data platforms in a cloud data platform, Snowflake preferred - Extensive experience gathering data from multiple heterogeneous data sources, including databases, various file formats, and REST and SOAP APIs - Hands-on experience with Azure technologies, such as SQL and NoSQL databases, Azure DevOps, Azure Data Factory, Databricks, and Azure Analytics Services desired - Strong experience with Data Visualization Tools (Power BI preferred) - Strong experience in an Agile Scrum environment, with work estimation and providing input to managers on resource and risk planning Skills - Ability to lead and mentor other data engineers - Authoritative in ELT optimization, designing, coding, and tuning data processes - Experience with building data pipelines and applications to stream and process datasets at low latencies - Experience in data mining, profiling, and analysis - Experience with complex data modelling, ELT design, and using large databases in a business environment - Demonstrates efficiency in handling data - tracking data lineage, ensuring data quality, and improving discoverability of data - Affinity for learning modern technologies, data analysis, and identifying data patterns and trends - Proven ability to develop unconventional solutions; Sees opportunities to innovate and leads the way - Demonstrates high critical thinking and reasoning skills and strong attention to detail while working in a fast-paced environment that requires ability to prioritize and multi-task - Excellent communication skills, both written and verbal Computer Skills - Advanced experience with Microsoft Suite, including Word, Excel, PowerPoint, and Outlook - Experience modeling data in cloud data platforms such as Snowflake, Redshift, and or BigQuery - Experience with Python, Spark and PySpark desired - Expert in data architecture, ELT, and data ingestion development skills - Advanced proficiency in writing complex SQL statements and manipulating large structured and semi-structured datasets. - Experience with scheduling tools or a DAG scheduler - Experience with cloud warehouse ELT tools (e.g., Matillion, dbt) Certificates, Licenses, Registrations - None Air Methods is an EEO/AA employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. Minimum pay USD $124,000.00/Yr. Maximum Pay USD $158,000.00/Yr. Benefits For more information on our industry-leading benefits, please visit our benefits page here. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)


