Databricks Data Warehouse Engineer

Akkodis; Ohio; Remote; USD 125,000 - 155,000; Full time

Benefits offered by this job

Medical/Dental/Vision/Life Insurance

Annual Physical Examination

Health Care Spending Account

401(k) Supplemental Savings Plan

Group Long Term Disability Insurance

Group Life Insurance

Long Term Care Insurance

Four Weeks Vacation Annually

Paid Family Leave

Backup Child Care

Job summary

Akkodis is seeking a Databricks Data Warehouse Engineer for a full-time remote role serving a billion-dollar global employer headquartered in Cleveland, OH. You will lead architecture, implementation, maintenance and support of data warehousing systems in a production environment.

Salary range is $125,000–$155,000 per year, negotiable by experience and location. Must reside within an hour of downtown Cleveland, Pittsburgh, Detroit, Columbus, or Atlanta.

Qualifications

• 5+ years in data warehouse engineering in enterprise production environments.
• 3+ years running live Databricks in production.
• Strong knowledge of SQL Server and T-SQL.

Responsibilities

• Provide strategy and vision for data warehousing platform and tools.
• Develop and improve data asset management and governance strategies.
• Design and implement data models, metadata, and data flows for analytics.

Skills

SQL

Data warehousing

Azure

Live production environment

Enterprise-level production

Tools

Databricks

Azure DevOps

BICEP scripting

Power BI

SSRS

SQL Server

Job description

Akkodis, Inc. is seeking a full-time direct hire and remote Databricks Data Warehouse Engineer for a role with a billion-dollar global employer headquartered in Cleveland, OH. The Databricks DW Engineer provides the appropriate technical leadership, and strategic guidance regarding the architecture, implementation, maintenance and ongoing support of data warehousing systems and toolsets. Qualifications include 5+ years in engineering within data warehouses, SQL, and Azure, all in an enterprise-level production environment, including at least 3 years in a live Databricks production environment.

Salary Range: $125-155K per year; salary negotiable based on experience, education, geographic location, and other factors

This is a great opportunity to work with an employee-oriented organization offering an excellent salary and benefits package including 4 weeks of vacation to start!

Candidates must live within an hour of the downtown areas of the following cities: Cleveland, Pittsburgh, Detroit, Columbus, or Atlanta.

Databricks Data Warehouse Engineer Job Responsibilities Include :

• Provides strategy and vision for increasing the value of the data architecture platform and related data warehousing toolsets.
• Participates in development and continuous improvement of strategies for data asset management and governance, including supporting requirements for security, accuracy, performance, and availability.
• Participates in building and maintaining: Data Models, Data Naming Standards, Enterprise Data Dictionary, Data Asset Inventory, and Data/Information Flows.
• Communicates with relevant data stakeholders to research and help resolve data anomalies and/or data quality issues.
• Assists information workers and development teams with outcome-focused requirements gathering and design of supporting information delivery capabilities. Lead the design, implementation, and continuous delivery of a sophisticated data pipeline supporting applications and reporting.
• Final validation of end-user data warehousing requirements, promoting awareness and understanding of the data available in the data estate by planning and leading effective socialization campaigns, designing, defining and implementing data quality assurance processes and leading the creation of standard data architecture including dimensional model design.
• The Engineer is responsible for monitoring data warehouse loads during periods when successful loads are a requirement (e.g., Year End), working weekends, second shift and/or third shift, as necessary.
• Designs and implements data models to support analytics and reporting initiatives.
• Reviews current database architecture and propose solutions to scale processing and reporting functionality.
• Prepares requirement analysis and documentation for new data and changes to existing data.
• Performs logical and physical design of data warehouse elements.
• Performs source to target mapping for data warehouse elements.
• Maintains metadata information for data warehouse elements.
• Maintains thorough documentation for data models, processes, and any changes made to the data warehouse.
• Ensures seamless data flow between various systems and the data warehouse using data integration tools and techniques.
• Enhances data analysis capabilities through familiarity with advanced analytics tools and techniques, such as machine learning, AI and GenAI.

Qualifications:

• 5+ years of hands-on experience in relational database design and data warehouse design skills within an enterprise-level production environment.
• 3+ years of experience with Databricks, running live in a production-level environment.
• In-depth knowledge of T-SQL and Microsoft SQL Server.
• Skills in SQL Server Reporting Services and Power BI.
• Understanding of medallion architecture.
• Knowledge of Microsoft Fabric is a plus.
• In-depth knowledge of additional data warehousing related Azure resources and toolsets such as Azure storage accounts and Azure DevOps, IaaS concepts, BICEP scripting and SQL PaaS is a plus.
• Familiarity with DAX is preferred.
• Candidates must live within an hour of the downtown areas of the following cities: Cleveland, Pittsburgh, Detroit, Columbus, or Atlanta.

Featured benefits include:

• Medical/Dental/Vision/Life Insurance for Domestic Partners
• Annual Physical Examination
• Health Care Spending Account
• 401(k) Supplemental Savings Plan for Retirement
• Group Long Term Disability Insurance/Supplemental Disability Insurance
• Group Life Insurance/Supplemental Term Life Insurance
• Long Term Care Insurance
• Four Weeks Vacation Annually
• Paid Family Leave for Childbirth or Adoption
• Backup Child Care and Emergency Elder Care

To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.akkodis.com/en/privacy-policy.

Equal Opportunity Employer/Veterans/Disabled

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

• The California Fair Chance Act
• Los Angeles City Fair Chance Ordinance
• Los Angeles County Fair Chance Ordinance for Employers