Design, build, and maintain dbt models and semantic metrics; convert ad-hoc SQL into fact/dimension models; implement tests, documentation, and quality checks; optimize SQL for AWS Athena; use Git for collaborative development; and support downstream analytics and Power BI reporting.
One Park Financial (OPF) is a fast-growing FinTech (Financial Technology) company headquartered in Coconut Grove, Florida. OPF connects small businesses with flexible financing and funding options to help entrepreneurs acquire the working capital they need to grow.
We are seeking an Analytics Engineer to help elevate our analytics platform by applying best practices in dbt modeling, metrics design, and analytics engineering. This role partners closely with analytics and business stakeholders to transform raw SQL and data sources into well-structured, tested, and scalable data models that power reporting and decision-making.
This position sits at the intersection of analytics and engineering, with a strong focus on data modeling, metric definitions, semantic consistency, and maintainable analytics code.
- Design, build, and maintain dbt models following analytics engineering best practices.
- Convert ad-hoc SQL and legacy queries into clean, scalable fact and dimension models.
- Define and maintain standardized business metrics and semantic models in dbt.
- Implement data tests, documentation, and quality validation processes.
- Optimize SQL queries for performance in AWS Athena.
- Collaborate with analysts and business stakeholders to align on metric definitions and reporting logic.
- Use Git/GitHub for version control, peer reviews, and collaborative development.
- Support downstream analytics and Power BI reporting use cases.
Requirements
- 3+ years of experience in Analytics Engineering, Data Analytics, or Data Engineering.
- Strong hands-on experience with dbt (Core or Cloud).
- Advanced SQL skills with experience optimizing queries in AWS Athena.
- Experience modeling structured data using fact/dimension frameworks.
- Experience working with Amazon S3 and modern data lake environments.
- Familiarity with Git-based workflows and code reviews.
- Strong communication skills with the ability to align technical and business stakeholders.
- Experience with dimensional modeling (Kimball methodology).
- Experience designing or managing semantic/metrics layers.
- Familiarity with data lake or lakehouse architectures.
- Exposure to AWS Glue.
- Experience supporting Power BI reporting environments.
Monday–Friday, standard business hours
On-site position based in Miami, Florida
Benefits
- Competitive salary
- 401(k) with company match
- Health insurance
- Dental & vision insurance
- Life insurance
- Paid time off
- Office snacks
- Monthly events
- Collaborative and growth-oriented work environment
Top Skills
Dbt,Sql,Aws Athena,Amazon S3,Git,Github,Power Bi,Aws Glue
Similar Jobs
Information Technology
Design, build, and operationalize cloud-based data pipelines and transform raw data into analysis-ready datasets. Collaborate with business, analytics, and engineering teams to develop data models, automate data preparation, and document transformations. Support Power BI models and dashboards, improve data accessibility and reliability, and mentor peers while exploring new data technologies and automation techniques.
Top Skills:
AzureAzure Data FactoryAzure Data LakeFabric Data FactoryLlm-Based ToolsPower BIPythonSQLSsis
Retail • Sales
Design, build, and optimize ETL pipelines and scalable data models to support analytics and data science. Collaborate with stakeholders to translate business needs into data solutions, improve data quality, and enable data-driven decisions across the organization.
Top Skills:
Sql,Python,R,Java,Etl Tools,Hadoop,Spark,Hive,Redshift,Snowflake,Bigquery,Tableau,Power Bi,D3.Js,Qlikview,Looker,Sas,Aws,Azure,Google Cloud,Cloudera
Software • Analytics • PropTech
Build and maintain scalable People Analytics data pipelines and models using SQL, Python, Snowflake, and dbt. Monitor and automate ETL, implement testing, support reporting and dashboards (e.g., Looker), partner with HR/Finance/Payroll, and contribute to tooling, automation, and AI/LLM initiatives to ensure data quality and reliability.
Top Skills:
Sql,Python,Snowflake,Dbt,Fivetran,Looker,Airflow,Dagster,Gitlab Ci/Cd,Jenkins,Git,Aws,Workday,Qualtrics,Lms,Ai/Llm
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
