Senior Data Analytics Engineer

About Flex Analytics:
Flex Analytics is a Data Analytics services company and creator of FlexIt, our self-servicebusiness intelligence (BI) platform that integrates with dbt Cloud and Core as a semantic layer. As a proud partner of dbt Labs, wespecialize in building modern data products and services that enable our customers to truly self-serve. We firmly believe that thecornerstone of successful self-service BI initiatives lies in a strong foundational framework with a focus on data reliability,observability, data catalogs, semantic layers, data governance, rigorous testing capabilities, data transformation, continuous integration,and an agile approach to delivery. At Flex Analytics, we take a holistic approach to enterprise-grade modern datasolutions.
About the Role:
Flex Analytics is bringing the modern data stack to higher education. As theSenior Data Engineer, you’ll drive the vision and direction of Analytics Engineering and data infrastructure. You’ll work on thedesign and development of data products that can be deployed as “off-the-shelf” products for higher education customers usingdata mesh, allowing them to plug FlexIt Analytics into a common data platform independent of source systems. You will be the first full-timeemployee and work directly with the founder. You’ll also be responsible for growing and mentoring our data team as we expand. You musthave a deep understanding of enterprise-grade architecture and organizations, with knowledge of how to modernize traditional/legacy toolsand architectures within the constraints of higher education institutions.
The ideal candidate has broad experience with dbt and dataAnalytics Engineering best practices, as well as knowledge of higher education data. However, we understand that the modern data stack isvery new to higher education. Therefore, we are interested in candidates that excel with higher education data and want to learn new toolsand processes, or candidates that excel with the modern data stack and are interested in learning and developing higher education dataproducts.
Responsibilities:

• Design and develop data products that can be deployed as“off-the-shelf” products using dbt, “off-the-shelf” meaning agnostic to source systems and destination cloudwarehouses.
• Work on our all-in-one software products that integrate with dbt to provide data reliability, observability, datacatalogs, semantic layers, data governance, rigorous testing capabilities, data transformation, and continuous integration.
• Leadthe design and implementation of dimensional data warehouse models for research, analysis, and reporting/dashboarding.
• Workcollaboratively with customers to create analytics solutions that are scalable, easy to maintain, and support self-service in both cloud andon-premises environments.
• Design solutions that are simple, easy to deploy and that customers can maintain with limited resourcesand limited ongoing external support.
• Implement code testing, continuous integration, and deployment strategies to ensurereliability.
• Design and implement pipelines to integrate data coming from disparate databases, APIs, flat files, or othersources.

Requirements:

• 5+ years of relevant data experience
• Very high proficiency withdbt Cloud and dbt-core
• Very high proficiency with Kimball dimensional modeling
• Very high proficiency in SQL (aggregatefunctions, window functions, complex joins, CTE), including query optimization skills.
• Experience designing, implementing, andmaintaining modern ELT pipelines.
• Proficiency with modern cloud data warehouses (AWS Redshift, Snowflake, etc.)
• Understanding of enterprise-grade systems and data architectures.
• Knowledge of software engineering best practices andteam-based development using Git
• Experience collaborating with disparate teams to deliver sustainable architectures that betterserve the data needs of the business.
• A problem solver with a self-starter mindset that can adapt well to changing priorities.

Nice to Have:

• Experience in higher education is desirable, but not required.
• Knowledge ofAWS services and security, including EC2, Redshift, DMS, Glue, security groups, networking, and storage.
• Knowledge ofInfrastructure as Code tools and best practices (Terraform, CloudFormation)
• Familiarity with traditional relational databases (SQLServer, Oracle, Postgres, etc.)
• Some familiarity with BI tools (Power BI, Tableau, Looker, FlexIt Analytics, etc.)

What we offer:

• Competitive compensation with opportunities for salary growth, revenue sharing andequity
• Flexible remote work policy with hybrid option in San Francisco
• Flexible work schedule and environment
• Generous time off policy to balance your work and life, including paid parental leave
• Competitive medical, dental, and visioncoverage for you and your dependents
• Commuter benefits for San Francisco Bay Area candidates

At this time, FlexAnalytics is hiring for candidates located in the United States and does not sponsor candidates and cannot accept those on OPT or CPT.