Data Engineer

Location

United States

Posted

37 days ago

Salary

$45 - $55 / hour

Seniority

Mid Level

Job Description

Data Engineer

FocusKPI Inc.

FocusKPI is looking for a Data Engineer to join our client's growing team and spearhead analyses, providing meaningful insights into their users and product. Work Location: 100% remote and ideally able to work New York EST hours Duration: 5 months/ 40 hrs per week Pay Range: $45 - $55/hr Responsibilities: - The initial project will be moving DBT models that currently run in Spark SQL to run in Redshift - Need to have the business intuition to roughly understand the business logic in the existing data model and make sure the new one meets their needs - Team would also like you to do some CI/CD work around their DBT job, where Python, GitHub Actions, and Airflow would be helpful - Support new product launches, A/B testing, ramp-up recommendations, and root cause investigation - Be constantly curious and continue to pursue in-depth explorations of the datasets - Leverage new techniques to investigate their data and incorporate external information to boost our knowledge of this market - Communicate complicated data findings in a clear and concise manner to our multi-disciplined teams - Collaborate with stakeholders, including product, marketing, finance, etc., on initiatives that improve our company-level KPIs and match our business priorities - Ad-hoc analysis to address urgent high-impact analysis for business stakeholders Qualifications: - Bachelor’s degree in the Computer field, which requires logical, creative thinking, STEM majors, MS degree preferred - 5+ years of industry experience is required - Expertise in SQL (Need to have strong skills) - Strong experience in Spark/PySpark, Python, Scala, Airflow, and AWS - Experience with DBT, Redshift - Experience with data models - Experience with CI/CD - Experience with Python, GitHub, and Airflow is a huge plus to have - Experience collaborating with and understanding the needs of stakeholders from a variety of business functions, including product, marketing, finance, and so on - Experience in handling large-scale data with efficiency - Strong analytical and problem-solving skills - Experience in Financial Services or FinTech preferred Thank you! FocusKPI Hiring Team Founded in 2010, FocusKPI, Inc. (FocusKPI) is a data science and technology firm specializing in predictive analytics practice and methodologies. FocusKPI is a US company headquartered in Silicon Valley, California, with an East Coast office in Boston, Massachusetts. NOTICE: Please be aware of fraudulent emails regarding job postings, job offers and fake checks. FocusKPI's recruiting team will strictly reach out via @focuskpi.com email domain. If you have received fraudulent emails now or in the past, please report it to https://reportfraud.ftc.gov/ . The domain @focuskpijobs.com is fraudulent and not related to FocusKPI. Please do not not reply or communicate to anyone with @focuskpijobs.com.

Related Categories

Related Job Pages

More Data Engineer Jobs

Tietoevry logo

Data Engineer – Tieto Tech Consulting

Tietoevry

We create purposeful technology that reinvents the world for good. #purposefultechnology #tietoevry

Data Engineer37 days ago
Full TimeRemoteTeam 10,001+H1B No Sponsor

• Developing and maintaining ETL/ELT pipelines using SQL, Spark/PySpark, and Microsoft Fabric and/or Databricks • Implementing data cleansing, validation, and transformation logic • Building and maintaining medallion/lakehouse architectures using Microsoft Fabric or Delta Lake • Integrating data from multiple enterprise systems • Preparing analytics-ready datasets for BI reporting and downstream use cases • Optimizing performance of pipelines, transformations, and data models • Supporting data platform modernization and migration from legacy ETL solutions • Working in Agile teams with architects, analysts, and customer stakeholders • Contributing to engineering best practices, reusable patterns, and knowledge sharing

Bulgaria

Staff Data Engineer, Data Platform

Turo

Turo is a car rental company based in San Francisco, California. The company was founded in 2009 and was designed to be a new and unique car company where trave

Data Engineer37 days ago

Collaborate with team members to execute data engineering initiatives, design a scalable data platform, define data models across business domains, and enhance team productivity through mentorship and infrastructure improvements.

California
Full TimeRemoteTeam 51-200

About Nerdery and Being a “Nerd.” Nerdery is a digital product consultancy. Much more than consultants, we’re allies and guides on our clients’ digital journey – helping them to grow their business and delight their customers through intuitive, thoughtfully designed technology. As true partners, we prepare our clients for the opportunities in front of them, help them achieve their goals, and quickly deliver value for their customers. We do this by solving problems in creative ways across strategy, design, and technology. At Nerdery, we’re not defined by our job titles but by the impact we make. You’ll work directly and closely with some of the world’s best brands to help create innovative digital products that serve everyone. As Nerds, our insight, innovation, and expertise are celebrated, and our growth is not only encouraged but expected. Being a Nerd means stepping up and pushing the boundaries of what’s possible. We are looking for a Senior Data Engineer to join our team! We invite you to check out the details below and consider whether becoming a Nerd is the next step in your career journey. The Senior Data Engineer role at Nerdery is responsible for designing and implementing the data architecture, storage solutions, and analytics platforms necessary to drive business insights. This role focuses on building scalable, well-governed data platforms on AWS and migrating legacy infrastructure to modern cloud environments. - Requirements: - Bachelor's degree in Computer Science, Data Engineering, or a related field (or equivalent practical experience). - 6+ years of professional experience in data engineering or a closely related discipline. - In-depth knowledge of Snowflake, including warehouse design, role-based access control, performance tuning, and cost optimization. - Experience migrating data pipelines and infrastructure to Snowflake from other platforms (legacy warehouses, on-premise systems, or hybrid environments). - Advanced proficiency with dbt for modular, tested, and version-controlled data transformations. - Hands-on experience with Dagster for pipeline orchestration, asset management, and data observability. - Proven experience designing and implementing data pipelines, data storage solutions, and analytics platforms on modern cloud data stacks. - Advanced proficiency in Python with hands-on experience in data-processing libraries such as Pandas, Polars, PySpark, or similar. - Strong SQL skills across both analytical and transactional workloads. - Experience with relational and/or columnar databases such as PostgreSQL, SQL Server, or Snowflake. - Deep understanding of data modeling, ETL/ELT processes, and data warehousing principles. - Experience implementing data architecture patterns (e.g., medallion/multi-hop, data mesh, lakehouse) to support scalable, well-governed data platforms. - Familiarity with Infrastructure-as-Code tools such as Pulumi or Terraform. - Familiarity with event-driven architectures and integrating orchestration platforms with cloud services. - Strong version-control practices (Git) with experience building CI/CD workflows for data workloads (e.g., GitHub Actions). - Proven ability to translate business and technical requirements into production-grade, maintainable data pipelines. - Excellent problem-solving and analytical skills. - Ability to communicate clearly with both technical and non-technical stakeholders. - Proactive collaborator who mentors colleagues and raises the technical bar across the team. - Experience building and consuming RESTful APIs. Exposure to containerisation (Docker) is a plus. - Familiarity with data quality and observability tooling (e.g., dbt tests, Great Expectations, Monte Carlo) is desirable. What You'll Do: - Design and implement end-to-end data pipelines and ETL/ELT processes - Architect scalable data platforms using patterns such as medallion/multi-hop, data mesh, or lakehouse - Develop data-processing logic using Python (Pandas, PySpark, Polars) and advanced SQL - Automate data workflows using orchestration tools like Airflow/MWAA and Step Functions - Implement Infrastructure-as-Code (Terraform/CloudFormation) and CI/CD for data workloads Pay Range: - 130,000-170,000 per year The pay range provided reflects the target compensation for this position, and individual pay within this range is determined by a variety of factors including, but not limited to, the candidate's relevant experience, specific skills, education, certifications, internal equity with comparable roles at our company, market conditions, and the geographic location of the role. We are committed to fair and equitable compensation practices, and we regularly review our pay structures to ensure competitiveness and alignment with industry standards. Our Benefits & Perks: We believe in supporting our Nerds with a truly comprehensive and competitive benefits package designed for flexibility and financial security. - Health & Wellness: Choose from two comprehensive medical plans (including an HSA-eligible option), plus high-quality dental and vision insurance. - Financial Security (Company-Paid): We provide peace of mind by fully covering the cost of several essential plans: Basic Life and AD&D Insurance, Short-Term Disability (STD), and Long-Term Disability (LTD) coverage. - Comprehensive Support: Take advantage of discounted, employee-paid options to protect your family, pets, and assets, including Voluntary Life and AD&D, Accident, Critical Illness, and Hospital Indemnity insurance, Pet Insurance, and plans offering Legal Support and Identity Theft Protection. - Retirement: We offer a 401(k) plan with a company match of up to 3.5% with immediate vesting. - Time Off: Nerds enjoy flexible time off with Flex PTO that can be used for vacation, personal time, personal illness, or time off to care for dependents. - Remote Work: Nerdery is a remote-friendly workplace. Our Minnesota office space is available for Nerds who prefer an in-office environment or collaborative setting. - Professional Growth: All Nerds have dedicated resources and access to funds to pursue professional development, attend industry conferences, and obtain certifications. What Skills Will Help You Be A Successful Nerd? - Customer-Focused Execution and Communication: Excels at translating deep customer understanding into impactful work, ensuring that every project and decision delivers exceptional user value. Able to effectively explain technical decisions to non-technical stakeholders. - Tenacious Problem-Solving: Relentlessly unravels complex problems, developing innovative solutions to overcome any challenge that stands in the way of progress. - Integrity-Driven Work: Builds trust by consistently upholding high standards in all work and advocating for the right approach, ensuring quality and transparency. - Collaborative Impact: Actively elevates the team's capabilities by fostering a collaborative environment, sharing knowledge, and prioritizing collective success over individual credit. - End-to-End Ownership: Takes full accountability for an initiative's entire lifecycle, from concept to completion, ensuring the final result successfully achieves its intended goals. - Dedication to Craftsmanship: Driven by a passion for their craft to continuously learn, deepen their expertise, and strive for excellence in their chosen field. Physical Demands and Work Environment The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable Accommodations may be made to enable individuals with disabilities to perform the functions - Sitting for extended periods: will spend significant time in meetings, presentations, and computer use. - Occasional standing and walking: will need to move around during presentations and client interactions. - Computer Use: Extensive use of a keyboard, mouse, and computer screen for extended periods. Ability to adjust focus between screen and documents. - Public Speaking: requires public speaking, including presenting to clients. - Reaching: Reaching for items on a desk, retrieving documents, or working with equipment is required. - Lifting: Occasional lifting of light objects (e.g., laptops, peripherals) may be necessary. - Office Environment: The work environment is primarily an office setting, with typical office equipment and noise levels. - On-site client work: some work might involve on-site client visits and demonstrations, possibly requiring some walking and standing for extended periods. Are We the Right Fit For You? The best way to get the scoop on whether Nerdery is the right place for you is to chat with current Nerds. We would be delighted to have a conversation with you and share insight into what it’s really like to work at our organization and if it’s a place where you can thrive. Our interview process will provide you ample opportunity to talk with other team members and assess whether the role is a good fit for your next chapter. Take the first step and apply today – our Talent Advocates will then reach out to you to get the ball rolling! Disclaimer: Must be legally authorized to work within the country of employment without sponsorship for employment visa status. Nerdery is an equal opportunity employer and complies with all applicable federal, state and local fair employment practice laws. Nerdery strictly prohibits and does not tolerate discrimination against employees, applicants or any other covered persons because of race, color, religion, creed, national origin or ancestry, ethnicity, sex, sexual orientation, gender (including gender nonconformity and status as a transgender or transsexual individual), pregnancy, marital status, familial status, age, physical or mental disability, citizenship, past, current or prospective service in the uniformed services, genetic information, membership or activity in a local human rights commission, status with regard to public assistance or any other characteristic protected under applicable federal, state or local law. All employees, other workers and representatives of Nerdery are prohibited from engaging in unlawful discrimination. Nerdery will ensure that all employment practices are free of such discrimination. Such employment practices include, but are not limited to: hiring, promotion, demotion, transfer, recruitment or recruitment advertising, selection, layoff, disciplinary action, termination, compensation, benefits, selection for training, including apprenticeship and other terms and conditions of employment. Nerdery will also provide reasonable accommodation to applicants and employees with disabilities pursuant to all applicable laws. Nerdery will never request a chat interview. All interviews are conducted either in person or through Google Meets. Additionally, Nerdery exclusively uses email addresses ending with @‌Nerdery.com If you have questions about any correspondence you receive regarding an opportunity at Nerdery, please reach out to recruiting@nerdery.com.

United States
$130K - $170K / year
ProPharma Group logo

Data Engineer Role

ProPharma Group

ProPharma Group is a privately-held company and leader in serving the device and drug industries with compliance related services. ProPharma Group was founded b

Data Engineer37 days ago

Title: Data Engineer Role Location: Belgrade United States Job Description: Full time job requisition id JR 9253 For the past 20 years, ProPharma has improved the health and wellness of patients by providing advice and expertise that empowers biotech, med device, and pharmaceutical organizations of all sizes to confidently advance scientific breakthroughs and introduce new therapies. ProPharma partners with its clients through an advise-build-operate model across the complete product lifecycle. With deep domain expertise in regulatory sciences, clinical research solutions, quality & compliance, pharmacovigilance, medical information, and R&D technology, ProPharma offers an end-to-end suite of fully customizable consulting solutions that de-risk and accelerate our partners’ most high-profile drug and device programs. ProPharma are seeking a versatile Data Engineer with expertise in Python, SQL, and AWS cloud (Glue and Lambda) to design and optimize modern data pipelines and architectures. Skilled in data modeling, ETL, and database management across PostgreSQL, and SQL Server, this role blends technical problem-solving with strong communication and customer service. Ideal for a quick learner passionate about building scalable, high-performance data solutions in dynamic environments. Main Responsibilities: - Build scalable ETL/ELT pipelines using Python (e.g., Pandas, PySpark), AWS Glue for ingestion, AWS Lambda for transformations, and load into AWS data stores. - Design and manage schemas for relational databases (Amazon RDS, Aurora, PostgreSQL/MySQL). - Optimize queries and indexing for performance and cost efficiency. - Work with OLAP systems such as Amazon Redshift for analytical workloads. - Package Python-based data services with Docker and deploy on Amazon ECS or Amazon EKS. - Integrate databases and AWS services via psycopg2 and boto3. - Develop scripting and automation for recurring data workflows and monitoring tasks. - Maintain data lineage and catalogs using AWS Glue Data Catalog or Apache Atlas. - Ensure compliance with policies for GDPR, HIPAA, and SOC2. - Configure observability and monitoring with Amazon CloudWatch. - Implement error handling and retry strategies in ETL/ELT workflows. - Set up alerting for data pipeline failures or anomalies. - Collaborate with data analysts and scientists to make curated data accessible. - Document pipelines, schemas, and APIs for maintainability and knowledge sharing. - Follow up on tickets to ensure issues are resolved. - Keep good records of communications with colleagues. - Identify and suggest areas for improvement. Necessary Skills and Abilities: - Python: data manipulation, ETL (Extract, Transform, Load) pipelines, automation, and integration tasks. - SQL: querying and manipulating databases - PostgreSQL, MySQL, Microsoft SQL Server: Experience designing schemas, writing queries, and managing data integrity. - AWS, Azure Data services S3, Lambda, Redshift, Glue (AWS) - Data Modeling: Understanding of star/snowflake schemas, normalization/denormalization., partitioning, and optimizing large datasets for analytics. - Data Lakes Experience with modern architectures - CI/CD: Familiarity with tools for deploying data pipelines - Good understanding of computing systems and devices. - Ability to diagnose and resolve technical issues. - Excellent written and oral communications skills. - Strong customer service skills. - Efficient and quick learner. - Strong written and oral communication skills. Educational Requirements: - Degree in relevant subject. - CompTIA Network+ Certification (desirable). - MCDST for Windows 10 Pro (desirable) Experience Requirements: - Minimum three years' experience in technician or similar applicable role. We celebrate our differences and strive to create a workplace where each person can be their authentic self. We are committed to diversity, equity, and inclusion. Employees are encouraged to unleash their innovative, collaborative, and entrepreneurial spirits. With a holistic approach as an Equal Opportunity Employer, we provide a safe space where all employees feel empowered to succeed. All applications to roles at ProPharma are personally reviewed by a member of our recruitment team. We do not rely on AI screening tools to support our hiring process. You will always receive an outcome to your application so that you have an answer from us - whether you're successful or not. Whilst ProPharma supports remote working, we also recognise the value that comes from in person collaboration. As such, we encourage any new hires that are based within a reasonably short commute of one of our offices to work on a hybrid basis and spend some time working from that office location, as agreed with your manager. All applications will be treated on their own merit and candidates will not be at any advantage or disadvantage based on their proximity to an office. ProPharma Group does not accept unsolicited resumes from recruiters/third parties. Please, no phone calls or emails to anyone regarding this posting.

Indiana