Data Engineer (Onsite, Remote, Hybrid)

SUMMARY We are searching for an accountable, multitalented data engineer to build, expand and optimize our data and pipeline architecture. Data pipeline architecture is the design and structure of objects, systems, and processes that extract, regulate, transform, and route data from various sources to destination systems, such as data warehouses, data lakes, analytic tools, or visualizations . Data pipeline architecture aims to obtain valuable insights from the data for different use cases, such as business intelligence or machine learning. To ensure success as a data engineer, you should demonstrate flexibility, creativity, and the capacity to receive and utilize constructive criticism. A formidable data engineer will demonstrate unsatiated curiosity and outstanding interpersonal skills. Being able to work, collaborate and communicate with a team of administrative and clinical staff is imperative. They must be self-directed and comfortable supporting the data needs of multiple teams and systems. The right candidate will be excited by the prospect of re designing and optimizing our company’s data architecture to support our next initiatives. ESSENTIAL FUNCTIONS AND RESPONSIBILITIES Assembling large, complex sets of data that meet non-functional and functional business requirements Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes Building required infrastructure for optimal extraction, transformation and loading of data from various data sources and SQL technologies Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency, clinical excellence, and compliance Working with stakeholders and executive teams and assisting them with data-related technical issues Create and maintain optimal data pipeline architecture Assemble large, complex data sets that meet functional / non-functional business requirements Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Build analytics tools that utilize the data pipeline to provide actionable insights into clinical operations, operational efficiency, and other key business performance metrics Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs Create data tools for analytics and team members that assist them in building and optimizing our product into an innovative industry leader Work with data and analytics experts to strive for greater functionality in our data systems QUALIFICATIONS Bachelor's degree in data engineering, big data analytics, computer engineering, or related field. Master's degree in a relevant field is advantageous. Proven experience as a data engineer, software developer, or similar. Strong experience with business intelligence environments such as Power BI and Sisense. Excellent analytical and problem-solving skills. A knack for independence and group work. Scrupulous approach to duties. Capacity to successfully manage a pipeline of duties with minimal supervision. Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Experience building and optimizing ‘big data’ data pipelines, architectures, and data sets. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, metadata, dependency, and workload management. A successful history of manipulating, processing, and extracting value from large disconnected datasets. Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores. Strong project management and organizational skills Experience supporting and working with cross-functional teams in a dynamic environment BENEFITS (Full-Time Staff Only) 95% Employer Paid Health Insurance Plan Dental Insurance Vision Insurance Some Positions Qualify for NHSC Student Loan Repayment 403B Retirement Plan with 5% Employer Contribution Annual Professional Growth Funds 3 Weeks Paid Time-off Employer Paid Life Insurance and Long Term Disability All Red Rock BHS employees are required to be fully vaccinated, as per Centers of Medicare and Medicaid Services Standards, unless otherwise exempt. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities Red Rock Behavioral Health Services does not discriminate based on race, color, national origin, religion, gender, gender identity, age, marital/familial status, sexual orientation, or disability. PI219996150