Data Analytics Engineer

Job DetailsJob Location: Fort Collins, CO 80528Position Type: Full TimeSalary Range: $102,000.00 - $146,900.00 SalaryTravel Percentage: NoneJob Category: EngineeringBillGO is building the next generation of payment and money movement infrastructure for small businesses. Data products and insights are core to how we scale reliability, reduce operational friction, and deliver better outcomes across payments, risk, and support.  We are looking for an Analytics Engineer to join our growing data team and help transform payments data into reliable, scalable, and actionable insights. Sitting at the intersection of data engineering, analytics, and business, you will build clean data models, define key metrics, and enable stakeholders across product, finance, risk, and operations to make data-driven decisions.   This role is ideal for someone who understands the complexity of payments ecosystems (transactions, settlements, fraud, reconciliation) and enjoys turning messy data into trusted, well-documented datasets.  Why This Role Matters This role matters because it transforms complex, fragmented payments data into a trusted foundation for decision-making across the business. As an Analytics Engineer, you enable teams to operate with clarity and confidence by building reliable data models, defining consistent metrics, and ensuring data integrity in a highly intricate financial ecosystem. In a space where accuracy, speed, and compliance are critical, your work directly impacts everything from revenue visibility and reconciliation to fraud detection and operational efficiency. By bridging the gap between raw data and business insight, this role not only improves day-to-day performance but also helps scale the company’s data infrastructure, empowering smarter decisions and driving long-term growth in a rapidly evolving fintech landscape. What You’ll Do Design, build, and maintain scalable data models for customers, payments, transactions, settlements, and financial reporting   Transform raw data into clean, reliable datasets and data models.  +Using tools like Claude, Coalesce, and Tableau   Using data warehouses like Snowflake, AWS RDS, AWS DynamoDB  Also incorporating other data sources from AWS S3, like csv, Json, and parquet files.  Develop data dictionaries, semantic layers, and data catalogs  Partner with Product, Finance, Risk, and Operations teams to define key metrics and enable insights and dashboards for decision-making and predictions.   Ensure data quality and integrity through testing, monitoring, and documentation   Optimize data pipelines for performance and cost efficiency   Translate business requirements into data solutions that scale with company growth   Support regulatory and financial reporting needs (e.g., reconciliation, audit readiness)   Contribute to data governance, definitions, and metric standardization What You Bring 3+ years of experience in an analytics engineering, data analytics, or data engineering role  Strong SQL skills, data analytics skills, ability to interrogate data and derive impactful insights.   Experience with Coalesce or similar transformation frameworks   Experience with data warehousing (Snowflake)   Experience modeling complex datasets (fact/dimension modeling, star schemas)   Experience building metrics layers or semantic models   Understanding of ELT pipelines and data orchestration tools  Experience with Python for data processing   Experience with version control using Github and Github actions  Ability to translate ambiguous business questions into structured data models   Strong attention to detail and data accuracy   Experience working with cross-functional stakeholders     Preferred Qualifications  Data Science and Machine Learning hands-on experience.   Familiarity with event-driven architectures or streaming data   Experience working with payments data  Familiarity with concepts like:   Authorization & settlement flows   Interchange & fees   Chargebacks & disputes   Fraud detection signals   Ledgering and reconciliation   Exposure to compliance or financial reporting requirements     Compensation We offer a competitive compensation package, including: Base salary ($102,000-$146,900) Performance incentive Equity opportunities Comprehensive health, retirement, and lifestyle benefits This role is about more than compensation, it’s about the opportunity to transform how small businesses thrive in the digital economy.