Remote Open Source Developer Jobs in Ohio (NOW HIRING)

Job Description We are seeking a Senior Data Engineer & Analytics Developer to join our dynamic team. The ideal candidate will have strong experience in GCP, BigQuery, Cloud Composer, Python, SQL, and Tableau and a proven ability to design scalable data architectures, build robust pipelines, and deliver production-quality Tableau dashboards end to end. Responsibilities: Design and implement scalable data pipelines in GCP using BigQuery, Cloud Composer, and Python.

Model layered datasets for reuse using medallion and dimensional patterns with clear documentation and governance. Develop end-to-end Tableau dashboards, including data source design, performance tuning, and publishing workflows. Optimize BigQuery cost and performance through partitioning, clustering, and materialized views.

Orchestrate production-grade workflows with scheduling, retries, and dependency management in Cloud Composer. Partner with cross-functional stakeholders to translate requirements into scalable data solutions and self-serve analytics. Required Skills & Qualifications: Advanced proficiency in Python and SQL for data transformation, pipeline logic, and performance optimization.

Hands-on experience with GCP services including BigQuery, Cloud Composer (Apache Airflow), GCS, and Cloud Functions. Proven ability to design reusable, modular datasets and apply medallion and star schema patterns. Track record of building production-quality Tableau dashboards on well-modeled data layers.

5+ years in data engineering roles with meaningful GCP/BigQuery experience. Preferred Skills: Experience with Vertex AI Pipelines and ML workflow orchestration. Infrastructure-as-code with Terraform and CI/CD for data pipelines.

Familiarity with Data Vault modeling and targeted denormalization practices. Experience with Jupyter notebooks and Git/GitLab workflows. Why BCforward?

At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to: Competitive compensation and benefits. Opportunities for growth with global clients.

A supportive, inclusive culture that values innovation and people. Exposure to cutting-edge technologies and projects. Role Summary We are seeking a Data Engineer with strong analytics capabilities who can own the full data lifecycle from scalable pipeline development to polished Tableau dashboards.

The ideal candidate thinks architecturally, designs datasets for reuse and longevity, and avoids one-off solutions. The role requires proficiency in Python and SQL as primary working languages and Tableau for reporting. Core Competencies Data Engineering and Pipeline Development Hands-on BigQuery expertise including dataset design, partitioning and clustering, materialized views, and cost optimization.

Proficiency with Cloud Composer for orchestrating production pipelines with schedules, retries, and dependencies. Experience building and maintaining Vertex AI Pipelines for ML and large-scale transformations. Advanced SQL including window functions, CTEs, recursive queries, and tuning.

Strong Python for transformation scripts, custom Airflow operators, API integrations, and automation. Data Architecture and Scalable Design Design of layered architectures using Medallion, Dimensional Modeling, Data Vault, and targeted denormalization as appropriate. Creation of modular, multi-purpose datasets with canonical models and shared dimensions.

Disciplined approach to table creation versus extension or views to prevent duplication and sprawl. Adherence to best practices for naming, schema organization, documentation, and lifecycle management. Tableau Dashboard Development End-to-end Tableau development from data source configuration and extract optimization to interactive visual design.

Translation of business questions into clear, intuitive visualizations for self-service. Knowledge of performance tuning, published data sources, and server or cloud publishing workflows. Alignment of upstream data modeling with downstream dashboard performance.

Technical Stack Cloud Platform: Google Cloud Platform (GCP) Data Warehouse: BigQuery (advanced) Orchestration: Cloud Composer / Apache Airflow ML Pipelines: Vertex AI Pipelines Visualization: Tableau (Desktop, Server/Cloud) Languages: Python (advanced), SQL (advanced) Infrastructure: Terraform (preferred), GCS, Cloud Functions Version Control: Git / GitLab What Sets the Ideal Candidate Apart Architecture-first thinking that prioritizes extension and reuse. Efficiency over volume with minimal pipelines supporting broad use cases. End-to-end ownership from ingestion to Tableau dashboards.

Pragmatic scalability that balances present needs with future growth. Experience and Qualifications 5+ years in a data engineering role with substantive GCP and BigQuery experience. Advanced proficiency in Python and SQL as daily working languages.

Demonstrated design and maintenance of shared, reusable data models at enterprise scale. Familiarity with medallion, star schema, and Data Vault patterns. Portfolio or examples of Tableau dashboards built on well-structured data layers.

Familiarity with CI/CD practices and infrastructure-as-code concepts. Strong communication and cross-functional collaboration skills. Questions for Candidate Submit written answers with the resume.

How many Tableau dashboards have you built end to end, including the data layer, and how did you build them. How familiar are you with Cloud Composer. When would you use it over a scheduled notebook or a cron job.

Describe an example where you combined data from multiple sources into a single dataset for reporting. How did you decide to structure it. Top Resume Review Criteria Hands-on experience with SQL, Python, GCP, BigQuery, Cloud Composer, GCS, Cloud Functions, and Jupyter notebooks demonstrated through pipeline builds, dataset design, or architecture decisions.

Evidence of scalable architecture thinking including reusable models, layered architectures, and consolidation over one-off projects. Tableau dashboard development paired with data modeling, showing ownership of both the data layer and the visualization. About Our Commitment BCforward is an equal opportunity employer.

We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status. Interested?

Apply Now! If this sounds like the right opportunity for you, please apply with your most recent resume and include answers to the candidate questions.