Description
Essential Duties and Responsibilities:
Knowledge of database coding and tables; as well as general database management
Understanding of client management, support, and communicating progress and timelines accordingly
Organizes and/or leads Informatics projects in the implementation/use of new data warehouse tools and systems
Ability to train new hires; as well as lead in training of new client staff members
Understanding data schema and the analysis of database performance and accuracy
Understanding of ETL tools, OLAP design, and data quality processes
Knowledge of Business Intelligence life cycle: planning, design, development, validation, deployment, documentation, and ongoing support
Working knowledge of electronic medical records software (eCW, Nextgen, etc) and the backend storage of that data
Ability to generate effective probability modeling and statistics as it pertains to healthcare outcomes and financial risks
Ability to manage sometimes lengthy and complicated projects from throughout the life cycle and meet the deadlines associated with these projects
Development, maintenance, technical support of various reports and dashboards
Knowledge of Microsoft SQL including coding language, creation of tables, stored procedures, and query design
Fundamental understanding of outpatient healthcare workflows
Knowledge of relational database concepts and flat/formatted file processing.
Possesses strong commitment to data validation processes in order to ensure accuracy of reporting (internal quality control)
Possesses a firm grasp of patient confidentiality and system security practices to prevent HIPAA and other security violations.
Knowledge of IBM Cognos or other database reporting software such as SAS, SPSS, and Crystal Reports
Ability to meet the needs of other members of the Informatics department to maximize efficiency and minimize complexity of end-user products
Requirements:
Education: Bachelor's Degree
Proven experience as a dbt Developer or in a similar Data Engineer role.
Expert-level SQL skills - capable of writing, tuning, and debugging complex queries across large datasets.
Strong experience with Snowflake or comparable data warehouse technologies (BigQuery, Redshift, etc.).
Proficiency in Python for scripting, automation, or data manipulation.
Solid understanding of data warehousing concepts, modeling, and ELT workflows.
Familiarity with Git or other version control systems.
Experience working with cloud-based platforms such as AWS, Google Cloud Platform, or Azure.
Requirements
Key Responsibilities
Advanced SQL Development: Write and optimize complex SQL queries and dbt models for data transformation and analysis within Snowflake.
DBT Model Development: Build, test, and maintain dbt models that convert raw data into actionable insights.
ETL/ELT Pipeline Management: Design and manage efficient pipelines using dbt, OpenFlow, and Python to process and deliver data across systems.
SQL Performance Tuning: Optimize query performance, clustering, and cost efficiency in Snowflake
Data Quality Assurance: Ensure that transformed data meets accuracy and consistency standards through dbt testing and validation frameworks.
Collaboration: Work closely with data engineers, analysts, and architecture leads to translate data requirements into scalable transformations
Data Documentation: Maintain clear documentation for dbt models, data flows, and dependencies for ongoing visibility and reuse
Version Control: Manage dbt and Python projects in Git, following clean, modular, and testable development practices
Automation Support: Partner with automation en
Apache Spark, Python, Apache Hadoop, Apache Kafka, ETL - Extract Transform Load, Data Build Tool (DBT), Snowflake
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: rhalfint
- Position Id: 00720-0013372824
- Posted 9 hours ago
Never miss an opportunity! Create an alert based on the job you applied for.