3+ years of experience with Databricks Lakehouse or similar platforms
Bachelor's degree in Computer Science, Business (Accounting), or Information Systems
Strong understanding of data modeling concepts (relational and dimensional)
Proficiency in designing and building reports and dashboards
Excellent written and oral communication skills
Self-motivated with a drive for success in a consulting environment
Ability to manage multiple priorities effectively
Responsibilities
Build and maintain Databricks ingestion pipelines
Support transformations across Bronze, Silver, and Gold layers
Monitor and troubleshoot Databricks scheduled jobs
Create and maintain star schema and related tables
Ensure compliance with data governance standards
Document data lineage and transformation logic
Provide technical assistance and cross-training to team members
Develop SQL Server queries and views
Create operational reports and dashboards in SSRS and Sigma
Recommend improvements for load times and storage costs
Benefits
Flexible work environment with a small team
Opportunity to work with third-party partners
Engagement with business stakeholders for operational reporting
High-energy office atmosphere with multiple ongoing projects
Focus on professional development and cross-training opportunities
Full Job Description
This individual will be responsible for supporting the company's analytics and reporting platform. Development experience with the Databricks Lakehouse or similar product utilizing medallion architecture is essential. Knowledge of SSRS desired and Sigma or other BI Tool preferred. The successful candidate should be flexible with performing a variety of BI related tasks within a small team that includes third party partner(s). The role also entails interacting with business stakeholders to produce operational reports and dashboards.
Essential Duties and Responsibilities
Build and maintain Databricks ingestion pipelines
Support Bronze, Silver and Gold layer transformations
Monitor Databricks scheduled jobs and resolve failed pipeline executions
Support creation of star schema and maintain fact/dimension/bridge tables
Ensure adherence to data governance standards and support Unity Catalog initiatives
Document lineage and transformation logic
Provide technical assistance and cross training to other team members.
Develop and maintain SQL Server queries and views
Create and maintain operational reports and dashboards in SSRS and Sigma
Recommend improvements to reduce load times and storage costs
Must be able to perform duties with moderate to low supervision
Working with key stake holders to make sure deliverables are on clear and concise.
Supervisory Responsibilities
This position will not be supervising any other employees at this time. However, the position does require the indvidual to be personable and team-oriented.
Education/Experience Required
3+ years experience developing and implementing at enterprise-scale within Databricks Lakehouse or similar platform
Knowledge of logical and physical data modeling concepts (relational and dimensional)
A Bachelor's degree in Computer Science, Business (Accounting) and/or Information Systems degree
Ability to design and build insightful reports and dashboards
Ability to multi-task and manage priorities.
Excellent communication skills, both written and oral
Self-motivated and driven to achieve success within a consulting environment
Computer Skills Necessary
Data Warehouse Medallion architecture, Databricks strongly preferred
Experience with BI tool like Sigma (preferred),Power BI, Tableau or Qlik
Crystal Reports, SSRS, or similar reporting tools
Microsoft SQL Server T-SQL
Databricks SQL
Git version control
Knowledge of PySpark and Python programming
Microsoft Office Applications
Physical Demands/Requirements
Primarily sedentary role requiring extended periods of sitting, frequent use of computers, and regular communication. Must possess strong analytical, attention to detail, and problem-solving skills.
Work Environment
Working in high-energy office environment with several ongoing projects.
