Sign upLog in

Senior Data Engineer & Analytics Developer (1086)

BC Forward

Brooklyn, OH

Apply
JOB DETAILS
SALARY
$65–$65 Per Hour
JOB TYPE
Full-time
SKILLS
Apache, Application Programming Interface (API), Artificial Intelligence (AI), Automation, Best Practices, Business Solutions, Cloud Computing, Communication Skills, Compensation and Benefits, Continuous Deployment/Delivery, Continuous Integration, Cost Control, Cron Job Scheduling, Cross-Functional, Data Analysis, Data Management, Data Modeling, Data Sets, Data Warehousing, Desktop PC, Dimensional Modeling, Diversity, Documentation, Establish Priorities, Fortune 500 Customers, GCP (Good Clinical Practices), Git, Government, Information Technology Consulting, Leading Edge Technology, Performance Tuning/Optimization, Production Schedule, Python Programming/Scripting Language, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Scalable System Development, Scripting (Scripting Languages), Star Schema, Structured Data, Tableau, Team Player, Training Data Sets, Use Cases
LOCATION
Brooklyn, OH
POSTED
15 days ago
Job Title: Senior Data Engineer & Analytics Developer (1086)Location: RemoteDuration: Contract - 6 monthsPay Range: $65/hr $65/hr (W2)Job ID: 374488About BCforwardBCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.Job DescriptionWe 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 SummaryWe 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 CompetenciesData Engineering and Pipeline DevelopmentHands-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 DesignDesign 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 DevelopmentEnd-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 StackCloud Platform: Google Cloud Platform (GCP)Data Warehouse: BigQuery (advanced)Orchestration: Cloud Composer / Apache AirflowML Pipelines: Vertex AI PipelinesVisualization: Tableau (Desktop, Server/Cloud)Languages: Python (advanced), SQL (advanced)Infrastructure: Terraform (preferred), GCS, Cloud FunctionsVersion Control: Git / GitLabWhat Sets the Ideal Candidate ApartArchitecture-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 Qualifications5+ 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 CandidateSubmit 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 CriteriaHands-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 CommitmentBCforward 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.

About the Company

B

BC Forward