Senior Data Warehouse Engineer

Our Company:

Since being founded in 1, BlackLine has become a leading provider of cloud software that

automates and controls the entire financial close process. Our vision is to modernize the finance

and accounting function to enable greater operational effectiveness and agility, and we are

committed to delivering innovative solutions and services to empower accounting and finance

leaders around the world to achieve Modern Finance.

Our Values:

1. Customers First: Meaningfully deliver high-quality value to our customers

2. Continuous Improvement: Foster improvements to our work and its quality, our

teams, and our company

3. Integrity: Honest, collaborative, and supportive, always working to honor our

commitments and take pride in our work

4. Teamwork: Partnering with and supporting others, leading selflessly, and advocating for

our collective success

5. Initiative: Capitalize on creative approaches, problem-solving, and building the right things

at the right time to deliver the right value to our customers

6. Diversity: Open, inclusive, and supportive of all our team members and peers

We are a technology-based company with a sense of adventure and a vision for the future. Every door

at BlackLine is open. Just bring your brains, your problem-solving skills, and be part of a winning team

at the world's most trusted name in Finance Automation. 

Work, Play and Grow at BlackLine

The Senior Data Warehouse Engineer will enable the company’s use of data as a strategic asset of

corporate goals and objectives. He or She will be responsible for strategically designing, developing,

and implementing enterprise-level BI solutions, data integrations and analytical applications. This

role is responsible for understanding and documenting data sources, usage, and lineage for

enterprise information. The role must drive the completion of projects within the established scope,

while simultaneously planning for and managing unknown future BI requirements in a dynamic

environment.

· Analyzes business and technical requirements, translate them to high level design documents.

· Design and implement BI tools and processes for data intake from multiple sources.

· Establish and maintain data security and compliance, access controls, data governance.

· Design and implement user analytical and visualization tools.

· Provide support to the BI users on the effective use of reporting tools and data structure

· Identify requirements, design, create, deploy, monitor, and support BI reports and dashboards,

shared object, and cubes to empower discovery and information-sharing for business partners.

· Utilize expertise and knowledge of data modeling, ETL, and report design for department

initiatives, and produce detailed documentation including data flow diagrams, logical diagrams,

and physical diagrams as needed.

· Lead small to medium scope projects interfacing with development teams, business analysts, IT

management and members of the business unit

data warehouse environment

· 5+ years technical experience working with the MS SQL stack and surrounding technologies,

SQL, SSAS, SSIS, SSRS.

· BS degree in Computer Science, or equivalent experience.

· Solid understanding of warehouse design, data engineering and/or data governance.

· Understands the range of options and best practices for common ETL design techniques such as

change data capture, key generation, and optimization.

· Solid understanding of relational and dimensional database domains.

· Strong experience with data warehouse, ETL and BI technologies.

· Strong experience working with large and complex datasets.

· Advanced SQL query and performance tuning skills.

· Software and scripts development experience.

· Advanced knowledge of on-prem and cloud-based IT infrastructure.

· Expertise with data visualization tools such as Power BI

· Experience working with Azure particularly with Azure Analysis Services (AAS).

· Experience working with build pipelines through DevOps and/or Azure.

· Experience with Visual Studio, GIT, DevOps, and version control.

· Experience with complex systems

· Exposure to and understanding of data modelling – SSAS Tabular, DAX

· Experience with PowerShell and the PowerBI and Azure modules

· Experience with object orientated languages such as C# an advantage

· Experience working with external APIs to extract and import data

· Strong analytical and troubleshooting skills

· Highly motivated self-starter, detail, and quality oriented and ability to handle multiple competing priorities. · Must be a strong team player with a positive attitude and enthusiasm to get things done. · Presentation skills to various levels of the organization including executive management. · Excellent communication (both written and verbal), interpersonal skills and experience

· Autonomy - Able to size effort for a feature/epic, break it down into user stories and implement them independently. · Complexity & Ambiguity - Able to take high level requirements for an epic and turn them into an actionable plan, including cross team dependencies. · Coding & Debugging - Coding skills in one or more programming languages, Intermediate system level optimization and debugging skills. Regularly uses observability tools to diagnose issues. · Design & Architecture - Designs solutions at module/class level while considering non-functional aspects, such as, performance, scalability, availability, and security. Assists senior members on product level design. · Busines Acumen & Strategy - Understands the team's domain well with a basic understanding of adjacent areas. Contributes to feature ideas and surfacing of tech debt. · Influence - Openly shares opinions and contributes to discussions and decision making. Review’s code of junior team members and is often a mentor for them. Participates in staff recruitment.

• A technology-based company with a sense of adventure and a vision for the future. Every door at BlackLine is open. Just bring your brains, your problem-solving skills, and be part of a winning team at the world's most trusted name in Finance Automation
• A culture that is kind, open, and accepting. It's a place where people can embrace what makes them unique, and the mix of cultural backgrounds and varying interests cultivates diverse thought and perspectives.
• A culture where BlackLiner's continued growth and learning is empowered. BlackLine offers a wide variety of professional development seminars and inclusive affinity groups to celebrate and support our diversity.

BlackLine is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity or expression, race, age, religious creed, national origin, physical or mental disability, ancestry, color, marital status, sexual orientation, military or veteran status, status as a victim of domestic violence, sexual assault or stalking, medical condition, genetic information, or any other protected class or category recognized by applicable equal employment opportunity or other similar laws.

BlackLine recognizes that the ways we work and the workplace itself has shifted. We innovate in a workplace that optimizes a combination of virtual and in-person interactions to maximize collaboration and nurture our culture. Candidates who live within a reasonable commute to one of our offices will work in the office at least 2 days a week.