Analytics Engineer:
As the Analytics Engineer, you will be responsible for aggregating all data across the enterprise, managing that data, and leveraging it to service internal teams and external clients to provide insights and make better business decisions. You will utilize your passion for data to evolve our efforts for ETL processes, data warehousing and data movement. You will work closely with and learn from other data professionals skilled in BI, data science, and data warehousing.
What You'll Do:
● Source system recommendations related to creation of insights or adjustments to data warehouse or mart structures
● Write SQL for reports and data aggregation
● Research gaps within data and develop opportunities for improving the upstream systems/processes
● Manage identified issues through data interpretation and analysis
● Constructs and performs testing of data processes for compliance and data quality
● Assist in identifying and designing attributes for ETL processes
● Contribute to ensuring security is a priority of data movement
● Examine complex data and turn it into information and insight to inform business decisions
● Produce BI dashboards for internal departments
● Build internal and external BI and operational reports for multiple stakeholder groups
● Plans, designs, develops and performs quality assessments on data elements and structures to document and evaluate integrity, completeness, and quality
● Translate business needs into technical data solutions
● Other duties as assigned
What You'll Bring:
● Bachelor degree in Computer Science, Data Analytics or related discipline (or equivalent experience)
● 3+ years of relevant experience
● An attitude that embraces challenging technical tasks
● Excellent problem solving skills around data access and structured data
● A demonstrated understanding of data engineering and data aggregation
● Experience leveraging commercial ETL tools like SSIS or similar, or creating jobs in Python or similar
● Strong understanding of SQL, relational data and non-relational data
● Ability to leverage data visualization tools, such as PowerBI or Looker
● Experience with some of the following nice-to-have: SQL Server, MySQL, MongoDB, DynamoDB, AWS, Azure, Redshift, Snowflake
● Some experience with Modern Data Stack tools like Fivetran, dbt, and similar
● Strong understanding of data models and ability to enhance metadata for data models
● Understanding of Agile, Scrum and Kanban techniques preferred
● Ability to collaborate cross-functionally, and work well in a distributed, team-oriented environment
● Experience in a SaaS, software, product-centric or payments business preferred
The base salary for this position is $90,000.00 - $105,000.00. Compensation may vary depending on several factors, including a candidate’s qualifications, skills, experience, competencies, and geographic location. Some roles may qualify for extra incentives like equity, commissions, or other variable performance-related bonuses. Further details will be provided by our Talent Acquisition team during the interview process.
- Work from Anywhere: Your home, a coffee shop, a company paid WeWork.... you decide!
- A Culture that Lives its Values: Our values are not just words or window dressing, they guide our decisions - big and small - each and every day.
- Flexible Working Hours: We support your lifestyle- the results are what count.
- Open PTO: Work-life balance is important. We believe in giving our employees time to truly relax and recharge.
- Sabbatical: A paid leave to reward longevity and commitment to Billtrust.
- Paid Parental Leave: To promote parent-child bonding and increase gender equity at home and in the workplace.
- Opportunities for Growth: Professional development can take many shapes. Join one of our seven ERGs or participate in our Mentor-Mentee, and Leadership development programs- we foster an environment where all employees can grow.
- Recognition: From Billtrust Bucks and CEO Shoutouts to Culture Champion and CEO Excellence Awards, our employees are recognized for hard work and outcomes achieved.
- Benefits: Medical, dental, vision, 401(k) with company match, short-term and long-term disability, flexible spending accounts, HSA, and life, cancer, and AD&D insurance.
- Minimal Bureaucracy: An entrepreneurial environment of ownership and accountability allows you to get work done.
Who We Are:
Finance leaders turn to Billtrust to control costs, accelerate cash flow and improve customer satisfaction. As a B2B order-to-cash software and digital payments market leader, we help the world's leading brands get paid faster while transitioning from expensive paper invoicing and check acceptance to efficient electronic billing and payments. With over 2,600 global customers and more than $1 trillion invoice dollars processed, Billtrust delivers business value through deep industry expertise and a culture relentlessly focused on delivering meaningful customer outcomes. #LI-Remote
Top Skills
Similar Jobs
What you need to know about the San Francisco Tech Scene
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
