Full Stack Software

Job Title: Full Stack Software Engineer

Location: Columbus, OH

Job Type: Contract

Experience Level: Mid-Senior Level (5+ Years)

Job Summary:

We are seeking a highly skilled Full Stack Software Engineer to support the modernization of the ProfitView platform. This role requires strong expertise in PySpark, ETL processes, and Dremio, with a preference for candidates who bring financial systems experience. You’ll be responsible for developing and maintaining data-driven solutions that support Financial Attribution, Slowly Changing Dimensions (SCD), Data Aggregation, Data Quality Engine development, and sourcing data from System of Record platforms. Prior experience in profitability or financial reporting environments is highly desirable.

Key Responsibilities:

Lead the design and development of full-stack solutions for the ProfitView modernization project.

Build and optimize scalable ETL pipelines using PySpark.

Integrate with and optimize data access using Dremio.

Implement financial data models and attribution logic aligned with business objectives.

Manage and evolve SCD frameworks to handle complex historical data.

Ensure high standards of data quality through the development of validation engines.

Source and normalize data from authoritative systems of record.

Collaborate with cross-functional teams including business analysts, data engineers, and financial stakeholders.

Create documentation and support user adoption of new features and processes.

Utilize Power BI for visualization and reporting (nice to have).

Required Qualifications:

5+ years of Software Engineering experience, or equivalent demonstrated through work, consulting, training, military experience, or education.

Proficiency in PySpark and building large-scale ETL workflows.

Experience with Dremio or similar SQL-based data lake engines.

Strong understanding of financial systems and data, particularly related to profitability and attribution.

Knowledge of data architecture and practices around SCD, aggregation, and quality assurance.

Experience working with modern full-stack development tools and practices.

Excellent problem-solving, collaboration, and communication skills.