Offer summary

Qualifications:

Bachelor's degree in Computer Science, Data Analytics, or related discipline (or equivalent experience), 3+ years of relevant experience in data engineering and aggregation, Strong understanding of SQL and experience with commercial ETL tools like SSIS or Python, Ability to leverage data visualization tools such as PowerBI or Looker..

Key responsabilities:

Aggregate and manage data across the enterprise to provide insights for internal teams and external clients

Write SQL for reports and data aggregation, and develop opportunities for improving upstream systems

Produce BI dashboards and operational reports for multiple stakeholder groups

Translate business needs into technical data solutions and ensure data quality and compliance.

Job description

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.

Don't meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Billtrust, we celebrate and support diversity and are committed to creating an inclusive environment for all employees. So, if your experience aligns but doesn't exactly match each and every qualification, apply anyway. You may be exactly what we are looking for!

What You'll Get:

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

Required profile